Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
shashi1436
Contributor
Contributor

Geographical map in Qlikview Personal Edition

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

11 Replies
ronaldoc
Contributor II
Contributor II

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
Not applicable

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

Frank_Hartmann
Master II
Master II

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'

Aufnahme_2017_06_21_21_52_54_905.gif

hope this helps!

ronaldoc
Contributor II
Contributor II

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
Master II
Master II

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

Unbenannt.png

Frank_Hartmann
Master II
Master II

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 🙂

ronaldoc
Contributor II
Contributor II

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

ronaldoc
Contributor II
Contributor II

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

This is the final result i want to accomplish.

Frank_Hartmann
Master II
Master II

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