Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
LINKEDIN LIVE: Democratizing data to enhance customer-centricity. JULY 29TH REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
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
MayilVahanan

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)

Thanks & Regards,
Mayil Vahanan R

View solution in original post

2 Replies
MayilVahanan

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)

Thanks & Regards,
Mayil Vahanan R

View solution in original post

Not applicable
Author

Thanks. The first one worked!