topic displaying data on a geographic map in QlikView

displaying data on a geographic map

Tue, 08 Feb 2011 23:27:54 GMT

Hi there,

I have sales and budget data by state. I want to know how I can plot this information on a map. I have been successful in using lat and long codes to plot points on a map, but what I want to do now is different.

For example I will have 50 numbers for the country. One number for each state. I want to color the country by different shades of color based on the number that the state has acheived. If the 50 numbers I have are percentage figures, I want any state that is below 0% to be red, any state that is 0-10% to be yellow and any state >10% to be green. Can someone show me how to do this?

Thanks,

displaying data on a geographic map

Tue, 08 Feb 2011 23:38:44 GMT

Further to my last post, I am attaching an image of what I would like to see:

Imagine the map below where the colors on this map represent a number. I want the entire state to be a color and not just a point on the state map.

displaying data on a geographic map

johnw — Wed, 09 Feb 2011 01:27:23 GMT

IF it's possible, it would probably only be possible with version 10 extensions, which I haven't studied. Basic QlikView charts simply don't let you color in state-shaped blobs. You get circles and squares. Now, technically, you could probably make every single pixel on your screen be a circle in, say, a scatter chart, but that would be pretty horribly complex, I think. Hopefully extensions will somehow handle what you need. Sorry I can't be of more help.

displaying data on a geographic map

Anonymous — Wed, 09 Feb 2011 01:29:32 GMT

There is an extension object somewhere based on the Google GeoMap for vizualisation which lets you do exactly that.

(More on GeoMap here: http://code.google.com/apis/visualization/documentation/gallery/geomap.html)

I can't seem to locate the extension object at the moment though but I played around with it before.

displaying data on a geographic map

Wed, 09 Feb 2011 06:53:54 GMT

Sir Johannes Sundén

If you found the extension can you post it here so we (newbies) can acquire additional knowledge..

All:

Where can I find a tutorial about extensions?

thanks!

displaying data on a geographic map

Wed, 09 Feb 2011 08:30:09 GMT

You find one example of this in the "cookbook":

http://robwunderlich.com/downloads/cookbook_V009.1.zip

See the "Generate geographical heat map using Google Chart API" example.

As you can see it uses google chart api, so you'd better check the license for that.

Example from the above document:

http://chart.apis.google.com/chart?&cht=t&chs=440x220&chtm=usa&chco=f5f5f5,edf0d4,6c9642,13390a&chld=CANYHIWANVTNTX&chd=s:9bALIAI

displaying data on a geographic map

Tue, 22 Feb 2011 18:45:39 GMT

You should have a look at the GeoQlik software (www.geoqlik.com). It embeds the QlikView plugin in order to add maps objects to an existing QlikView application.

displaying data on a geographic map

Thu, 25 Aug 2011 19:09:13 GMT

I was able to generate a heat map via the google maps, however, I need to calculate percentages for each state individually rather than relative to the rest of the county - similar to what the original poster wants to do.

'='http://chart.apis.google.com/chart?&cht=t'

& '&chs=' & '440x220' /* Chart size */

& '&chtm=' & 'usa' /* Region */

& '&chco=' & 'f5f5f5' /* Color for no value */

& ',' & 'edf0d4,6c9642,13390a' /* Color gradient */

& '&chld=' & concat(DISTINCT State, '', fieldIndex('State', State))

& '&chd=s:' & concat( aggr( mid('$(simpleEncodingMap)', 1+round(61*sum(Sales_Amount)/max(TOTAL aggr(DISTINCT sum(Sales_Amount), State)),1),1), State), '', fieldIndex('State', State))'

but basically, I only want to sum the Sales_Amount if a sale was made at night: sum(if(Sales_Indicator = 'Night',Sales_Amount))

as of now, the expression is simply color-coding the states relative to the country as a whole. I'm guessing the "agg" function might have something to do with it?

thanks!

displaying data on a geographic map

Mon, 30 Apr 2012 21:31:29 GMT

Hi,

I tried to implement something like this with google charts (visualization : geochart).

Pls. check my blog at http://quickdevtips.blogspot.com/2012/04/google-geochart-in-qlikview.html

I hope it helps.

Best regards,