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: 
raynac
Partner - Creator
Partner - Creator

Grid chart - display numbers in bubbles

Hi all,

My company owner likes the grid chart but wants the numbers in the bubbles. 

I understand there is no native way to do this...but I found a post on Friday that had a solution, along with a matching view to show how to do it.

It's not working for me and I am not sure why.

The two dimensions were Month and Product and he added a third dimension:

=dual(aggr(count(Product),Month, Product),Product)

In my case, I am using Date and Hour and I added a third dimension:

=aggr(sum([Chats Received]),Date, Hour)

His is correct.

NumbersInBubbles3.JPG

Whereas mine changed the colour of the bubbles to co-ordinate with the number of chats received (not entirely uncool, IMHO) but the number in the bubble is totally incongruent with that of the one that appears in the legend and popup. 

NumbersInBubbles4.JPG

I cannot see what's amiss here.  Attaching the view in case anyone can assist! 

TIA,

Rayna

Labels (2)
7 Replies
qliksus
Specialist II
Specialist II

whats the issue?? is the numbers wrong or you want a better display of the number ?
raynac
Partner - Creator
Partner - Creator
Author

The numbers are actually incorrect.  The pop ups are fine (when you hover over the bubbles with the mouse) but the displayed numbers are wrong.

qliksus
Specialist II
Specialist II

The Pop-up shows the output of your expression try making your calculated dimension and expression the same and check the numbers
raynac
Partner - Creator
Partner - Creator
Author

Thanks for the suggestion! I did that but there was no change. When I check the pop up, the calculated dimension and the expression match each other in all cases (and did even when the expression and calculated dimension were different).

But, still, when I click on the Labels on Datapoints, the numbers that display in the bubbles in no way coincide with the numbers I get in the pop ups. And they are consistent in being wrong. As in, the yellow bubbles should all be 2 but all say 5 etc...

sameera
Contributor II
Contributor II

Were you able to get this issue solved? I am having a similar problem, where the data labels do not coincide with the colors assigned to the bubbles in the grid chart. 

raynac
Partner - Creator
Partner - Creator
Author

Afraid not! I wound up just disabling the display ☹
sameera
Contributor II
Contributor II

Actually, I got this to work. The expression used itself was wrong . I ended up using a combination of AGGR and ONLY and got the values to show up correctly. The value I wanted to display was a string and I had to group it with AGGR for it show up correctly.