Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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 🙂