Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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)'.
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
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.
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.
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
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!!!
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
Got it, thanks
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