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.
