topic Re: calculated Dimension with variable comparision in QlikView

calculated Dimension with variable comparision

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

sunny_talwar — Fri, 17 Feb 2017 15:34:17 GMT

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

aarkay29 — Fri, 17 Feb 2017 15:41:52 GMT

Or you can try like this

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

and [Customer Name] as dimension