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