Tag Archives: performance

One Simple Trick That Will Significantly Boost Your QlikView Performance

Edit April 2nd 2015: Yes, of course this is an April Fools joke, hope I made you smile. The Masters Summit is no joke though, and neither is the $300 early bird discount that you will receive until April 15th 2015. Want to really take your skills to the next level? Join us in San Francisco on May 4 – 6, or New York City or Copenhagen later this year.

Amazing Business DiscoveriesToday I am going to let you in on a big secret.

People often ask me how I always get great performance and fast response times out of my QlikView applications. I usually put on a very serious face and reply that this is the result of years of experience. Experience gained by doing hundreds of implementations, practice, experiment, study and continually refining my skills and knowledge.

You won’t believe how hard it is to not burst out laughing when I tell this to people. The fact of the matter is that it is all a gimmick!

There is only one simple trick that you need to know to instantly boost your QlikView performance. This is the secret that Qlik and the Qlik Illuminati don’t want you to know, but today I will reveal it all!

Are you ready for the truth? Here it comes!

read more »

Testing the performance implications of variables and label referencing versus direct expressions

Testing the performance implications of variables and label referencing versus direct expressionsAfter my previous post about variables, I got an interesting question from DV. He asked me about the reuse of chart expressions by referencing the label of another expression (“label referencing”), and what the performance implications of using variables and label referencing versus direct expressions are.

I use variables and label referencing extensively in my applications, but I never really tested what this means for performance. I have always assumed that using variables instead of direct expressions would have a slight impact on performance. I also suspected that using label referencing would result in significantly better performance (I will explain this later).

But was this really true? Triggered by DV’s question, I set up a small experiment to test my assumptions.

read more »