Scatter Charts / Maps without extensions 

Few days ago I had to implement a distribution graph showing sales per customer on a GoogleMaps.

The small bubbles aren’t show

While there are some extensions able to do this no one (at least among free) implements a drag-zoom so that when you zoom in a map area it affect the current selections. On the other hand most of the extensions require at least some changes in its javascript to represent amounts with sizes (grater sales = larger bubble).
Mainly for these two reasons I decided to use a scatter chart to display this information.
Anyone who has used one of these chart previously known that the bubble size often becomes a real problem and the Presentation tab gives few parameters to display the information in a way that meets all the requirements:
1- Larger bubbles should not hide the map nor the smaller adjacent bubbles. This means that increasing the “Symbol Size” it is rarely the right answer.
2- All bubbles must appear, even if in relative percentage of the greatest of all is negligible (eg: some bubbles representing $ 100 million and other $ 1000).
3- The values ​​represent the graph must be real ($ 100 million and $ 1000). Can not display text value other than what is actually sold.
It is understandable that a user wants to see ALL customers on the map and not that being tiny percentages do not appear or are almost invisible. Searching, I found someone asking about the key problem here: how could set the “minimum bubble size” ? Unfortunately the question was not answered, but reviewing the very Qlikvie’s examples I discovered the solution:
To represent a map three expressions are used: the first corresponds to the longitude, the second to the latitude and the third one is the volume or size of the bubble. To set a minimum size while displaying the correct values (as a pop-up) ​​should be used only a “dual” function in this last expression, eg:

dual(‘Sales: ‘ & SUM(SALES),

if(  SUM(SALES) < 0.05 * max(total aggr(sum(SALES),CUSTNMID)) ,

0.05 *  max(total aggr(sum(SALES),CUSTNMID)) ,


QlikView will use the text component (first part of the dual) to display when the user hovers the cursor over the bubble, but if sales are less than 5% (0.05) of the sales of the largest customer (“max (total aggr (sum (SALES), CUSTNMID)) “) then it defines the size of the bubble as 5% of the size of the largest bubble, thus achieving a” minimum bubble size. “
Aditionally: If you want the bubbles to even distinguish if overlie assigning them a spherical shape and an accent color (eg: rgb (255,0,255)) by putting it in the first expression (longitude).

Acerca de pparnisari
Casi 44 vueltas al sol. Licenciado en sistemas. Curioso, investigador, excelente para resolver problemas prácticos. Casado, 2 hijos, cada vez con mas preguntas y respuestas mas en duda. Almost 44 laps to the sun. System engineer. Curious, researcher, great for solving practical problems. Married, 2 children, each time with more questions and more answers in doubt.

Deja un comentario

Introduce tus datos o haz clic en un icono para iniciar sesión:

Logo de

Estás comentando usando tu cuenta de Cerrar sesión /  Cambiar )

Google+ photo

Estás comentando usando tu cuenta de Google+. Cerrar sesión /  Cambiar )

Imagen de Twitter

Estás comentando usando tu cuenta de Twitter. Cerrar sesión /  Cambiar )

Foto de Facebook

Estás comentando usando tu cuenta de Facebook. Cerrar sesión /  Cambiar )


Conectando a %s

A %d blogueros les gusta esto: