Archives

Category Archives: Tips & Tricks

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

Better QlikView Trend Lines

Build your own completely customizable trend lines in QlikView!

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

Disable Small Device Version in QlikView AccessPoint

This article will demonstrate a simple way to disable the “Small Device Version” default client on mobile devices and have all QlikView applications open in the normal “Full Browser Version” client!

Posted in Mobile, QlikView Server, Tips & Tricks | Tagged , , , | 6 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