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

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

lessassy — Wed, 25 Nov 2020 16:16:04 GMT

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

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

qlikviewwizard — Fri, 03 Aug 2018 08:16:19 GMT

Please share us the sample file.

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

lessassy — Fri, 03 Aug 2018 08:19:45 GMT

Here it is

Thank you

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

qlikviewwizard — Fri, 03 Aug 2018 08:40:01 GMT

Hi Yann Lessassy

Try Like this.

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

qlikviewwizard — Fri, 03 Aug 2018 09:04:26 GMT

Hi,

Please check this also.

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

lessassy — Fri, 03 Aug 2018 09:05:16 GMT

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

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

BalaBhaskar_Qlik — Fri, 03 Aug 2018 09:09:22 GMT

May be, Modify your expression like:

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

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

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

lessassy — Fri, 03 Aug 2018 11:17:46 GMT

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.