topic Re: Setting Variables in QlikView

Setting Variables

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have multiple variables that I would like to use an action to update the variables values.

The problem is that it is time consuming to create many single actions for each variable, is it possible to set one action and have multiple variables change?

Basically, what would be ideal if it was possible to write in 40 or more variables in one "set variable" action.

Thanks,

Kosta

Re: Setting Variables

swuehl — Mon, 21 Mar 2016 20:07:19 GMT

I don't think that's possible with an action.

Re: Setting Variables

jagan — Tue, 22 Mar 2016 03:17:04 GMT

Hi,

With one action you can set only one variable. If you have 40 variables then you have to use 40 actions. You can try using Macros and set values for 40 variables in single place instead of adding 40 actions.

Sometimes macros won't work in non IE Plugin versions, test it thoroughly.

Check this link for sample macro code snippets.

Useful Qlikview Macros

Regards,

Jagan.

Re: Setting Variables

Digvijay_Singh — Tue, 22 Mar 2016 05:24:45 GMT

See if something like attached can help -

Re: Setting Variables

Kushal_Chawda — Tue, 22 Mar 2016 05:37:59 GMT

You can use for loop in script to update the more than 40 variables at one go. But can you explain what is the need and what you are trying to achieve?

Re: Setting Variables

Tue, 22 Mar 2016 15:24:31 GMT

Basically I have a number of variables - upwards of 40 - that the user will be able to adjust. The variables are used to in a dynamic update action. So I have a button that has a dynamic update action, I also want the button to change colour if any of the variables are different. (I cannot use any macros due to server functionality)

My plan was to have a second variable - "baseline" variable - for each one. The update button would change colour if any of the "changeable" variables were altered from the "baseline" variable value. Then the update button would have an action to set the baseline variable to the value of the changeable variables during the update action so that the button would go back to the unchanged colour.

Hopefully this explains it properly.

I believe Digvijay's solution is my best method, I am just trying to figure out the best way to apply it. Also, it is a very interesting method that I have not seen before!

Re: Setting Variables

jagan — Wed, 23 Mar 2016 01:59:38 GMT

Hi,

Yes you can use Input box with required variables in it and you can change it easily.

Regards,

Jagan.