Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Google Maps - Display different Scatter Object / Colours

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.

1 Solution

Accepted Solutions
Not applicable
Author

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.

jj


View solution in original post

2 Replies
Not applicable
Author

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.

jj


View solution in original post

Not applicable
Author

You are a legend. Cheers.