3 Replies Latest reply: Nov 18, 2016 8:40 AM by Bill Markham RSS

    Need to remove zero values from a bar chart

    Roy Sinar

      I guess this is quite a simple thing to do but I am quite new to Qlik Sense. I have a number of values of zero within a data set and when showing the bar chart of company (dimension) against data set (measure) I can't show a limitation of bottom 10 due to there being a load of zero entries. I have tried unticking the "Show Null Values" option but this doesn't do it. Any help in how to remove these values from the expression would be handy. The measure expression is simply this:

      Avg([Rating])

       

      Cheers for any help.