Hi all,
I have 3 sets of data:
- Primary data set with transactional details
- locational data (lat,long) that corresponds to the primary data set through a FK
- KML files of the regions in Singapore
I would like to plot out a visualisation using map chart to look at various measures within the region as defined by the polygons on the KML file. However, my locational data do not have a name that corresponds to the KML name that defines the region, it only has the lat and long coordinates. Is there any way which I could plot the visualisation such that as long as the lat, long coordinates falls within the defined polygon, the summarised measure of the region would be aggregated?
I know this is possible with d3.js. Is it also possible for qlik?
Thank you!