topic Re: google maps in Qlikview not so simple in QlikView

google maps in Qlikview not so simple

Anonymous — Thu, 15 Sep 2011 09:16:46 GMT

Hi Guys,

i'm still new to qlikview

I went tru this tutorails to learn how to add google maps in a qlikview document. However it is not as simple as I thought it would be

I've created a new Qlikview file and copied the map chart to my new qlikview file. However I get the error message no data to display. It can be the internet settings because I connect directly to the internet without a proxy/firewall.

The tutorails load country's as:

Country:

Albania,

Algeria,

Argentina,

Armenia,

Australia,

Austria,

Azerbaijan,

Bahrain,

Suppose I want to load one country for example The Netherlands and zoom in till postcode level. What steps do I need to take to acieve is? I have a Excel list with all the postcode and want to link them to (the google) map, and calculate for example profit per city. Just don't know where to start. execpt trying to understand how to add the google map, that's hopefully a good step.

I've add both the 'google tutorial' and my 'practice sheet'

Hope u can help!

Thanks in advance!

iSam

google maps in Qlikview not so simple

Thu, 15 Sep 2011 19:01:06 GMT

in the GoogleTest app I have seen 2 issues

1) change the SET DecimalSep=','; in SET DecimalSep='.';

2) go to property/colors panel then set Transparency to 0%

It works !

To answer to you question how to display data on map you need 2 things :

- coordinate longitude / latitude for each location

- a value for each location

I suspect you lack the coordinate ? If you send me a sample of your address or postcode I can build an app with a geocoder before mapping.

Regards

google maps in Qlikview not so simple

Thu, 15 Sep 2011 21:14:39 GMT

This part of the code shows the data you need to make it work:

// Variables required for calculating map
// make sure your code assigns a long and a lat to "longitude" and "latitude" or it won't work

var_pi180= '=pi()/180';
var_lat_offset= '0';
var_mc2= '=256*pow(2,$(var_zoom))';
var_mc1= '=256*pow(2,($(var_zoom)-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= '640';
map_size_y= '400';

SET HidePrefix='_' ;
// Field required for calcualting best zoom level
_zoom_level:
Load RecNo( ) as _zoom_level autogenerate(max_zoom_level);

maptype:
LOAD * INLINE [
maptype
roadmap
mobile
satellite
terrain
hybrid
];

If you have the long and the lat and have named them properly then this is basically plug and play. However, without a valid long and lat the code will do nothing.

google maps in Qlikview not so simple

rotero — Fri, 16 Sep 2011 08:54:49 GMT

im really interested in using google map to make a visual representation for sales data..

is there anyone here have a referal for tutotial?i cant open other QVW file because im using Personal Ed .

Hope u could extend to us newbhie your generosity..

TIA..

Re: google maps in Qlikview not so simple

Anonymous — Fri, 16 Sep 2011 09:15:28 GMT

Hi JJ,

Thanks for your support!!! I really appreciate it

I adjusted the SET DecimalSep='.', and changed the transparency to 0% as you said. However I still get the error ‘no data to display’

I found an Excel sheet with all the coordinates of all the cities in the Netherlands. I’ve loaded that excel file in to qlikview, but shouldn’t there be a link between the to “tables” or between google maps and my excel sheet?

I’ve attached my qlikview file. As you can see the decimal is now ‘.’ And transparency is 0%.

If my file work on your computer that would mean that something is blocking qlikview to access the google maps.

Thanks so far all u’r help!

Cheers!

isam

Re: google maps in Qlikview not so simple

Anonymous — Fri, 16 Sep 2011 09:35:47 GMT

Hi,

I did a quick scan onyour QV file and find 3 things you need to adjust:

First, you are missing the variable : var_zoom

As you can see in your expression you need this.

Second, your dimension is Country, you don't have that field. Change it to City.

Third, in your expressions you use the field names longitude and latitude, but your fields are called Longitude and Latitude (with a capital)

Hope this helps. Good luck.

Dennis.

Re: google maps in Qlikview not so simple

Anonymous — Fri, 16 Sep 2011 09:55:51 GMT

Hi Dennis,

Thanks for your help!! I didn’t send the right Qlikview file. And indeed if you don’t have the right dimensions then you of course you can’t get any data.

Qlikview now loads the worldmap, I “only” need to figure out how to get the coordinates right. Can it be that my coordinates from Excel are not correct with the one from google?

Thanks in advance!

Cheers!

iSam

google maps in Qlikview not so simple

Anonymous — Fri, 16 Sep 2011 10:29:02 GMT

Your gmap_key is empty.

What you need to do is get a Google Maps code

You can do that here: http://code.google.com/apis/maps/signup.html

Look for : gmap_key = 'xx'; in your script and fill in the Google maps code between the qoutes.

Let me know if this gets you any futher ok?

Dennis.

Re: google maps in Qlikview not so simple

Anonymous — Mon, 19 Sep 2011 10:13:53 GMT

