6 Replies Latest reply: Apr 26, 2017 4:33 AM by Vineeth Pujari RSS

    Qlik Sense: sum()

    Kenny Hua

      Hello everyone,


      Currently, I'm encountering an issue with the function sum() with the "indicator".


      With the dynamic table, we have "Total function" and I don't this issue because with "Total function" the table is capable to sum each line and ignoring null values:




      function: if(Amount_Eur = Solde, null(), sum(Solde))


      But when I try to make this same sum with "indicator", I don't get the same sum because this function still summing null value:




      Do we have something like "Total function" with the "indicator"?


      Thanks in advance.