Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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