Blog

Loading Variables From Another QVW

I just read a good post by Kamal Kumar Sanguri on QlikCommunity.  Kamal’s post reminded me that managing variables in QlikView has always presented some challenges and over the years various techniques and code snippets have been shared to address those challenges. Most folks quickly find that maintaining variables in external ...
Read More

Expanding the Qlik Sense Editor Pane

Summary: In this post I present a non-intrusive bookmarklet to hide the Sections pane in the Qlik Sense Script Editor to provide more real estate for typing script.  Edit:  Note in the comments below that hiding the pane can be done out of the box using keyboard shortcuts such as ...
Read More

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

Recipes for Qlikview Success