Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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
Please close the thread by marking correct answer & give likes if you like the post.

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
Please close the thread by marking correct answer & give likes if you like the post.
Not applicable
Author

Thanks. The first one worked!