Category Archives: Development

The Correct Way to Compare QTD to the Previous Quarter

How leveraging simple math tricks can dramatically increase the accuracy of your Quarter to Date (QTD) versus Previous/Prior Quarter to Date (PQTD) comparisons.

Posted in Development, Tips & Tricks | Tagged , , , | Leave a comment

Saving on Clicks: Selectively Recovering the QlikView Session Components Your Users Care About

Leverage the power of inputfields to automatically take each user back to the views/selections he or she uses most. This tip is sure to win you popularity contests!

Posted in Development, Tips & Tricks | Tagged , , | 1 Comment

Drop Early, Drop Often

Don’t wait until the end of your QlikView load script to drop temporary tables—get rid of them as soon as possible and reap rewards in the form of memory, CPU, and time savings!

Posted in Development, Tips & Tricks | Tagged , , | 5 Comments

Displaying Multiple Non-Consecutive Date Ranges in QlikView

A modular, plug-and-play approach to displaying beautiful multiple non-consecutive date ranges in QlikView!

Posted in Development, Tips & Tricks, Visualization | Tagged , | 4 Comments

Mathematical Series in QlikView: An Exercise in Advanced Syntax

Covering concatenated value-loops, dollar-sign expansion, nested dollar-sign expansion, and variable parameters!

Posted in Development, General, Tips & Tricks | Tagged , , , , , | 3 Comments

Better QlikView Trend Lines

Build your own completely customizable trend lines in QlikView!

Posted in Development, Tips & Tricks, Visualization | Tagged , , | 5 Comments

Speeding Up Conditional Expressions

Most QlikView developers have experienced first-hand the havoc that a complex conditional expression can wreak on the performance of their otherwise beautiful application. In this article, we discuss a simple way that some of these expressions can be improved to … Continue reading

Posted in Development, Tips & Tricks | Tagged , , , , | 12 Comments

"AND" and "NOT" List Boxes in QlikView

When you select multiple values of a single filter in QlikView, the native behavior is an “OR” operation‒charts will display data points that are associated with any of the selected filter values. This article will show you how you can … Continue reading

Posted in Development, Tips & Tricks | Tagged , , , , | 11 Comments

Conditional Back/Forward Buttons

A neat feature of QlikView’s built-in back/forward buttons is that they are available only when relevant‒i.e. when a back or forward selection is possible. This article will teach you how to create this same conditional effect in your own back … Continue reading

Posted in Development, Tips & Tricks | Tagged , , , , | 2 Comments

Section Access: Circular References Are (Maybe) OK!

I want to share an accidental discovery that will likely change the way you implement QlikView Section Access forever—it certainly did for us and our clients!

Posted in Development, Security, Tips & Tricks | Tagged , , , | 9 Comments
Blog Home
Archives