Bubble chart with text dimension on X axis

HeatherC — Sat, 16 Nov 2024 19:57:47 GMT

I'm trying to recreate a chart I made in Tableau (see attached) which illustrates variation among divisions and the teams within those divisions and shows the relative size of the teams.

I managed to do this by choosing a line chart with the division and team as dimensions and rate= sum(numerator)/sum(denominator) as the expression. Then I used a symbol rather than a line.

But have TWO pieces that don't work:

1) The size of the symbol should reflect the denominator (sum(denominator)) for each team - I can do this in a scatter chart, but I can't get text on the x-axis in a scatter chart and I can't seem to change the size of the symbols based on an expression in a line chart.

2) the black squares represent the mean for each division- in Tableau I did this with a dual axis - I tried doing this with a second expression and used set expression to include all the teams, but it wiped out the symbols for the individual teams that I created with the first expression.

Re: Bubble chart with text dimension on X axis

Brett_Bleess — Thu, 10 Oct 2019 14:24:51 GMT

Heather, best I have is the following URLs, hopefully they may help you move it forward:

https://community.qlik.com/t5/Qlik-Design-Blog/Recipe-for-a-Scatter-Chart/ba-p/1468860

https://community.qlik.com/t5/Qlik-Design-Blog/Coloring-a-Scatter-Plot/ba-p/1470614

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scatter_Chart.htm

Sorry I do not have anything better. My post will kick things back up in the list as well, so maybe someone else will see things and have some other info for you.

Regards,
Brett

topic Re: Bubble chart with text dimension on X axis in QlikView

Bubble chart with text dimension on X axis

Re: Bubble chart with text dimension on X axis