Category Archives: Tips & Tricks

Top N: We Can Do Better

The case for showing slices of data more intelligently.

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

Violin Plots: What They Are and Why You Should Care

Continuing our series on little-known charts and how to implement them in QlikView!

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

Dots & Lollipops

Easily create dot plots and lollipop plots in QlikView!

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

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

Bypassing QlikView Section Access

Today we are going to learn one very simple technique for bypassing QlikView Section Access security.

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

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 , , | 4 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

Setting a Default Domain with QlikView Web Form Authentication

This article will demonstrate a simple code change that you can implement to automatically prepend a domain name to a username during a web form authentication logon!

Posted in QlikView Server, Tips & Tricks | Tagged , , , | 6 Comments