13 Replies Latest reply: Apr 5, 2018 5:55 AM by Valeta Isaacs RSS

    Exclude negative values in pie chart - qliksense

    Valeta Isaacs

      How can I use a pie chart to show me the bottom 5 sub classes by excluding 0 and negative values.

       

      Dimension is Subclass

      Measure is sales

       

      I used Rangemax(Sales,0) - not working

      I used  If(Sum([Sales]) > 0, Sum([Sales])) - not working

       

      Any other advice? I am new to qliksense and all the help will be appreciated.

       

      Thanks