10 Replies Latest reply: Jun 3, 2014 10:33 AM by Jalpa Bhatt RSS

    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