Geographical map in Qlikview Personal Edition

[Anonymous]

Could anyone provide the link for step by step implementation of Geo map in Qlikview personal edition.

I have tried few guides however it did not work.

Regards

Shashikant

[Anonymous]

Same situation here...

2 or 3 days of researches and attempts - no results.

Downloaded extensions, trying with scripts too and there are errors.

Tried this - Steps for beginners to implement Google Maps in Qlikview

again no results because it is giving me errors on step: 1.2 Load the Google map data.

Kind regards

[Anonymous]

try Qlik Sense Desktop, it supports basis map features...

[Frank_Hartmann]

try using this expression for dynamic image:

='http://maps.google.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'

hope this helps!

[Anonymous]

Hey,

Thank you for the help, but something its wrong again..

I`m attaching a file. Could you take a look?

Kind Regards,
Ivan.

[Frank_Hartmann]

If you use F1 as the field for City then it works 🙂

[Frank_Hartmann]

or you will need to rename the F1 Field in script like this:

LOAD Месец,

     Седмица,

     [Кантора Продавач],

     [Консултант Продавач],

     [Източник Продавач],

     [описание източник продавач],

     [Мотиви за продажба],

     [От колко време продава /бр. дни/],

     [Брой огледи - продавач],

     [Тип имот],

     Квартал,

     [Вид строителство],

     [Година на строителство],

     [Площ кв,м,],

     [Цена на сделката],

     [Кантора Купувач],

     [Консултант Купувач],

     [Източник Купувач],

     [описание източник Купувач],

     [Мотиви за покупка],

     [От колко време купува /бр.дни/],

     [Брой огледи - купувач],

     [Финансиране - купувач],

     Град,

     Година,

     [Точен адрес]

FROM

(ooxml, embedded labels, table is Продажби);

LOAD F1 as Град,

     Latitude,

     Longitude

FROM

(ooxml, embedded labels, table is [L L]);

then the typeofhouse field should also be working 🙂

[Anonymous]

Yes, it really works with F1! Thank you very much!

But why there aren't any markers? Did i missed any step before?

Also, if i have the exact address of a property should i find Latitude and Longitude of every single property?

And if its like this how i could do it for more then 5000 This will take years haha

[Anonymous]

https://youtu.be/jQm0NEFyszI?list=PLXSf7wvDdCkXjNu-r_9N-Wnz8urCOGK3C

This is the final result i want to accomplish.

[Frank_Hartmann]

yes, you will have to find all the lats and longs for all the properties.

this might be helpful but it will be a lot of work to do 🙂

Latitude and Longitude Finder on Map Get Coordinates