topic Sum of numbered columns in QlikView

Sum of numbered columns

richters — Thu, 14 Feb 2013 14:04:21 GMT

Hi all,

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?

Thank you!

Gysbert_Wassenaar — Thu, 14 Feb 2013 14:45:07 GMT

Maybe something like rangesum($(=concat( 'col_'&ValueLoop(1,x),',')))

richters — Tue, 19 Feb 2013 10:56:53 GMT

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));

Thank you!