Use cases for Generic Load

The Qlikview  “Generic Load” is not frequently used and is therefore sometimes forgotten. Generic Load has some interesting applications and can be a useful item in your script toolbag. Generic Load  is the complement of “Crosstable Load”. In a loose sense, you could say that aCrosstable Load creates a Generic table and  Generic Load creates a ...
Read More

Reusing expressions — chart column references

It’s often useful to avoid repeating lengthy expressions. Here’s one technique for reusing expressions. Consider the chart below. The Expression for the column labeled “Net” is: =sum(Quantity * Price) * (1-Discount) Let’s add another column for “Commission”, defined as 10% of Net. Instead of repeating the Net calculation, use the ...
Read More

Best way to count keys? Don’t.

I was recently reviewing a problem where a chart Count() function produced differing results between QV 8.5 and 9. The field being counted was a key field. Counting a key field without using DISTINCT, especially a one-to-many key, can produce ambiguous results and should be avoided. The recommended approach is ...
Read More

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

Recipes for Qlikview Success