Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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