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.
