Variables - frequency of calculation

[Anonymous]

I am working on a dashboard that has ~30 sheets and 200+ variables. I'm in process of optimizing the dashboard by breaking it down using document chaining and by reducing the number of variables where I can.

We're currently using dropdown extension object for navigation but after breaking down dashboard, this is no longer going to be an option since "Open URL" or "Activate Qlikview Document" options are only available through Buttons or Text Box.

I'm on my way to break down my navigation into buttons when I'm realizing that there's a good amount of lag after button is pressed and before the action occurs. Qlikview goes in "evaluating" mode. I wanted to know how to reduce this lag. Is each variable evaluated/calculated when this action is performed? Any suggestions from anyone who has worked on similar design - seamless experience of navigation that uses buttons and conditional show to replicate web-like menu experience?

Also, is each variable calculated while going from one screen to another? Let's say Sheet05, which I'm navigating to, uses 25 out of 200 variables.. Does Qlikview evaluate only the required variables or does it evaluate all?

I'll appreciate every input

Aashil

[jwjackso · Accepted solution]

In Cronstrom's blog (The Magic of Variables), depending on how the variable is defined determines how often it is calculated.

It is also possible to calculate the variable value, i.e. determine how it should be expanded, by using an initial equals sign in the variable definition.

     Let vSales2  = '=Sum(Sales)';

In this case, the variable value is calculated after each click, whereupon the dollar expansion in the chart expression is made, and finally the expression is evaluated.

[Anonymous]

Great! Thanks for the answer and for linking the blog.