Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to use a variable name stored into a field

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!

0 Replies