Discussion Board for collaboration on QlikView Scripting.
is there a possibility to sum up or concat numbered columns?
I implemented a loop which creates columns named like : col_0, col_1, ...col_x
I know the number of created columns by a variable (x).
Does anyone know how to work with a flexible number of columns?
Go to Solution.
Maybe something like rangesum($(=concat( 'col_'&ValueLoop(1,x),',')))
I used a construction like this:
LET x = 10;
LET vCols = 'rangesum(col_1' ;
for i = 2 to $(x);
LET vCols = '$(vCols)' & ', col_' & $(i);
SET vCols = $(vCols));