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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Using if condition in an expression

Hi, I am new to Qlikview and when I try to use the if statement, it keeps bringing the value zero. Can anyone help with the below please.

I need the expression to count Organisation names (ignoring duplicates) where the AUM is greater than zero. This is what I wrote in the expression -

= if(new_currentaum>=0, count(distinct [Organisation Name]), 0)

Thanks

Jalps

 

10 Replies
Not applicable
Author

Thank you everyone for your help. Using just greater than zero works!

Regards

Jalps