Hide legend entry/name in a graph when associated value = zero or blank

[lessassy]

Hello everyone,

I have a bar chart with several expression.

When i display the bar chart, there are legends names which don't have value on x axis.

And I want to show only legend when the value >0

Do you know how i can do that ?

Thank you

[qlikviewwizard]

Please share us the sample file.

[lessassy]

Here it is

Thank you

[qlikviewwizard]

Hi Yann Lessassy

Try Like this.

[qlikviewwizard]

Hi,

Please check this also.

[lessassy]

I tried with this one and it doesn't really work.

Or i think i haven't fully explained correctly my issue.

I want to hide the legend entries such as "Retouche" "S9000" "F3000" when they don't have value in the x axis.

In this following example, the x axis are the weekyear.

And i still want to show every week even if the value is 0 but i want to hide the legend entries that have zero values. Because i will add many expressions and i don't want it to be oversaturated.

thank you

[balabhaskarqlik]

May be, Modify your expression like:

=If(Sales > 0, Sum(Sales))

And check, Suppress zero value option, to filter other data.

[lessassy]

If I do that i get the same result as earlier.

In fact what i want to do actually is not to show expression label (or legend entries) but i still want to show all the the dimension weekyear entirely.