topic Expression not working in QlikView

Expression not working

Edge — Sun, 17 May 2020 12:24:42 GMT

Hey guys,

The below is not working for me:

=Count( {<ALLWaiverAmount={'>0'}>} DISTINCT Enrolment.EMPLID)

I just want to count distinct enrollment.emplid if the allwaiver amount is >0

Could you please help?

Or — Sun, 17 May 2020 12:30:53 GMT

This expression looks correct and I was able to use it (changing the fields, of course) in one of my QVWs.

Double-check your expression for spelling and Uppercase/lowercase. Enrolment may be spelled incorrectly?

Edge — Sun, 17 May 2020 12:33:14 GMT

Sorry man false alarm, my stupid brain was not working. All waiver is in negative values so I should use < not >.

Thanks for answering though 🙂