Category Archives: Development

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

Sort Continuous X-Axis Descending

A continuous X-axis, particularly in a line chart, is a great way to display certain types of trends in QlikView. For example, setting your x-axis to continuous is the only way to enable X-axis reference lines. In addition, if you … Continue reading

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

Dynamic Row Sorting / Prioritization

This article will describe a method of allowing users to, on the fly, prioritize rows in a pivot or straight table in QlikView!

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

True Dynamic Bucketing in QlikView

Everyone knows that you cannot define buckets dynamically in QlikView, right? Not quite—this article will describe precisely how to give your users this ability!

Posted in Development | Tagged , , | 5 Comments

QlikView Zero Line Fix

If you have ever been bothered by QlikView suppressing line chart time data points for unassociated values (instead of making the line(s) go down to zero, this article will describe a sophisticated workaround that will not require you to concatenate … Continue reading

Posted in Development | Tagged , , | 7 Comments

Normalize or Denormalize: The Results Might Surprise You

There has been a long-standing debate in the QlikView world regarding when a data model should be normalized (i.e. split out into a one or more “Fact” tables and one or more “Dimension” tables) and when it should be denormalized … Continue reading

Posted in Development | Tagged , , | 11 Comments

Saving memory with Interval Match

As veteran QlikView users well know, Interval Match can be one of the most powerful functions available to developers. Interval Match is used to match a date/timestamp in one table to an interval in another (defined by a numeric start … Continue reading

Posted in Development | Tagged , , , | 5 Comments
Blog Home
Categories
Archives