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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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