Monday, March 27, 2017

Build your custom Geo solution for QlikView in 5 minutes

In this post I will show how to build a Geo plot without the need for GeoAnalytics or Indevio. It will be way more limited functionality wise, you will be able to plot your data on a map. The result will look like this:


First you need a map of which you need to know the lat and long coordinates of the square corners. For this navigate to:
https://www.darrinward.com/lat-long/?id=2778191

Enter a set of coordinates for the corners:


Take a screen capture starting and ending on the specified corners:



In QlikView add a new scatter chart:

Add the lat and long dimensions:



Specify the axis:

Enter next untill this screen. Deselect 'forced 0' and enter the x and y axis ranges, by using the values you used on lat-long website:

As background image to the chart load the screen capture of the lat-long website:

Press finish and your result will look like this:


Obviously, you need to geo code your adress data. This can easily be done by most ETL tools.

Hope this is usefull.

No comments:

Post a Comment