topic Re: How to make dynamic variable in qliksense in App Development

How to make dynamic variable in qliksense

gsethuraman2 — Thu, 18 Jul 2019 20:23:03 GMT

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

vmoreno2605 — Fri, 19 Jul 2019 20:30:42 GMT

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

Maxwell20 — Mon, 22 Jul 2019 05:36:47 GMT

Thanks for the pics.It really helped a lot.Thank you so much mygiftcardsite

gsethuraman2 — Thu, 25 Jul 2019 18:04:59 GMT

Thanks it helped ..