Call a variable with field value

jaymerry — Thu, 21 Jul 2011 15:15:58 GMT

Hello,

I have the following variables :

LET vTEST = A;

LET vTEST1 = B;

And I have the following table which is loaded in my load script :

TEST_TABLE:

LOAD * INLINE

Product, VAL

Bottles, vTEST

Cars, vTEST2

];

Now, in my Dashboard, I'm trying to call the variables in a chart table with the field "VAL" of my TEST_TABLE (I have try ='$'&'('&(VAL)&')' but it doesn't work )

Do you know if it's possible ?

Thanks for your help,

BR,

Jaymerry

Call a variable with field value

danielrozental — Thu, 21 Jul 2011 15:50:27 GMT

I think inline will always take values as literals.

you can try using a mapping table or something like

TEST_TABLE:

LOAD

'Bottles' as Product,

'$(vTEST)' as Bottles

autogenerate(1);

LOAD

'Cars' as Product,

'$(vTEST1)' as Bottles

autogenerate(1);

topic Call a variable with field value in QlikView

Call a variable with field value

Call a variable with field value