topic Sales territory mapping in QlikView

Sales territory mapping

Tue, 23 Jul 2013 19:30:37 GMT

I am new to QV, and am trying to do mapping:

I have an xls with ZIP code and sales $, and would like small circles at the cities where we have little sales, and large circles where we have a lot of sales. Eventually I would like to generate a "heat map" that shows those states with little sales in dim color and those states with much sales in bolder colors.

How do I go about that?

Re: Sales territory mapping

luciancotea — Tue, 23 Jul 2013 20:02:27 GMT

You need longitude and latitude information to map the circles over a map. To get extra information to your address list, you can use a geocoding service like here: http://luciancotea.wordpress.com/2013/07/18/google-maps-how-to-automatically-spell-check-customer-addresses-and-get-extra-location-information/

After that, you can use a QlikView & Google Map template like this one: http://community.qlik.com/docs/DOC-3136 to start mapping your information.