topic Re: Exclude values in bar chart in App Development

Exclude values in bar chart

Anonymous — Sat, 16 Nov 2024 09:19:25 GMT

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.

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

But this does not work. HELP please.

Re: Exclude values in bar chart

Anil_Babu_Samineni — Thu, 07 Sep 2017 14:30:15 GMT

I apologies, I thought this is in Qlikview. Check here for sense

Re: Exclude values in bar chart

Anonymous — Fri, 08 Sep 2017 07:10:44 GMT

Thank you, I did not see that 'Other' option was checked. I just had too uncheck it.

Thanks for your help.

Re: Exclude values in bar chart

Anil_Babu_Samineni — Fri, 08 Sep 2017 07:12:19 GMT

Is this working?

Re: Exclude values in bar chart

Anonymous — Fri, 08 Sep 2017 09:28:11 GMT

Yes, It is working Fine. Thanks for your help

Re: Exclude values in bar chart

Anil_Babu_Samineni — Fri, 08 Sep 2017 09:29:47 GMT

Then close this thread by flag Helpful and Correct Answer of right approach ...