6 Replies Latest reply: Aug 7, 2017 5:33 AM by kuwlant singh RSS

    KPI selective sum

    Luca Bellotti

      Hi everyone,

      I'm a newbie to Qlik Sense Desktop.

      I have an app and a KPI that sum sales (measure) of all the departments (dimension).

      There are certain departments that ar null but have sales. I would like not to sum those sales.

      Here's the table:

       

      DepartmentShopMonthSales

      A

      a1jan10
      Ba2jan10
      Ba3jan10
      nullb1jan10
      Aa5jan10

       

      My KPI object shows 50. How can I not consider the null department, and show 40?

       

      Thanks to everyone.