Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

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

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.

2 Replies
Not applicable

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

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.

Not applicable

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

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

Community Browser