Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
For example in below scenario if rowcount has 4 then i need 4 variables need to set ..Which will be dynamically need to set ..
For i=1 to $(RowCount)
set vPERSON_NAME1=$(vPERSON_NAME);
if i=2
then
set vPERSON_NAME2=$(vPERSON_NAME);
how to set dynamic variable vPerson_NAME+i --> how to acheive this
Hi! You can trick Qlik by using variables like this:
if(Field1 $(variable1) $(variable2),0,
if(Field1 $(variable3) $(variable4),0.5,1
)) as NewField
In this example:
variable1='<='
variable2='0'
variable3='<='
variable4='1'
Using variables like that u trick qlik sense, now lemme show you something that might help you, this is an example i did for your requierment
For x=0 to 3
let vintento$(x)=$(x);
NEXT
TRACE $(vintento0);
TRACE $(vintento1);
TRACE $(vintento2);
TRACE $(vintento3);
As you can see, i harcoded the variables name in order to see ther value, but here in this image you can see they really were created
Im sorry about my english, i hope this helps
Thanks for the pics.It really helped a lot.Thank you so much mygiftcardsite
Thanks it helped ..