Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

bars in Map

Is it possible to chart down little bars on graph instead of Dots?

I tried changing formulae in script, but i messed it up..

// Google Maps in QlikView
// V0.9 - 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 = '    mmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmm';
max_zoom_level = 20; //maximum value 17

// Variables required for calculating map
// No need to change these
var_pi180=  '=pi()/180';
var_lat_offset= '0';
var_log_offset= '0';
var_mc2=  '=256*pow(2,$(var_zoom))';
var_mc1=  '=256*pow(2,($(var_zoom)-1))';
var_mid_lat= '=min(lat)+(1+var_lat_offset)*((max(lat)-min(lat))/2)';
var_mid_long= '=min(lng)+(max(lng)-min(lng))/2';
var_zoom=  '=max(aggr(if(max( round(256*pow(2,(_zoom_level -1)))+( lng *((256*pow(2,_zoom_level ))/360)) )-min( round(256*pow(2,(_zoom_level -1)))+( lng  *((256*pow(2,_zoom_level ))/360)) ) <map_size_x AND max((256*pow(2,(_zoom_level-1)))+((0.5*log((1+(sin((lat)*pi()/180)))/(1-(sin((lat)*pi()/180)))))*((-256*pow(2,_zoom_level))/(2*pi()))))-min((256*pow(2,(_zoom_level-1)))+((0.5*log((1+(sin((lat)*pi()/180)))/(1-(sin((lat)*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=     '396';
map_size_y=     '240';

SET HidePrefix='_' ;
// Field required for calcualting best zoom level
_zoom_level:
Load RecNo( ) as _zoom_level autogenerate(max_zoom_level);

maptype:
LOAD * INLINE [
    maptype
    roadmap
    mobile
satellite
terrain
hybrid
];

Labels (1)
0 Replies