Blog

Qonnections 2018 Reflections

I just wrapped up the week at Qonnections 2018.  I found it to be an inspiring conference and the most positive I’ve attended in years. What was inspiring?  The cognitive insights demo was fantastic.  This is the future of BI.  We have well understood principles and algorithms recently formalized in ...
Read More

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
Loading...

Recipes for Qlikview Success