How to use a variable name stored into a field

Mon, 12 Nov 2012 09:15:39 GMT

Hi, first of all sorry for my English. This is my case:

I have a different formulas stored into different variables. For Example:

Variable 1 Sum(1)

Variable 2 Sum(2)

Variable 3 Sum(3)

also I have a table like this:

Component Formula

----------------- --------------

S1 Variable1

S2 Variable2

S3 Variable3

I want to use the field 'Formula' on a table with the dimension Component and with the Expression $(Formula), but this isn't so simple.

I want this result:

S1 1

S2 2

S3 3

I need this because i have 30 different formulas and i want to avoid the if...else clause.

Thanks a lot!

topic How to use a variable name stored into a field in QlikView