Qlik Community

Qlik Sense App Development

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

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 ?

3 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 ?

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.