Blog

Expression as Left Side of Set Modifier

Can I use an expression as the “fieldname” in a Set Modifier? In “<x={y}>” can “x” be an expression? I always believed the answer to be “No”, x may only be a field name. That understanding is reinforced by what I read in the help doc for “set modifier”. Yesterday ...
Read More

How to Segment QVD Files

Summary: In this post I discuss when you may want to segment or “shard” QVD files and demonstrate some script patterns for producing and consuming segmented QVDs. I recently received a question from a colleague who knew that I had done a lot of work with Qlik QVD files. He ...
Read More

If() Tips

Summary:  I offer some tips for writing better performing and easier to maintain syntax when using the Qlik If() function.  The Qlik If() function is very powerful and  frequently appears in Qlik Sense and QlikView apps. Expressions using multiple If() functions can easily get out of hand and become difficult to maintain ...
Read More

Deconstructing Visualization Performance

Have you ever had a Qlik Sense Visualization take longer to calculate than you like?  You may have been measuring the response time with QSDA (or the older QVF QS Document Analyzer) ,  Add Sense or a stopwatch. Your chart is likely made up of several expressions — Measures, color expressions, maybe reference ...
Read More

QSDA Pro as a Quality Tool

I my last two posts I introduced QSDA Pro and the flag workflow. In this post I’m going to show how you can use QSDA Pro to quickly uncover quality issues in your Qlik Sense App. QSDA groups flags by category, and the “Quality” category is where I usually begin ...
Read More

Recipes for Qlikview Success