topic My Google Map is too static in QlikView

My Google Map is too static

domiho123 — Tue, 20 Mar 2012 07:48:32 GMT

Hi all,

I am fresh at QlikView. I have followed the Designer Course last week and would like to build an application that integrates Google Maps. After browsing through different posts and in different example files, I still cannot have my copy work. I have attached my example, build in a personal edition however. Can anyone point out what is wrong with my file?

Thanks in advance!

My Google Map is too static

erichshiino — Tue, 20 Mar 2012 19:04:10 GMT

Hi, Dominique.

Since you are using personal edition, I will not post your example back, but please, check the number format of your 'Longitude'.

You can try this:create a new table box and include the fields: Inwoners, Latitude and Longitude.

You will see that the field Longitude was not recognized as a number, but as a text due to the dot as the separator.

You can try to fix it at the souce, or use num# to force the interpretation of your number. using num#() function:

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

Your load script would look like this (more or less) :

LOAD Plaats,

Startlocatie?,

Inwoners,

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

Latitude,

Jaar,

Maand,

Seizoen

FROM

Vakantiebestemmingen.xls

(biff, embedded labels, table is Vakantieplaatsen$);

Hope this helps,

Erich

My Google Map is too static

Anonymous — Thu, 22 Mar 2012 16:12:41 GMT

Hi Dominique

Erich is right it has something to do with the number format.
As you can see in your data, your Latitude has comma's and your Longitude has dots.

If Enrich's solution is not working try to play around with the following in your load script:

Replace(Latitude , ',' , '.' ) as Latitude,

Replace(Longitude , ',' , '.' ) as Longitude

This will replace the comma's for dots.

Or the other way around (depending on your settings):

Replace(Latitude , '.' , ',' ) as Latitude,

Replace(Longitude , '.' , ',' ) as Longitude

Mocht het niet lukken laat het dan even weten.

Succes.

Dennis.

My Google Map is too static

domiho123 — Thu, 22 Mar 2012 16:26:41 GMT

Guys,

Thanks for your input. It is working now. The problem was indeed related to . and , and on top the coordinates were not translated correctly.

Regards,

Dominique.