topic Re: How to create a grouped bubble 'line' chart in QlikView

How to create a grouped bubble 'line' chart

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I am looking to create a linear bubble chart to show grouped values.

I want the bubbles to be in a single line, descending in size, with the grouping driving the color:

So Category drives what color it would be, the SubCategory is the bubble, and the count determines the size of the bubble. I want to sort descending by count, so the colors won't stay grouped together, necessarily.

Can this be done in Qlik, and how? I'm struggling to get scatter chart to work right cause it won't work without a 'Y' axis (which I don't need/want - since they need to just be in a line). I also can't figure out how to keep similar Category items the same color.

Any help would be appreciated. Thank you!

Re: How to create a grouped bubble 'line' chart

sunny_talwar — Mon, 23 Oct 2017 16:31:46 GMT

Like this?

Re: How to create a grouped bubble 'line' chart

sudeepkm — Mon, 23 Oct 2017 16:58:45 GMT

on top of Sunny's solution if you want to show numbers then you can achieve it by using a text on chart options as below.

It is not perfect.

Re: How to create a grouped bubble 'line' chart

sunny_talwar — Mon, 23 Oct 2017 17:02:21 GMT

Doesn't look right when selection is made

Are there other options?

Re: How to create a grouped bubble 'line' chart

sudeepkm — Mon, 23 Oct 2017 18:10:45 GMT

you are right I tried to create a dynamic spacing as per the total width of the chart but it seems the PIXEL and Space ('') has diff.

by the way another way is to have these numbers along with the dimension values:

using dimension as below

=SubCategory&' ('& aggr(sum(Count),SubCategory)&')'

Re: How to create a grouped bubble 'line' chart

sunny_talwar — Mon, 23 Oct 2017 18:27:51 GMT

Looks much better

Re: How to create a grouped bubble 'line' chart

sudeepkm — Mon, 23 Oct 2017 19:01:25 GMT

thnx a lot.