topic Re: Creating dynamic variable names in script loop in QlikView

Creating dynamic variable names in script loop

Mon, 17 Nov 2014 18:27:26 GMT

Is it possible to dynamically create variables in a script loop. I want to create a loop that based off the number of records in a table creates dimensions (i.e. DIM1, DIM2, DIM3, etc.).

Something like this? :

For vI = 1 to NoOfRows('myTable')

Let '$(DIM)'&'$(vI)' = 'static expression';

Next vI

Thanks,

Tyler

Re: Creating dynamic variable names in script loop

Mon, 17 Nov 2014 18:36:46 GMT

something more like this for the center of the loop probably:

set name = 'Dim' & $(vI);

set '$(name)' = 'static expression';

Re: Creating dynamic variable names in script loop

Mon, 17 Nov 2014 18:46:35 GMT

I figured it out:

For vI = 1 to NoOfRows('myTable')

set name = 'Dim$(vI)';

set '$(name)' = 'static expression';

Next vI