topic Re: qlikview 12 in QlikView

qlikview 12

ali_hijazi — Fri, 17 Jun 2016 01:39:18 GMT

Hello I have a question on the QlikView 12 SR3

are the variables all calculated on every single qlik?

or is it only the ones that are used in a sheet

Please advise

Re: qlikview 12

Fri, 17 Jun 2016 02:00:51 GMT

it depends ..

As and example if you have a variable Set vTotalSales = sum(Sales);

And if you use this on text box then it will be re-calculated every time you make any selections in the document but if you make it read only then it will not be calculated.

So it actually depends what are your variables used for and how you planning to use them

Re: qlikview 12

maksim_senin — Fri, 17 Jun 2016 02:02:40 GMT

Hi,

I'm sorry, but I don't understand what you exactly mean. Example would help.

Best regards,

Maxim

Re: qlikview 12

Anonymous — Fri, 17 Jun 2016 02:25:19 GMT

It depends upon what you define in your Variable .

If you define some field in the Variable then it'll change based on your selection .

If you define a value in it . It'll have its effect when you use it to a particular sheet objects

Re: qlikview 12

avinashelite — Fri, 17 Jun 2016 05:26:25 GMT

It all depends on how you define them , if you define a variable in the script then on every reload it will get calculated .

If you have defined a fixed value in the variable then it is calculated only once . If you have use fields and selection criteria i.e if you have expression in your variables definition then as and when the field changes the variable will be calculated .

hope this helps you

Re: qlikview 12

Anonymous — Fri, 17 Jun 2016 05:31:08 GMT

might help you understand?

The Magic of Variables

Re: qlikview 12

Digvijay_Singh — Fri, 17 Jun 2016 05:44:34 GMT

On variable evaluation:

Variables are evaluated in two steps. If a variable is assigned a value through an action or a macro, this is done before the sheet objects. However, if a variable has a value which is a string starting with an equal sign, there is a second evaluation step: when the variable is used. In other words, when a sheet object that uses the variable is evaluated, the expression value is used instead of the real variable value. So, Michael, you’re absolutely right in your statement that a slow-calculating variable affects performance the way you describe.

Taken from discussion section of -
Logical Inference and Aggregations