Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Thank you everyone for your help. Using just greater than zero works!
Regards
Jalps