Discussion Board for collaboration related to QlikView Deployment.
I like to create a NewColumn that depends from the columns ‘Var_Index’ and ‘Value’
For example, the first line Var_Index=1, Value=10 then NewColumn=$(var1(10))=10+1=11
$(var& Var_Index(Value)) as NewColumn
My code doesn’t work, how can I modify it that it works.
I try to avoid pick(Var_Index,…) and If(Var_Index=….) because my list of variable is longer than this sample and I create the variable dynamically.
Thanks for your help and answer.
Nice Week End!
Please do not double-posting: Use variable dynamically as function.