topic store variables' values in a table in QlikView

store variables' values in a table

ali_hijazi — Wed, 23 Nov 2011 11:41:58 GMT

Hello

I'm looping through the records of a table

For i=1 to NoOfRows('MyTable')

if condition is true then

let v1 = FieldValue('myColumn',$(i));

//here I want to store v1 in a table and everytime I set v1 I want to concatenate the value of V1 into a new row in the same table

endif

Please advise

swuehl — Wed, 23 Nov 2011 12:16:16 GMT

Try maybe some similar to this:

For i=1 to NoOfRows('MyTable')

if $(i)<5 then // or any other condition check, as you like

let v1 = FieldValue('myColumn',$(i));

ResultTable:

LOAD

$(v1) as Result

autogenerate 1;

endif