Add bubble size next to bubble label on top of bubbles of a scatter plot - Qlik Sense service

[NikosSpanos]

I have created the following scatter plot (created on Qlik Sense Service):

Bubble chart/scatter plot

And I want next to each label, which represents a dummy customer, to add the bubble's size (aka sales measure)

and finally get something like:

Desired result

Any suggestions are much appreciated.

[GaryGiles · Accepted solution]

If your dimension is Customer and the measure that you want to include is sum(Sales), you could use the following as your Dimension expression to get sum(Sales) to show up in the bubble label:

=Aggr(only(Customer)&' : '&sum(Sales),Customer)

You will want to add whatever set analysis you need and num() formatting for sum(Sales).

Hope that helps.

[Anil_Babu_Samineni]

Try this?

Dual(DimensionName & '( ' & Aggr(YourMeasure, DimensionName) & ' )', YourMeasure)

[NikosSpanos]

@GaryGiles  Ty a lot for the answer. It works as expected. Also the hint with the number formatting was useful because I have numbers in millions. One last thing I would like to ask. Do you know if its possible to move the number below Dimension name?,

"Customer:

Number of sales" (practically add an empty line)

I tried the chr(10) expression but it didn't seem to work. So I thought asking you 🙂

[GaryGiles]

Chr(10) is what I would have tried.  Unfortunately, I'm not aware of another way to potentially add a line feed to a label.

[NikosSpanos]

Could you please post as a reply the expression of your solution with Chr(10)?

What I have tried is =Aggr(only(Customer)&' : '&chr(10)&sum(Sales),Customer) but the value is still next to the label

Result after addint Chr(10)

[GaryGiles]

Sorry, I meant that chr(10) does not work for me either in the Scatter Chart label and that is the only thing I knew to try.  I don't know of a way to get the sum value on the line below.  

[NikosSpanos]

Aww ok, good to know that because I was struggling to. Thanks again for the reply. I will accept your solution 🙂