Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

saurav_pr_gupta
New Contributor

Exclude values in bar chart

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.

1 Solution

Accepted Solutions

Re: Exclude values in bar chart

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

Capture.PNG

Life is so rich, and we need to respect to the life !!!
5 Replies

Re: Exclude values in bar chart

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

Capture.PNG

Life is so rich, and we need to respect to the life !!!
saurav_pr_gupta
New Contributor

Re: Exclude values in bar chart

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

Is this working?

Life is so rich, and we need to respect to the life !!!
saurav_pr_gupta
New Contributor

Re: Exclude values in bar chart

Yes, It is working Fine. Thanks for your help

Re: Exclude values in bar chart

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

Life is so rich, and we need to respect to the life !!!
Community Browser