Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
(
p.s ive posted this into the geoqlik_map place but unsure if anyone will see it there
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
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"
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".
Steps for beginners to implement Google Maps in Qlikview
you follow the above like you may be get map
Hello,
Make sure you have spatial objects database mapped into your model.
Something like postgis.
Regards,
João Duarte
// 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
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