3 Replies Latest reply: Jun 9, 2018 7:55 AM by arvind pednekar RSS

    Not equal in Where clause in expression

    Ashot Antonyan

      Hello.

       

      What would be the correct syntax in Qlik Sense, if I want to summarize "CURRENT_AMOUNT" where field "SIDE" is not null ?

       

      My guess was:

       

      =Sum({<IsNull(SIDE)=0>} CURRENT_AMOUNT)

       

      but it gives me error.

       

      Thank you.