topic Re: Custom popup labels on Scatter Chart in QlikView

Custom popup labels on Scatter Chart

Tue, 10 Dec 2013 16:07:08 GMT

I need to customize my chart popup labels. All the posts I looked at talk about popup label on bar chart and provide the solution given in Qlikview cookbook.

I want to custmize scatter chart popup labels. It shows all the dimensions and expression value in popup. One of my dimension is ID and I do not want to show that in popup label. How can I do this?

Re: Custom popup labels on Scatter Chart

DavidFoster1 — Tue, 10 Dec 2013 16:13:07 GMT

I dont think you can get rid of it completely. I tend to use a calculated dimension to concatenate my key dimension with a more meaningful dimension. For example if I was looking at invoice data I would used the customer and invoice ID to give me something like 'ACME LTD (INV12345)'.

Re: Custom popup labels on Scatter Chart

Tue, 10 Dec 2013 16:17:00 GMT

I wanted to do that, but then I do not want to add it as another expression of dimension to be visible on my chart. I need to display X, Y and Z as they are on the label

Something like

X: value of X

Y: value of Y

Z: Value of Z

Dimension3: Value of Dimension 3

Re: Custom popup labels on Scatter Chart

DavidFoster1 — Tue, 10 Dec 2013 16:20:28 GMT

I use that kind of calculated dimension instead of the original dimension. So long as the calculated dimensino has the same level of uniqueness (which it will because it has the ID field in it) then you should get the same chart.

Re: Custom popup labels on Scatter Chart

Tue, 10 Dec 2013 17:32:57 GMT

Sorry, I didnt understand.

I do not have any calculations for dimension. I just want to display those parameters in the Legend and if I add another dimension it will still be ID as thats what makes my unique bubbles. How would it help? I cant create an expression for another dimension without including the ID if I want to show all the rows with unique id.

Re: Custom popup labels on Scatter Chart

vgutkovsky — Tue, 10 Dec 2013 18:02:20 GMT

To get rid of the annoying default pop-up labels:

1. Go to the Presentation tab, and uncheck "Pop-up Labels"

2. Go to Expressions. As you know, expression 1 is the X-axis, expression 2 is the Y-Axis and expression 3 is the Z-axis. Create a 4th expression, and select the "Text as Popup" checkbox. Create whatever popup text you want in this expression.

Regards,

Vlad

Re: Custom popup labels on Scatter Chart

Tue, 10 Dec 2013 18:28:03 GMT

Thanks Vlad, that worked for me. But that changed my legend labels which were based on dimensions before and now showing labels for each expression in Legend. So I unchecked 'Use expression as Legend, but now I dont have Legend.

For workaround I have added the information of the Legend in the label itself. But I am really happy that I have gotten what I want. Now if I could show the legend too, that would be amazing!!!

Re: Custom popup labels on Scatter Chart

vgutkovsky — Tue, 10 Dec 2013 18:32:21 GMT

When you create a manual pop-up expression, you need to define everything that should be in the popup. So something like:

Dimension1

& chr(10) &

Dimension2

& chr(10) &

num(Expression1,'#,##0')

As far as the "expression as legend", your first 3 expressions should have this enabled, and your 4th should have it disabled.

Regards,

Vlad

Re: Custom popup labels on Scatter Chart

Tue, 10 Dec 2013 18:37:27 GMT

Got it, thanks

Re: Custom popup labels on Scatter Chart

Wed, 08 Jan 2014 14:24:06 GMT

But if you don't want any of the expressions as legend, buth instead one or more of the dimensions?

I am currently unable to achieve this.

Whenever I enable a 4th expression (e.g. for pop-up), my whole legend disappears.

Regards

Andreas

Re: Custom popup labels on Scatter Chart

vgutkovsky — Tue, 14 Jan 2014 21:02:07 GMT

Andreas, I'm not sure what you mean by "one or more" dimensions. A scatter chart must always have exactly 1 dimension.

Assuming you meant just one dimension, however, see my last reply to Gomti. You'll need to disable "expression as legend" for the 4th expression.

Regards,

Vlad

Re: Re: Custom popup labels on Scatter Chart

Wed, 15 Jan 2014 07:18:16 GMT

Vlad,

to my knowledge it is possible to have more than one dimension in a Scatter Chart. This is mentioned in the QlikView Reference Manual as well. But this does not matter, the effect is present whether you have one or more than one dimension.

I attached an example dashboard in which you can see that the setting "expression as legend" is actually disabled for the 4th expression. But this has no effect on the disappearing legend.

Whenever you enable the 4th expression (using the checkbox "Enable", not the checkbox "Expression as legend"!), the legend disappears completely. In the attached dashboard, the 4th expression is currently set to "not enabled", so that the legend is displayed. You will need to "enable" it to see the effect.

Regards

Andreas

Re: Re: Re: Custom popup labels on Scatter Chart

vgutkovsky — Tue, 28 Jan 2014 19:13:25 GMT

Andreas, the reason this is happening is precisely because scatter charts do NOT support 2 dimensions. See attached (your application, but with 2nd dimension disabled).

Regards,

Vlad

Re: Re: Re: Custom popup labels on Scatter Chart

Wed, 29 Jan 2014 07:08:21 GMT

Vlad, I found that it is actually the combination of more than one dimension AND more than 3 expressions that causes the disappearance of the legend.

Regarding the support of more than one dimension in scatter charts, I found statements in the QlikView Reference Manual for V11, which explicitly allow this (see attached screenshot).

And finally: the chart itself works perfectly, it is just the legend that causes issues.

Kind regards

Andreas

Re: Custom popup labels on Scatter Chart

Tue, 13 Oct 2015 17:28:28 GMT

Thanks Vlad you have explained very clearly. I followed exactly and still not able to create a custom popup label. Can you please assist. The data points on the scatter chart get connected thru lines. Even if I change the view I do not see custom popup label until I click on one data point. I can see it then.