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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
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