Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
HeatherC
Contributor II
Contributor II

Bubble chart with text dimension on X axis

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.

Labels (2)
1 Reply
Brett_Bleess
Former Employee
Former Employee

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

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.