issue in getting plots on a google map in qlikview

[Qlik_Enthu]

Dear All,

I followed steps from the document "Steps to implement Google map in Qlikview" and BillionRows.com tutorial, to create a map.

I got the below result:

My issues with this scatter chart are as follows:

1. I deal with only EU countries, hence I do not want the other continents to be visible in the map.

2. The plots are visible in the bottom left corner of the map object and unable to plot accurately over the Europe on the map.

Location Data:

I used the coordinates from the file:

https://developers.google.com/public-data/docs/canonical/countries_csv]

I used map image from the link: ='http://maps.googleapis.com/maps/api/staticmap?center=' &  num(var_mid_lat, '##############', '.', ',' ) & ',' &  num(var_mid_long, '##############', '.', ',' ) & '&zoom=$(var_zoom)' & '&maptype='&var_maptype  & '&size='&map_size_x&'x'&map_size_y  & '&sensor=false' & '&scale=&map_scale

My Expressions are as follows:

Longitude: =sum( round (256*pow(2,($(var_zoom)-1)))+( longitude  *((256*pow(2,$(var_zoom)))/360)) )

Latitude: =sum( 
((256*pow(2,($(var_zoom)-1)))+((0.5*log((1+(sin((latitude)*pi()/180)))/(1-(sin((latitude)*pi()/180)))))*((-256*pow(2,$(var_zoom)))/(2*pi()))))
)

Total Orders created :Count(EU.CUSORD_NO)+Count(EUX.CUSORD_NO)

Axes:

X-axis- Static Min & Static Max:

(256*pow(2,($(var_zoom)-1)))+( var_mid_long  *((256*pow(2,$(var_zoom)))/360)) -round(map_size_x/2) 

((256*pow(2,($(var_zoom)-1)))+( var_mid_long  *((256*pow(2,$(var_zoom)))/360)) + round(map_size_x/2))

Y-axis- Static Min & Static Max:

=((256*pow(2,($(var_zoom)-1)))+((0.5*log((1+(sin(var_mid_lat*pi()/180)))/(1-(sin(var_mid_lat*pi()/180)))))*((-256*pow(2,$(var_zoom)))/(2*pi())))+round(map_size_y/2))

=((256*pow(2,($(var_zoom)-1)))+((0.5*log((1+(sin(var_mid_lat*pi()/180)))/(1-(sin(var_mid_lat*pi()/180)))))*((-256*pow(2,$(var_zoom)))/(2*pi())))-round(map_size_y/2))

How to correct this as per my requirement. Can someone help?

Thank you!

Sai

[Frank_Hartmann]

Ohhh, i guess you will have to install qv on a different machine with new attempts to open other files

in order to get your file working again

as far as i know qv updates the license key when opening an other file by using one of the 4 attempts.

your former created files thus have a different key and qv do not recognize these files as yours anymore