topic Re: Problem in Google Map With Qlikview in QlikView

Problem in Google Map With Qlikview

Wed, 26 Mar 2014 05:16:40 GMT

Hi,

we are using google map in qlikview for showing Sales of agents.

we provide longitude and latitude of Bhopal and Jaipur.

but when i am looking in google map, all are showing in different location.

Can anyone give me reason or it has some limitations in qlikview.

if possible please send latest qvw with google map.

I am attaching google map screen shot. i am using below code.

var_pi180=

'=pi()/180';

var_lat_offset= '0';

var_mc2=	'=256*pow(2,$(var_zoom))';
var_mc1=	'=256*pow(2,($(var_zoom)-1))';
var_mc3=	'=256*pow(2,$(var_zoomb))';
var_mc4=	'=256*pow(2,($(var_zoomb)-1))';

var_mid_lat= '=min(latitude)+(1+var_lat_offset)*((max(latitude)-min(latitude))/2)';

var_mid_long= '=min(longitude)+(max(longitude)-min(longitude))/2';

var_zoom=

'=max(aggr(if(max( round(256*pow(2,(_zoom_level -1)))+( longitude *((256*pow(2,_zoom_level ))/360)) )-min( round(256*pow(2,(_zoom_level -1)))+( longitude *((256*pow(2,_zoom_level ))/360)) ) <map_size_x AND max((256*pow(2,(_zoom_level-1)))+((0.5*log((1+(sin((latitude)*pi()/180)))/(1-(sin((latitude)*pi()/180)))))*((-256*pow(2,_zoom_level))/(2*pi()))))-min((256*pow(2,(_zoom_level-1)))+((0.5*log((1+(sin((latitude)*pi()/180)))/(1-(sin((latitude)*pi()/180)))))*((-256*pow(2,_zoom_level))/(2*pi()))))<map_size_y,_zoom_level,1),_zoom_level))';

var_maptype= '=if(isnull(only(maptype)),fieldvalue( '&chr(39)&'maptype'&chr(39)&', 1 ),maptype)';

map_size_x=	'400';
map_size_y=	'400';

Thanks & Regards

Vimlesh Gupta

Re: Problem in Google Map With Qlikview

Wed, 26 Mar 2014 05:29:19 GMT

Vimlesh,

Im also working on google map its working fine with my app but not showing on access point or "Open in server" .

Map not showing on AccessPoint

But you are addressing a different thread can you share your app?

is your Latitude and longitude is correct for Bhopal and Jaipur?

Re: Problem in Google Map With Qlikview

Wed, 26 Mar 2014 05:42:05 GMT

Dear adeel,

if MAP is not working in your access point check your internet connection.

due to internet it happens some time.

Thanks & Regards

Vimlesh gupta

Re: Problem in Google Map With Qlikview

Wed, 26 Mar 2014 05:51:12 GMT

vimlesh i don't think so it a internet connection issue it is also not working via "open in server"

Re: Re: Problem in Google Map With Qlikview

Wed, 26 Mar 2014 07:13:38 GMT

Hi,

I am uploading test Application, here i took agents of bhopal,indore and jaipur.

but it showing in another location and when i click at single agent position

then the location is being changed on every click at position in map.

Find attached Qvw file.

Thanks & Regards

Vimlesh Gupta

Re: Re: Re: Problem in Google Map With Qlikview

Wed, 26 Mar 2014 07:19:42 GMT

Hi ,

try this may be it will helpful

Re: Re: Problem in Google Map With Qlikview

Wed, 26 Mar 2014 07:34:47 GMT

Dear Kannuri,

I checked this app ,same problem exits.

if you want to check then click at Calcutta city it showing in Chhattisgarh.

I checked most of the app available in Community.

Thanks & Regards

Vimlesh Gupta

Re: Problem in Google Map With Qlikview

Anonymous — Tue, 02 Jun 2015 02:08:32 GMT

Vimlesh, Did u able to solve it? If yes, Can I know how?