topic Geographical map in Qlikview Personal Edition in QlikView

Geographical map in Qlikview Personal Edition

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Geographical map in Qlikview Personal Edition

Anonymous — Wed, 21 Jun 2017 14:12:55 GMT

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

Re: Geographical map in Qlikview Personal Edition

Anonymous — Wed, 21 Jun 2017 17:13:25 GMT

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

Re: Geographical map in Qlikview Personal Edition

Frank_Hartmann — Wed, 21 Jun 2017 19:55:26 GMT

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!

Re: Geographical map in Qlikview Personal Edition

Anonymous — Thu, 22 Jun 2017 11:00:38 GMT

Hey,

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

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

Kind Regards,
Ivan.

Re: Geographical map in Qlikview Personal Edition

Frank_Hartmann — Thu, 22 Jun 2017 13:36:48 GMT

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

Re: Geographical map in Qlikview Personal Edition

Frank_Hartmann — Thu, 22 Jun 2017 13:40:39 GMT

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 🙂

Re: Geographical map in Qlikview Personal Edition

Anonymous — Thu, 22 Jun 2017 17:18:17 GMT

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

Re: Geographical map in Qlikview Personal Edition

Anonymous — Thu, 22 Jun 2017 17:31:44 GMT

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

This is the final result i want to accomplish.

Re: Geographical map in Qlikview Personal Edition

Frank_Hartmann — Thu, 22 Jun 2017 18:19:37 GMT

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

Re: Geographical map in Qlikview Personal Edition

Anonymous — Thu, 22 Jun 2017 19:23:36 GMT

I found this - https://www.doogal.co.uk/BatchGeocoding.php

It's geocoding multiple addresses.

Still no showed markers, although i clicked to show them

Re: Geographical map in Qlikview Personal Edition

Frank_Hartmann — Fri, 23 Jun 2017 06:01:10 GMT

the markers will appear if you connect your "lat,long,city" table by a common field name (city)

with your e.g. "sales" table (e.g. with fields: city, sales, salesperson,.......). then you need to setup the bubble expression like this: sum(sales)

this should be enough to see the bubbles: