Qlik Community

Ask a Question

Integration, Extension & APIs

Discussion board where members can learn more about Integration, Extensions and API’s for Qlik Sense.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Sanju1
Contributor
Contributor

Scattered chart relative bubble sizing

Hi,

I have a dashboard where I show the cost income ratio by country and the bubble chart is what the management requires.

The size of bubbles work perfectly fine when there are no filters applied. But if I choose only (2 countries for example) the size of bubbles are not matching as per the value. 

eg., (UK total cost is 784, France total cost is 734) once we apply the filter only for UK & France the bubble size for UK is becoming 10 X bigger than France and bubble size of France is showing as "Dot". Is there a way to avoid this?

I tried to adjust the bubble size under presentation, I also tried to use some alternatives like [dual (sum(XXX)),Sqrt (sum(XXX))) based on another thread. Nothing helped, looking for some solution. QVF file is attached.

Bubble = Country
X-Axis = Cost per customers
Y-Axis = Cost income ratio
Bubble Size = Cost
 
0 Replies