geoqlik map

[samuel_brierley]

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

[sspe]

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

[Josh_Good]

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"

[jim_chan]

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".

[Anonymous]

Steps for beginners to implement Google Maps in Qlikview

you follow the above like you may be get map

[jduarte12]

Hello,

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

Something like postgis.

Regards,

João Duarte

[Anonymous]

// 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

[#8]

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