topic Re: Forcing all labels to be visable after selection in QlikView

Forcing all labels to be visable after selection

Sat, 03 Nov 2012 12:23:02 GMT

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

Filtered

Thanks

Rob

Re: Forcing all labels to be visable after selection

hic — Sat, 03 Nov 2012 12:55:02 GMT

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-qlikvew-natural.

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

Re: Forcing all labels to be visable after selection

Sat, 03 Nov 2012 14:14:42 GMT

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

Re: Forcing all labels to be visable after selection

hic — Sat, 03 Nov 2012 14:21:14 GMT

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

HIC

Re: Forcing all labels to be visable after selection

Sat, 03 Nov 2012 14:29:22 GMT

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

Seems you can have one or the other.

Re: Forcing all labels to be visable after selection

hic — Sat, 03 Nov 2012 14:41:39 GMT

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

HIC

Re: Forcing all labels to be visable after selection

Sat, 03 Nov 2012 14:53:27 GMT

Yes they are both unchecked.

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

Rob

Re: Forcing all labels to be visable after selection

hic — Sat, 03 Nov 2012 15:24:59 GMT

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

Re: Forcing all labels to be visable after selection

swuehl — Sat, 03 Nov 2012 15:30:04 GMT

And if you want to hide the bubbles, just use

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

Re: Forcing all labels to be visable after selection

Sat, 03 Nov 2012 15:54:06 GMT

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!

Re: Forcing all labels to be visable after selection

swuehl — Sat, 03 Nov 2012 16:53:11 GMT

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?

Re: Forcing all labels to be visable after selection

Sun, 04 Nov 2012 10:43:08 GMT

Hi, what I'm after is the chart to look like the first chart in this string of dialogue.

It has the 4 labels along the bottom and the four on the left of the chart. When I filter the chart (see the next chart) I would like all the labels to stay visible.

I can achieve this by un-checking "Suppress Zero-Values" However this presents additional Null values in the chart. (see the third chart). If I then "Suppress when value is Null" it reverts to the second chart

Not sure that clarifies things.

Thanks

Rob

Re: Forcing all labels to be visable after selection

swuehl — Sun, 04 Nov 2012 12:15:03 GMT

Hi Rob,

when I compare your requirement to my Profile_2.qvw attached above, I see exactely this: Four labels to the bottom and four labels to the left even after making selections.

(and it's probably just a matter of taste if you want to hide the excluded values completely or keep them in with a greyish color like Henric did)

So I must miss something else you are after.

Regards,

Stefan

Re: Forcing all labels to be visable after selection

Sun, 04 Nov 2012 16:26:42 GMT

Hi Stefan, apologies - you are right.

It was more a matter of trying to make it work how it should through the calculations!

If I could ask for one more bit of help - I was wanting the bubble colours to always have the colour 7 from the palette.

Thanks Rob

Henric, your help also appreciated.

Re: Forcing all labels to be visable after selection

swuehl — Sun, 04 Nov 2012 17:14:51 GMT

You really want the colour 7 from the palette used in my sample ?

No, just kidding, you just need to specifiy the color in the background color attribute expression:

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

or specify the color using rgb values:

=if(Count(Profile)=0,argb(0,255,255,255),rgb(231,138,210))

Re: Forcing all labels to be visable after selection

Sun, 04 Nov 2012 17:37:17 GMT

no not from your sample but the colour 7 in my qvw

That has sorted it though.

By the looks of it I still need to get the database person to sort the relationships for the data to the filters I'm using but the way it works now is what I need.

Thanks

Rob