Simplify with Preceding Load

Most QV script developers are introduced to “preceding load” as a LOAD that precedes an SQL SELECT. But a LOAD may also precede another LOAD, which can be a very useful tool. Let’s review a typical preceding load. Table1:LOAD Customer, Sales, today(1) as LoadDate ;SQL SELECT Customer, Country, Sales FROM ...
Read More

Understanding Join and Concatenate

The Qlikview script functions JOIN and CONCATENATE can sometimes be used to tackle the same problem, but there are important differences that should be understood. Examine the sample tables below. Note that they share one common field name, “Key”. Also note that Table1 has a Key value “3” that is ...
Read More

BOQC: Flexible Interval Classification

Another post in the “Best of QlikCommunity” series.In this QlikCommunity Forum thread the poster asked about using the class() function to create a dynamic dimension of 30 minute intervals in a chart. He wanted to format the class values as display friendly time ranges. My solution would have been to ...
Read More

Analyzing Field Usage in a QVW

Wouldn’t it be nice to know what fields are “unreferenced” in your document? By unreferenced, I mean fields that are not used in Expressions, Dimensions or Keys. These are fields that if removed from your document, would have no impact on the visible elements of the application. Removing unused fields ...
Read More

BOQC: ApplyMap instead of Join

Today marks my first blogging of “Best Of QlikCommunity” (BOQC) where I plan to highlight what I find to be particularly useful or interesting posts on the QlikCommunity Forums. There are cases when the ApplyMap() function is a very useful alternative to Join. For some time I have noticed both ...
Read More

Recipes for Qlikview Success