topic Re: Grid chart - display numbers in bubbles in QlikView

Grid chart - display numbers in bubbles

raynac — Sat, 16 Nov 2024 03:59:31 GMT

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.

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.

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

TIA,

Rayna

Re: Grid chart - display numbers in bubbles

qliksus — Tue, 02 Apr 2019 10:05:18 GMT

whats the issue?? is the numbers wrong or you want a better display of the number ?

Re: Grid chart - display numbers in bubbles

raynac — Tue, 02 Apr 2019 12:10:32 GMT

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.

Re: Grid chart - display numbers in bubbles

qliksus — Tue, 02 Apr 2019 12:29:44 GMT

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

Re: Grid chart - display numbers in bubbles

raynac — Tue, 02 Apr 2019 13:08:30 GMT

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

Re: Grid chart - display numbers in bubbles

sameera — Fri, 24 Jan 2020 13:46:12 GMT

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.

Re: Grid chart - display numbers in bubbles

raynac — Fri, 24 Jan 2020 20:53:16 GMT

Afraid not! I wound up just disabling the display ☹

Re: Grid chart - display numbers in bubbles

sameera — Mon, 03 Feb 2020 19:40:14 GMT

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.