Google Maps

Mon, 10 Dec 2012 15:31:40 GMT

Hope someone can assist out there.

The exercise which I am doing is to plot the various regions where mailings have been done. In addition to this I need to plot response rates where this is available. I have 4 data sources, 2 of which have response rates. The problem I have is that the information is not plotting for any regions whre there is infomation for both response and no response. Effectively where a region occurs twice in the data.

Data Souce 4 -- In this instance the data will plot fine as no response information

Area	Mailing	Lat	Long	_FREQ_
Beaufort West	Dec 2012	-31.9066	23.0684	32
Bloemfontein	Dec 2012	-29.0371	26.98103	797
East London	Dec 2012	-32.4276	27.63957	524
Gauteng	Dec 2012	-26.1315	28.09089	7501
George	Dec 2012	-33.9439	22.28426	151

Data source 2 -- however this data will not plot as response information is available.

Area	Mailing	Responded	Lat	Long	_FREQ_
Beaufort West	Aug 20101	0	-31.9066	23.0684	196
Beaufort West	Aug 20101	1	-31.9066	23.0684	33
Bloemfontein	Aug 20101	0	-29.0371	26.98103	2956
Bloemfontein	Aug 20101	1	-29.0371	26.98103	228
East London	Aug 20101	0	-32.4276	27.63957	2714
East London	Aug 20101	1	-32.4276	27.63957	163
Gauteng	Aug 20101	0	-26.1315	28.09089	28642
Gauteng	Aug 20101	1	-26.1315	28.09089	1617
George	Aug 20101	0	-33.9439	22.28426	1330
George	Aug 20101	1	-33.9439	22.28426	124

I've attached the files being and the qlikview template. Hope you can assist.

topic Google Maps in QlikView

Google Maps