topic Re: geoqlik map in QlikView

geoqlik map

samuel_brierley — Thu, 09 Jan 2014 15:24:10 GMT

Hi ive just downloaded the geoqlik extension but i have absolutley no clue what to do with it.

My data gives location in lats and longs, im assuming there has to be some coding written into the load script but i havent got a clue.

any help?

LOAD
     [Category Name],
     [Type Name],
     [RCC No],
     [Contract Name],
     [Motorway Ref],
     [Geog Address],
     [Asset Status Abbr],
     Longitude,
     Latitude
FROM

(ooxml, embedded labels, table is Sheet1);

p.s ive posted this into the geoqlik_map place but unsure if anyone will see it there

Re: geoqlik map

sspe — Fri, 10 Jan 2014 08:40:30 GMT

Hi,

You can try to take a look at this document to see if that helps you - http://demo.geoqlik.com/geoqlik/ressources/htdocs/docs/GeoQlik_Trial_EN.pdf

Regards

Steen

Re: geoqlik map

Josh_Good — Fri, 10 Jan 2014 21:24:36 GMT

If you are using QlikView 11.2 SR5 (if not you can download it), there is also a mapping extension included with the product. On the "Start Page", select "Getting Started" on the left and then scroll down to the "Extension Examples"

Re: geoqlik map

jim_chan — Thu, 28 Jan 2016 10:00:04 GMT

I have downloaded the Geoqlik trial, and followed the guide to create an expression. even though i have added the expression/analysis. the map didnt change anytime, there' no response even if i have click "alabama".

Re: geoqlik map

Anonymous — Thu, 28 Jan 2016 10:08:38 GMT

Steps for beginners to implement Google Maps in Qlikview

you follow the above like you may be get map

Re: geoqlik map

jduarte12 — Thu, 28 Jan 2016 10:35:47 GMT

Hello,

Make sure you have spatial objects database mapped into your model.

Something like postgis.

Regards,

João Duarte

Re: geoqlik map

Anonymous — Thu, 28 Jan 2016 10:43:18 GMT

// Google Maps in QlikView
// V0.85.2 - October 1st 2008 © Copyright QlikTech International AB 2008 / AES

// Google Maps Key
// get a key here http://code.google.com/apis/maps/signup.html
gmap_key = AIzaSyDwkAT_Er3AXVFuX_1GS2PvFlupYu3qQe4;
max_zoom_level = 16; //Max value is 17
//def_zoom_level = 1;
//def_map_size = 400;

// Variables required for calculating map
// No need to change these
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);

In 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
&
'&key='&gmap_key & '&sensor=false'

latitude:

=sum(
((256*pow(2,($(var_zoom)-1)))+((0.5*log((1+(sin((latitude)*pi()/180)))/(1-(sin((latitude)*pi()/180)))))*((-256*pow(2,$(var_zoom)))/(2*pi()))))

)

Longtitude:

=sum( round (256*pow(2,($(var_zoom)-1)))+( longitude *((256*pow(2,$(var_zoom)))/360)) )

For x

Min

(256*pow(2,($(var_zoom)-1)))+( var_mid_long *((256*pow(2,$(var_zoom)))/360)) -round(map_size_x/2)

Max

( (256*pow(2,($(var_zoom)-1)))+( var_mid_long *((256*pow(2,$(var_zoom)))/360)) + round(map_size_x/2)-15)

For y

Min

=((256*pow(2,($(var_zoom)-1)))+((0.5*log((1+(sin(var_mid_lat*pi()/180)))/(1-(sin(var_mid_lat*pi()/180)))))*((-256*pow(2,$(var_zoom)))/(2*pi())))+round(map_size_y/2))

Max

=((256*pow(2,($(var_zoom)-1)))+((0.5*log((1+(sin(var_mid_lat*pi()/180)))/(1-(sin(var_mid_lat*pi()/180)))))*((-256*pow(2,$(var_zoom)))/(2*pi())))-round(map_size_y/2)+15)

I think the above code is use for map

Re: geoqlik map

Fri, 29 Jan 2016 08:21:16 GMT

Dear Jim,

As answered in other messages, please do contact us (contact@geoqlik.com) so that we can assist you using our Trial or even set you up with a Test licence so that you can try GeoQlik with your own data.

kind regards,

Cyril