topic Re: Sales Map in QlikView

Sales Map

pkelly — Sun, 01 Aug 2010 13:25:26 GMT

I would like to crete a map of the uk split by our geographical areas but don't really know where to start.

Idea would be that the user would click on an area which in turn would filter the various charts and pivot tables within the report.

I have looked about the various shared examples but would appreciate some guidance on the process that I should go through.

For example, I believe that I would have to build a table with our geographical areas latitude and longitude - where would I find this information.

I would like my map to be colour coded so say Scotland would be shaded blue, east England green, west England brown and Wales red (for example) - what is the best way to do this?

Any guidance greatly appreciated...

Sales Map

Sun, 01 Aug 2010 17:40:49 GMT

Hi Paul,

Thanks to you, I spent one hour, to learn the UK geography. lol

Please find a mini application which display some datas.

I found out in the web a database with the coordinate of each postcode, and the link with local & region area. I'm not sure these data are 100% exhaustive & accurate. But it's just to show you how we can use them. I also generated random sales for each postcode.

The apps displays the sale for each postcode (bubble size), the local area or postcode (color of the bubble).

Hope it will help you

Jean-Jacques

Sales Map

pkelly — Mon, 02 Aug 2010 08:00:39 GMT

Thank you very much Jean-Jacques

Your effort and time spent on this is greatly appreciated.

Just highlights the quality of help that you get from users on this forum.

Re: Sales Map

Fri, 14 Dec 2012 11:34:24 GMT

Great example Jean-Jacques!!!

I am using it now.

Could you explain how you added bubble colours to the map object and where to control it?

Thanks.

Re: Sales Map

Anonymous — Fri, 14 Dec 2012 11:43:20 GMT

The bubble colours in this example are taken from the Colours sheet of the Chart properties.

Bubble colours can also be set on the Background colour of the Bubble size expression (the third of three expressons), reached by expanding the symbol alongside the expression.

Jonathan

Re: Sales Map

Fri, 14 Dec 2012 11:53:04 GMT

Please add PE enabled file

Re: Sales Map

Fri, 14 Dec 2012 12:00:53 GMT

Thanks for a quick response Jon.

I am looking at it right now.

One more question - is it possible to add zoom in/zoom out arrows to this example?

At the moment the I can zoom in by selecting an area on the map and zoom out by only clearing my selections.

Thanks.

Re: Sales Map

Anonymous — Fri, 14 Dec 2012 12:16:34 GMT

Not that I know of. However, as the map is courtousy of Google, and is essentially regenerated as a URL after you interact with it, you may be able to get another link that shows a corresponding Zoom In/ Zoom out widget.

A look though Google's API guide may yield something interesting.

Jonathan