topic Re: Google map issue in QlikView

Google map issue

Mon, 02 Jul 2012 16:02:38 GMT

Hi All,

I am trying to develop a google map for india based on the sales.

i almost reached the steps for developing the google map.but i want to display the only full india map.

but in my application map is showing as follows(pfa),i given all the condition and expression.

symbols is showing in map is correct.i want display only india map with these symbols.

can any knows where this issue is happend.i want to submit now.

thanks in advance,

regards,

baru

Re: Google map issue

Mon, 02 Jul 2012 16:39:32 GMT

Baru

Can you try changing the var_zoom to 4? Try hardcording it; if thats what you need we shall figure out how to arrive there.

Regards,

Kiran Rokkam.

Re: Google map issue

Mon, 02 Jul 2012 16:57:22 GMT

Hi kiran,

thankyou verymuch,

now it is coming only india map.

I have one more dought here,is it possible to give the colours for the states in this map,based on lysm and

current month sales based on the '%' wise.and where i have to give the colour coding here.

thanks,

baru

Re: Google map issue

Mon, 02 Jul 2012 17:07:46 GMT

You need to use different maps (API) for that. Instead of having a chart you need to have a text box with a expression which gives you desired URL (just as the background you already have). For this you need to have the ISO Codes instead of lat and longitude of the geography.

Here is an example of a world heat map. You need to use right variables for the values (chd) and isocodes (chld).

You can get iso codes for india from http://en.wikipedia.org/wiki/ISO_3166-2:IN (instead of inline load use webfile load to get the right codes).

http://chart.apis.google.com/chart?
cht=map:fixed=-55,-180,84,180
&chs=620x400
&chld=AE|AF|AL|AO|AR|AT|AU|BA|BE|BG|BH|BO|BR|BW|BY|CA|CD|CG|CH|CI|CL|CM|CN|CO|CR|CY|CZ|DE|DK|DO|DZ|EC|EE|EG|ES|FI|FM|FR|GB|GE|GH|GL|GR|GT|HK|HN|HR|HU|ID|IE|IL|IN|IR|IS|IT|JM|JO|JP|KE|KP|KR|KW|KZ|LA|LB|LT|LU|LV|MA|ME|MK|ML|MT|MU|MW|MX|MY|NF|NI|NL|NO|NZ|OM|PA|PE|PH|PK|PL|PR|PT|RO|RS|RU|SA|SE|SG|SI|SK|SN|SV|TH|TN|TR|TT|TW|TZ|UA|UG|UM|US|UY|VE|VN|YE|ZA|ZW
&chd=t:3,1,1,1,126,157,668,1,308,7,1,4,1406,3,3,1672,1,3,716,7,56,3,300,320,12,9,96,3024,469,1,26,23,8,29,654,119,1,3359,2968,2,3,1,177,8,25,2,21,70,10,227,80,286,6,4,883,4,5,4757,2,7,246,1,2,1,9,10,1,7,7,2,5,1,5,2,4,329,23,1,1,554,133,60,1,6,35,94,8,183,21,112,32,12,125,9,380,53,22,30,1,6,44,25,151,1,286,1,21,17,1,73280,5,55,25,1,110,4
&chco=CCCCCC,99CC00,CCFFCC,FF9933,FF0000,CC0033
&chm=f+3,1,1,1,126,157,668,1,308,7,1,4,1406,3,3,1672,1,3,716,7,56,3,300,320,12,9,96,3024,469,1,26,23,8,29,654,119,1,3359,2968,2,3,1,177,8,25,2,21,70,10,227,80,286,6,4,883,4,5,4757,2,7,246,1,2,1,9,10,1,7,7,2,5,1,5,2,4,329,23,1,1,554,133,60,1,6,35,94,8,183,21,112,32,12,125,9,380,53,22,30,1,6,44,25,151,1,286,1,21,17,1,73280,5,55,25,1,110,4,000000,0,1,10
&chof=gif

Regards,

Kiran Rokkam.

Re: Google map issue

Mon, 16 Jul 2012 09:27:44 GMT

Hi Kiran,

thanks for your help and reply,

Kiran,I doing to develop the heat map for india. I did lot of R & D for this but i am unable to develop the heat map for india.

You have any example application for the above post or can you guide me how to develop the heat map for india.

Thanks in advance,

regards,

baru

Re: Google map issue

Mon, 16 Jul 2012 09:41:36 GMT

Its not easy, you need to create this string (use aggr and concat functions)

Kiran Rokkam.

Re: Google map issue

Mon, 16 Jul 2012 10:25:30 GMT

Hi,

Thanks for your reply,

can i have any sample(example) application for this,so that i can do the development.

Above attachment is my google map example,now i want to create heat map for india instead of google map.

Thanks in advance,

regards,

baru