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: 
Anonymous
Not applicable

Bubble chart

I have a Table that contains a few columns like this:

Column A : Date

Column B: Time

Column C: Network ID

Column 😧 Customer ID

Column E: Customer status

Column F: Time (in sec)

Column G: Region (Region A, B, C....etc.)

Column H:

Column E indicates the status of the customer, whether it is in network or out of network and column F  tells how long it has been in or out of network.

Another table loaded also simply has columns

Column A: range

Column B: label

I was able to create a chart showing range that shows how many times customer in  network for certain period (e.g. 10 minutes). This is by using range as dimension and expression as follows:

=sum(if(aggr(sum(if(([Time in sec]<60*10 and Customer_status='IN_NETWORK'), 1,0)),Customer_ID, Network_ID, Region, range)<=range and aggr(sum(if(([Time in sec]<60*10 and Customer_status='IN_NETWORK'), 1,0)),Customer_ID, Network_ID, Region, range)>range-1,1,0))

with a chart that I got like below:

range.png

Now I'd like to draw a bubble chart showing the quantity of in/out network experienced by each customer over period of time. I tried to use some combination available parameters but it seemed not working as I expected. No proper bubble chart is showing up with scatter plots.

Any suggestions how this should be done?

0 Replies