Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

apalmtree
Contributor

Bubble chart

I have a bubble chart where agegroup is represented on the y-axis and number of pets on the x-axis and in the expression i have number of people/total number of people in order to get the precentage of how many peoples that have how many pets.

I would like the procent of the bubbles on the horisontal to add up to 100% but as it is now all the bubbles in tha chart sums up to 100%. Is there a way to get it like a want it to?

Thanks in advance!

//A.

Tags (2)
1 Solution

Accepted Solutions
prieper
Honored Contributor II

Re: Bubble chart

You need to include the dimension, which you wish to sum in angeled brackets, like

SUM(People)/SUM(TOTAL <Pets> People).

HTH
Peter

3 Replies
prieper
Honored Contributor II

Re: Bubble chart

You need to include the dimension, which you wish to sum in angeled brackets, like

SUM(People)/SUM(TOTAL <Pets> People).

HTH
Peter

apalmtree
Contributor

Re: Bubble chart

Thank you!

frankiegoes2hol
New Contributor III

Re: Bubble chart

i have another issue about bubble charts: can i display values inside the bubbles? thanx

Community Browser