topic Performance relate : Can we update the multiple variables parallel by setting actions ? in QlikView

Performance relate : Can we update the multiple variables parallel by setting actions ?

Mon, 09 Jun 2014 14:02:19 GMT

Hello All,

I have a scenario where I need to update 70 variables by clicking on the button.

I created 70 Actions (Set Variable ) on the button . What I notices is when I click on this button these variables are updated in sequential order hence taking lot of time.

is there any way of updating all the variable parallel ?

Kindly suggest if there is any way of improving the performance.

Thanks & Regards,
MVV Satish.

Re: Performance relate : Can we update the multiple variables parallel by setting actions ?

Mon, 09 Jun 2014 14:07:38 GMT

In your load script you could load your variables, state1 value, state 2 value:

VariableTable:

Load * Inline

[VariableName, State1, State2,

vName1, 100, 200,

vName2, 101, 201,

....

vName70, 170, 270]

So then you could use set analysis in your expressions. Also you could make one variable that = "state1" or "state2" so you could dynamically control which states are used in set analysis.

Re: Performance relate : Can we update the multiple variables parallel by setting actions ?

Mon, 09 Jun 2014 14:18:24 GMT

Load the variables on the tables and attach the tables into data model accordingly..