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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

calculated Dimension with variable comparision

Hi all

My requirement is create calculated dimension based on condition

here in dimension i need show the customers with  minimum amount = 500 in my pie chart with thair amount

issue: getting syntax error

check application

Labels (1)
2 Replies
sunny_talwar
MVP
MVP

Your variable was empty... once I added 500 from variable overview, it seems to be working.

Capture.PNG

aarkay29
Specialist
Specialist

Or you can try like this

sum({<Amount={">=$(=$(vMinimumAmount))"}>}Amount) as expression for Amount >=500

and [Customer Name] as dimension