Skip to main content
Announcements
See why Qlik was named a Leader in the 2025 Gartner® Magic Quadrant™ for Augmented Data Quality Solutions: GET THE REPORT
cancel
Showing results for 
Search instead for 
Did you mean: 
its_rajvir
Creator

Less than the value condition not working in set expression

Dear Experts,

I am trying yo create a measure with Amount less than 20 but i don't know why its not working. I am trying something like this :

Sum({$<TxnType = {'SALE'}, Amount = {"<20.00"}>}CounterSales)

 

Please Helppp

Labels (5)
4 Replies
ManuelRühl
Partner - Specialist

Hi,

The expression looks valid for me.

Could you please try:

Sum( { $ < Amount = {"<20"} > } CounterSales )

Manuel Rühl
www.mamaconsulting.de
Chanty4u
MVP

Try this

Sum({$<TxnType={'SALE'}, Amount={"<=20.00"}>} CounterSales)

 

Rohan
Partner - Specialist

Hi Rajvir,

Kindly check the data type for the Amount Column, is it Numeric or not. If its in string then the range filters wont work in that case.

 

Regards,

Rohan.

vincent_ardiet_
Specialist

Or are you trying to filter something from which the sum of amount is above 20?