topic Distance between PostCodes in QlikView

Distance between PostCodes

richard_chilvers — Wed, 14 Aug 2013 09:01:35 GMT

I have a table of customer postcodes (with Lat & Long) and I would like to calculate the distance of each from about 12 different depots (and then find the closest depot to each postcode).

Has anyone done something similar using Google Maps API (driving distance), perhaps using a QV extension?

Any advice is welcome.

Thanks

Re: Distance between PostCodes

swuehl — Wed, 14 Aug 2013 09:08:39 GMT

Maybe like suggested here:

http://community.qlik.com/thread/66799

Re: Distance between PostCodes

Gysbert_Wassenaar — Wed, 14 Aug 2013 09:14:03 GMT

See this discussion or this one or maybe this one.

Re: Distance between PostCodes

richard_chilvers — Wed, 14 Aug 2013 09:46:42 GMT

Thanks as always for quick response.

All the discussions I have seen so far use fairly complicated calculations. In an attempt to keep my QV model simple, I was hoping to find someone who had already used Google maps to do this - I have recently used a borrowed QV extension to display Google heat maps

Maybe I will try to find the time to build an extension myself.

Regards