5 Replies Latest reply: Sep 8, 2017 5:29 AM by Anil Samineni RSS

    Exclude values in bar chart

    Saurav Gupta

      In my data a lot of product names have been clubbed together as 'Others'. No there is no product with the name 'Others' in my data. The problem is, I want to exclude this and show only top 20 products and eliminate the product named as Others. Unless i remove 'Others' I can not create combo graph as required.Qlik.JPG


      I have already used the syntax : =Sum({<ProductName-={'Others'}>}BillAmount) .

      But this does not work. HELP please.