How to remove unrelated legend from a chart?

[BoXiangWang]

Hi all,

I have a bar chart and I only show one year at a time. Capture like below:

Here in this year the stacked bar chart only has one kind of category, but the legend is still showing other non-related categories. How can I only show related ones? Thanks!

[Ben_P]

First you could try hiding zero values. In Qlik Cloud this is under Add Ons > Data Handling.

If that doesn't work, you could just remove the legend, and maybe replace with labels either on the bars themselves or on the x-axis.

Ticking to suppress nulls on your dimension is another common technique, but I don't think that applies here.