Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

rglenn0780
Contributor

How to show bottom 10 business units and excluding zero values in Bar chart

Hi Guys,

I am struggling with displaying the bottom 10 business units and excluding the zero values (the data that was not input yet). When I check do not show zero values then I do a limitation on a fixed number of bottom 10, I get no data to display.

I think this is because it is trying to pull the zero data units in and there are none. How do I exclude the business units that have 0 in for revenue and display only the bottom 10 that actually have a number in there?

Thanks,

Russ

Tags (1)
24 Replies
MVP
MVP

Re: How to show bottom 10 business units and excluding zero values in Bar chart

Would you be able to share a sample?

rglenn0780
Contributor

Re: How to show bottom 10 business units and excluding zero values in Bar chart

A sample of what exactly?

When I select bottom 10, I see the bottom 10 that are all zero $. I need to exclude those and get to the bottom 10 that actually have data.

If I select exclude zeros, nothing shows up at all.

Thanks!

MVP
MVP

Re: How to show bottom 10 business units and excluding zero values in Bar chart

May be use set analysis to exclude 0

{<Revenue -= {0}>}

ahaahaaha
Honored Contributor

Re: How to show bottom 10 business units and excluding zero values in Bar chart

Hi,

May be as at attached file?

rglenn0780
Contributor

Re: How to show bottom 10 business units and excluding zero values in Bar chart

Thanks for your reply...Where would I place this set analysis? In the overall expression or in the limitation expression? Thanks Sunny

MVP
MVP

Re: How to show bottom 10 business units and excluding zero values in Bar chart

I would overall expression

rglenn0780
Contributor

Re: How to show bottom 10 business units and excluding zero values in Bar chart

I am also getting a garbage expression after -= part of that formula...any thoughts?

rglenn0780
Contributor

Re: How to show bottom 10 business units and excluding zero values in Bar chart

I am also getting a garbage expression after -= part of that formula...any thoughts?

rglenn0780
Contributor

Re: How to show bottom 10 business units and excluding zero values in Bar chart

I do not have a desktop version of qlik sense - do you have any thoughts of what I can do in app to fix?