Hi Guys,

I think I found the problem. Just can’t solve it L. It seems to me that there’s something wrong with the longtitude and langtitude. When I load my excel file with all the longtitude and langtitude data, Qlikview interpetes it as a text. I therefore changed it so it would match with the google map format.

num(Latitude, '##############', '.', ',' ) as Lat,

num(Longitude, '##############', '.', ',' ) as Lng,

Based on the above expression I get the results below:

Normally it should be something like this ( six numbers after the decimal):

The other challenge is that I can’t get The Netherlands as default map.

I tried Replacing ='http://maps.google.com/staticmap?center=' with “=http://maps.google.com/maps/api/staticmap?center=holland,holland&zoom=8&size=640x640&maptype=roadmap&sensor=false” but that doesn’t work.

My last question: Why is it that when adding a dimension to my map it appears to the right and when I do this in the googleTutorial map it does not (something I want).

Hope u can help me out.

Cheers

iSam

Re: google maps in Qlikview not so simple

Mon, 19 Sep 2011 22:04:18 GMT

Hi Sam,

I checked out your map and there are a couple of things you need to know:

1. You didnt change the variables lat and lng in every place, you missed the important part that was the background image. In the properties panel/Colors there's the dynamic image field, here you need to change the variables too.

2. To get rid of the dimension labels, just uncheck the show legend option on the Dimensions tab.

Here's your file corrected, I usually dont rename the latitude and longitude variables, i leave them just as they are so i can copy and paste the tutorial's example without changing anything. I just adjust the color and size expressions to fit my needs.

Hope this helps

Best regards

Re: google maps in Qlikview not so simple

Anonymous — Tue, 20 Sep 2011 07:54:21 GMT

Hi Martha,

THANK YOU very much for your help!!! It was in deed the variabrales that needed to be changed in order to get it right.

I am curious why you decided to drop the table ?

muchas gracias

iSam

Re: google maps in Qlikview not so simple

Anonymous — Wed, 21 Sep 2011 11:12:07 GMT

Hi Dennis,

I now have the qlikview map working with the map of the Netherlands. When I view my qlikview file via the web, the map disappears.

Is it because I don’t have a premium version of google maps or is it because I’m behind a proxy server?

Hope u can help me out.

Cheers

iSam

Re: google maps in Qlikview not so simple

Wed, 21 Sep 2011 13:53:29 GMT

Hi Sam,

I wanted to reload the document so i had to make a copy of it and load the tables from the binary file. I changed your variable names from Lng to longitude and Lat to latitude so I wouldnt have to change all of the map. But you already had defined this names in the table that worked so I decided to drop it to prevent duplicates.

Glad it helped.

Regards

Re: google maps in Qlikview not so simple

Anonymous — Wed, 21 Sep 2011 13:54:28 GMT

No thank u. May in a later stage.

Re: google maps in Qlikview not so simple

Anonymous — Wed, 21 Sep 2011 14:08:17 GMT

Ola Martha,

Thanks for your replay. Do you have experience with a static map? I can’t get the bubble and cities to match:

http://community.qlik.com/message/151312#151312

Cheers!

iSam

Re: google maps in Qlikview not so simple

rotero — Thu, 22 Sep 2011 05:11:00 GMT

is there a tutorial there how to use it along withg QV10 (personal editon).. i really interested...

FYI: our company is now talking to the vendor and actually using it in our own data source just to play around and i found it very interesting... this map with visual representation of sales is a big help to make my boss agreed to buy this software... hope you could help me..

TIA

Re: google maps in Qlikview not so simple

Anonymous — Thu, 22 Sep 2011 06:39:10 GMT

Hi,

Attached is a tutorial how to add the google map. I don’t know if this will work on the personal edition. If it does work, make sure that you have a gmap_key (http://code.google.com/apis/maps/signup.html ). If you live in Europa you may need to change the decimalset from: SET DecimalSep=',';

To SET DecimalSep='.';

Last but not least make sure you have latitude and longitude data of your country or city you want to show data from.

Hope this helps

Regards,

isam

google maps in Qlikview not so simple

Anonymous — Wed, 28 Sep 2011 08:06:06 GMT

Hi Guys,

I'm trying to find out why Google Maps is not appearing in Qlikview Publisher via Internet Explorer. Could it be that it has something to do with these settings below?

Qlikview Management Console

Qlikview Server AccessPoint

Qlikview SDK

Default License Lease Server

Publisher Autorisation Table

These settings are empty. I don't know if that's correct.

Hope someone can help!

Cheers!

iSam

google maps in Qlikview not so simple

Eugeny_Ilyin — Wed, 30 Nov 2011 14:40:01 GMT

Hi all.

How to make a Google map in other language?

Best regards,

Eugeny

Re: google maps in Qlikview not so simple

Anonymous — Tue, 06 Dec 2011 08:19:30 GMT

I think there’s only one version of google maps, it may depen on the language you have.