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:

       

      QlikSense-pic1.PNGQlikSensepic2.PNG

       

      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:

       

      QlikSensepic3.PNG

       

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

       

      Thanks in advance.

       

      Regards