Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Lakshmichaitanyaprabha_Sappa

How to remove empty bars from the bar chart with 2 dimensions?

This issue is related to QlikView.

I have a bar chart contains two dimensions : City, Country and one measure. 

It is showing bar chart like below:

Lakshmichaitanyaprabha_Sappa_0-1674126922334.png

I want to remove the empty bars from the chart above.

I have checked the option Suppress when value is Null from dimensions tab and below options as well still it is showing empty bars.

Lakshmichaitanyaprabha_Sappa_1-1674127059027.png

Can anyone help me with this?

Thanks in Advance!

Labels (2)
2 Replies
ift_isabelle
Partner - Creator III
Partner - Creator III

Have you tried unchecking this option?

Remove empty bars.png

In Qlikview that would be "Zero on bars" in your screenshot.

Lakshmichaitanyaprabha_Sappa
Author

Hi @ift_isabelle ,

I'm looking for the solution in QlikView. 

Yeah, I have checked suppress zero - values.

 

Thanks,

Lakshmi