Discussion Board for collaboration on QlikView Layout & Visualizations.
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.
In your load script you could load your variables, state1 value, state 2 value:
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.
Load the variables on the tables and attach the tables into data model accordingly..