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

    Not equal in Where clause in expression

    Ashot Antonyan



      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.