topic Re: variable creation which one is better in QlikView

variable creation which one is better

Fri, 29 Jan 2016 06:38:51 GMT

Hi all,

Have a nice day.

performance wise which method is better for creating Variable

Method 1: By going into menu -> settings/variable overview

Method 2: By using SET and LET statements.

Method 1 and method 2 both are same result

Thank,

ramu

Re: variable creation which one is better

sasikanth — Fri, 29 Jan 2016 06:58:51 GMT

Hi,

case comes only when a variable evaluates complex expression

in that case

In front end for every selection expressions need to be evaluated

if you are able to calculate this exp from backed then declare at script level

Re: variable creation which one is better

avinashelite — Fri, 29 Jan 2016 07:13:15 GMT

As per my knowledge LET method does not evaluate and hence it will have better performance but you cannot do the dynamic changes. Other than this both the ways of the setting the variables are same does not have much of the difference in the performance

Re: variable creation which one is better

jonathandienst — Fri, 29 Jan 2016 07:24:42 GMT

The main advantage of creating the variables in the load script is that the variables are preserved in the case of a no-data load. You may need a no-data load for recovering a corrupt qvd or rolling back to an older version when you are using version control. In these cases, the variables exist in the empty document, but are all set to null.

If they are defined in the load script, then they will be recreated when the empty document is reloaded. Which is why I recommend that the variables be defined in the load script.

Re: variable creation which one is better

jagan — Fri, 29 Jan 2016 07:32:03 GMT

Hi,

Creating in script will help in easily maintenance if you want to change many variables you can change it easily in script, instead of searching in variables tab.

If you require the same in another Dashboard you can just copy the script and use it in the new one.

Regards,

Jagan.

Re: variable creation which one is better

kashaboinaraj — Fri, 29 Jan 2016 09:41:06 GMT

creating variable in script is better because for searching for variable it is easy to go direcrtly to the script location for changes.

Regards

vishnu