Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.