Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Showing results for 
Search instead for 
Did you mean: 
Michaels
Contributor III
Contributor III

variabilisation of dimension

Hello,

 

I have some dimensions : Product1, Product2, Product3, ...I'm using those dimensions in set analysis

I have a filter to select the numero of the product (1, 2, 3 ...)

 

Is it possible to set a variable to determine the dimension ? 

Equivalent to : 

if(getfieldselection(value) = 1, sum({<Product1={something}>} measure),

if(getfieldselection(value) = 2, sum({<Product2={something}>} measure),

if(getfieldselection(value) = 3, sum({<Product3={something}>} measure),

))))

 

I would like something like :

myvariable = 'Product'&getfieldselection(value)

 

to do sum({<myvariable={something}>} measure),

 

 

1 Reply
Anil_Babu_Samineni

Perhaps this

sum({<YourKey={"=$(myvariable)=something"}>} measure)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful