Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Hide values in legend which do not show on chart

Many of the values in my legend, do not show up in my bar chart at all.

How do I hide those values?

For example 'EM bonds' has no data in this chart and therefore I don't want it to appear in the legend. However WCLK does, so i want it to stay in the legend

legend.png

1 Solution

Accepted Solutions

Re: Hide values in legend which do not show on chart

Hi

Try like this

Case1:

Tick the suppress when value is zero from presentation tab.

Case 2:

There may be the value for "EM Bonds" which is very minimum when compare to others. so it does not displaying. If you select EM Bonds alone, you can able to view it.

Case 3:

If you need to display only  top 10 products, then try like this

Sum({<Product = {"=rank(sum(Sales))<= 10"}>} Sales)

2 Replies

Re: Hide values in legend which do not show on chart

Hi

Try like this

Case1:

Tick the suppress when value is zero from presentation tab.

Case 2:

There may be the value for "EM Bonds" which is very minimum when compare to others. so it does not displaying. If you select EM Bonds alone, you can able to view it.

Case 3:

If you need to display only  top 10 products, then try like this

Sum({<Product = {"=rank(sum(Sales))<= 10"}>} Sales)

Not applicable

Re: Hide values in legend which do not show on chart

Thanks. The first one worked!

Community Browser