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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Bharath080
Contributor
Contributor

How to reference dimension value in measure calculation

How to reference dimension value in measure calculation, 

In pivot table I have measures for which dimension have to be different for different measures, hence I created a static dimension now I need these measures to be linked to value in dimension, hence I need to know how to reference dimension in measure calculation 

Labels (1)
2 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Reference the Dimension by fieldname, eg

if(Region='EMEA', ...

-Rob

Bharath080
Contributor
Contributor
Author

There are 250 value in that field hence it has to be dynamic