1 Reply Latest reply: May 21, 2018 2:45 PM by Sunny Talwar RSS

    don't show null measure values

    Wanyun Yang

      My Qlik Sense straight table is like:

       

      Order  Item    SUM(sales)

      1            A          300

      1            B            -


      I want to show only the records with SUM(sales). In this case:

      Order  Item    SUM(sales)

      1            A          300


      Since SUM(sales) is measure, so there is no "show null values" box. How should I write the functions for Order and Item dimensions?


      Thanks for help!