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

Forcing all labels to be visable after selection

Another challenge for you all!

I am using a bubble chart to show results of mobility and change levels.

When I have all data selected all of the labels are there, however when I filter to a lower level labels are lost.

How can I force the label to always stay?

Not filtered

Not Filtered Bubble Diagram.png

Filtered

Filtered Bubble Diagram.png

Thanks

Rob

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Maybe I misunderstood your requirement, but what's wrong with the solution Henric suggested?

How do you want the chart to react on user selections?

View solution in original post

15 Replies
hic
Former Employee
Former Employee

Exactly this problem - but for a pivot table - is solved in this blog post: http://community.qlik.com/blogs/qlikviewdesignblog/2012/11/02/tips-and-tricks-pixel-perfect-or-qlikv....

The basic idea is to use set analysis to always show the numbers (the bubbles) but use an expression that makes the clor gray if the number (the bubble) is excluded through selection.

HIC

Not applicable
Author

Henric, thanks for the suggestion but it didn't help.

I have taken off "Suppress Zero-Values" and this now keeps all labels visable when I filter.  See image below.

However, I now have the issue of the -(Hyphen) appearing on the chart.

I had this issue before and used the following in an expression -={'-'} to remove the problem

I've tried this in the current expression but not sure if I'm doing this right. Any ideas?

=Sum(change_profile_count)

Chart after Suppressing Zero-Values

SupZero Filtered Bubble Diagram.png

hic
Former Employee
Former Employee

The hyphen represents NULL values in the dimension, so if you check "Suppress when value is Null" on ChartProperties->Dimensions, it should disappear.

HIC

Not applicable
Author

That takes me back to the Filtered chart above where you loose the labels!

Seems you can have one or the other.

hic
Former Employee
Former Employee

On ChartProperties->Presentation, you have "Suppress Zero values" and "Suppress Missing". Make sure these are unchecked.

HIC

Not applicable
Author

Yes they are both unchecked.

As I say this take me back to the issue with the labels disapearing.

Rob

hic
Former Employee
Former Employee

I have recreated what you describe, and I see what you mean.

Would it be an acceptable work-around to show all bubbles, but show the non-selected ones gray? See attachment. Then you would get the labels exactly the way you want them.

HIC

swuehl
MVP
MVP

And if you want to hide the bubbles, just use

if(Count(Profile)=0,argb(0,255,255,255))

Not applicable
Author

Hi both, that was a nice idea but i'm not sure that's going to be acceptable.

I think I might have to go back to the data and see how we can pull it in without the -(Hyphen) info

But thanks for looking at this.

There has to be an answer!