Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
StacyCui
Creator
Creator

calculate measure as dimension

HI, Recently, we have a business requirement, we need show two types which the number of customer with OR value and without OR till now as a dimension in a pie chart. But when I select month, it only show the number of customer with OR. how to show the types in the dimension? I try to write something as below, But it seems not work.

sum( FROZENDATE= {"<=$(max(FROZENDATE))"} ORValue)+0*sum( {1} ORValue)

0 Replies