Blog

Exploring Data Lineage with NodeGraph

In the Qlik world, we are frequently faced with questions like: Where did this field come from? What applications (if any) use this QVD? If I change this database table, what applications will be affected? Am I creating QVDs that are not being consumed? I’ve maintained a QlikView lineage application ...
Read More

AutoNumber vs AutoNumberHash128

Summary:  AutoNumberHash128(A, B) runs about 30% faster than AutoNumber(A &’-‘ & B). It’s a common practice to use the script AutoNumber() function to reduce the storage required for large compound keys in a Qlik data model. For example: AutoNumber(A & '-' & B) as %KeyField As a standard practice, we ...
Read More

Qonnections 2018

Are you going to Qonnections in Orlando April 23?   I’ll be there and presenting three breakout sessions.  In addition to checking in with colleagues and hearing about what’s new, here are some things I’m looking forward to: Hearing from the new Leadership team Qlik Core! Learning more about subscription pricing ...
Read More

Preceding Load Performance Update

Summary:  Preceding load used to slow down your script. but no more. Beginning with QV Nov 2017,  preceding load has no performance penalty. I’ve posted several times about the elegance of preceding load.  I’ve also written about how preceding load can make your script run significantly slower.  Good news! Beginning with ...
Read More

Distribution Plot in QlikView

Qlik Sense added a Distribution Plot visualization in the June 2017 release.   QlikView does not have a specific chart type for distribution plot, but you can achieve the same with a scatter plot. The trick is to set the Y value (Expression #2) to a constant value such as “1”.  ...
Read More
Loading...

Recipes for Qlikview Success