topic Re: 1 “Set Variable” action affect many variables in QlikView

1 “Set Variable” action affect many variables

Fri, 27 Mar 2015 18:45:42 GMT

Hi,

I am wondering if there is a way to have 1 "Set Variable" action affect many other variable.

For example, regarding hierarchical variables...

I would like to assign the value of a level 1 variable to override all the values of the related level 2 variables. Perhaps they could get listed with a separator between each variable?

e.g. the following image is the essence, but it does not work:

If there is no way to do it in the Qlikview environment, please provide resources that will help me create a macro (I have lots of experience in coding in VBA).

Re: 1 “Set Variable” action affect many variables

Gysbert_Wassenaar — Sat, 28 Mar 2015 19:01:20 GMT

The Set Variable action can set the value of only one variable. You can use three Set Variable actions, one for each variable.

Re: 1 “Set Variable” action affect many variables

sunny_talwar — Sat, 28 Mar 2015 19:10:01 GMT

I agree with Gysbert, why can't you use three set variable actions for the same object giving them all the same value?

Best,

Sunny

Re: 1 “Set Variable” action affect many variables

Gabriel — Sat, 28 Mar 2015 22:30:06 GMT

Hi,

What I would try is

If you are creating your variable in the script then do this

SET vTest1 =1 ;

SET vTest2 = '=vTest1';

SET vTest3 = '=vTest1';

Which mean in the UI you can assign a value to vTest1 from anyway and vTest2 & vTest3 will inherit their values from vTest1.

If you're creating your variable from Variable overview simply create vTest1 assign value of your choice then create vTest2 and give it value to be =vTest1 and same for vTest3 it value should be =vTest1.

A simple test I did quickly was to have all the variables in Input Box and assign value to vTest1 and I can see vTest2 and vTest3 having same value as vTest1.

Hope this helps

Re: 1 “Set Variable” action affect many variables

Thu, 02 Apr 2015 16:27:03 GMT

Thank you all for the responses. To close the loop...

1) The suggestion to create multiple "Set Variable" actions is correct, but I needed a work around to be able to mass produce this activity because my real application has hundreds of user input variables.

2) The suggestion to set the variables equal to their parent in the hierarchy is a good start, but I needed my end user to be able to interact with each of these hundreds of variables on the fly.

3) I settled on the use of VBA macros to accomplish this.

I made a handful of subroutines to push & pull the user input values at different levels

Apply L1 Rates to all
Recall L1 Rates
Apply Government L1 Rates to all
Recall L1 Gov rates
Apply L2 Rates to all
Recall L2 Rates
Apply Government L2 Rates to all
Recall Gov L2 rates
Clear All

Each of the above applies to the L3 user input variables (about 150 for each of normal and Federal Gov)