topic Google Maps - Display different Scatter Object / Colours in QlikView

Google Maps - Display different Scatter Object / Colours

Fri, 29 Jan 2010 12:14:40 GMT

Within the system I'm working with a list of lead data. The snap shot of the data looks something similar to this

LOAD * INLINE [
Lead_LeadID, 4Lead_Stage, outcode, longitude, latitude
5806, Lost, BL2, -2.391324, 53.593693
5630, Postponed Purchase, BL3, -2.422751, 53.568916
6195, Won, BL4, -2.4, 53.547
];

What I would like to do either change the symbol or colour of the symbol based on the Stage of the lead. I currently have the Lead_leadID as the dimension but I have tried using lead_stage as the dimension and that only plots 7 points on the scatter chart (count of distinct stages) and my database contains roughly 4000 records

Any help would be greatly appreciated.

Google Maps - Display different Scatter Object / Colours

Fri, 29 Jan 2010 13:44:18 GMT

Putting as dimension lead_stage make qlikview calculate the barycenter of you 7 value.

So you have to put 2 dimensions

Lead_LeadID : must be unique ( One Id = One location )

Lead_Stage : you will get one color for each value (7 values).

In the expression you put logitude, latitude. You can also, if you have a value do display for each Lead, put this value (sum(value)). It will display different bubble.

Google Maps - Display different Scatter Object / Colours

Fri, 29 Jan 2010 15:03:32 GMT

You are a legend. Cheers.