Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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.
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.
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!
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
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.
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!
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,