Qlik Community

Qlik Sense App Development

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

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Not applicable

Need to remove zero values from a bar chart

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.

1 Solution

Accepted Solutions

Re: Need to remove zero values from a bar chart

In the accordion under Add-ons | Data Handling is switch for "Show zero values".  What is that set to ?

View solution in original post

4 Replies

Re: Need to remove zero values from a bar chart

In the accordion under Add-ons | Data Handling is switch for "Show zero values".  What is that set to ?

View solution in original post

Not applicable

Re: Need to remove zero values from a bar chart

Absolute star. The "Show zero values" was on in the data handling section. Removed the tick and all is good with the world.

Re: Need to remove zero values from a bar chart

Yup - Half the initial challenge when using a product new to you is not yet knowing what tick boxes are where.

KishoreSuri
Contributor

Re: Need to remove zero values from a bar chart

Hi, This Kishore. I have done the same which you mentioned , but Zero values not yet removed in the Bar chart.
Thanks,
Kishore S