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

Announcements
Only at Qlik Connect! Guest keynote Jesse Cole shares his secrets for daring to be different. Learn More!
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