World Heatmap using Google API

selcukcadir — Fri, 01 Feb 2013 05:58:46 GMT

hi all,

World Heatmap using Google API

I want to show coloring budget and sales in countries.

sample ;

Country "US" Sales Total = 5100 Budget Total = 23000 rate = %22

red = %0-%25

yellow = %26-%50

blue = %51-%80

green = %80-%100

dark green = < %100

Thanks

Selcuk.

my table;

data:

LOAD * INLINE [

Product, Country, Sales, Budget

A, US, 1000, 5500

B, US, 1500, 6500

A, US, 2000, 7500

C, US, 600, 3500

A, AU, 2000, 4500

A, CN, 1 , 5500

B, CN, 500, 3500

C, IN, 300, 2500

C, CN, 20, 1500

C, NZ, 600, 2500

]

;

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

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

& '&chtm=' & 'world' /* Region */

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

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

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

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

Re: World Heatmap using Google API

Fri, 01 Feb 2013 07:27:20 GMT

Hi refer the below document:

Niranjan M.

Re: World Heatmap using Google API

selcukcadir — Fri, 01 Feb 2013 07:37:10 GMT

I want to use the heat map.

reviewed the document, but in a different thread.

Thanks

Selcuk.

topic World Heatmap using Google API in QlikView

World Heatmap using Google API

Re: World Heatmap using Google API

Re: World Heatmap using Google API