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: 
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

2 Replies
sunny_talwar

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