Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Edge
Creator
Creator

Expression not working

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?

1 Solution

Accepted Solutions
Edge
Creator
Creator
Author

@Or 

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 🙂

View solution in original post

2 Replies
Or
MVP
MVP

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
Creator
Creator
Author

@Or 

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 🙂