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
|Beaufort West||Dec 2012||-31.9066||23.0684||32|
|East London||Dec 2012||-32.4276||27.63957||524|
Data source 2 -- however this data will not plot as response information is available.
|Beaufort West||Aug 20101||0||-31.9066||23.0684||196|
|Beaufort West||Aug 20101||1||-31.9066||23.0684||33|
|East London||Aug 20101||0||-32.4276||27.63957||2714|
|East London||Aug 20101||1||-32.4276||27.63957||163|
I've attached the files being and the qlikview template. Hope you can assist.