Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

map in qlikview

Hi, I want a india map in my application , I want to view the sale in different city on mouse over event on map , how can i do this ,

14 Replies
Not applicable

map in qlikview

You should use the Google maps exampe of QV to show your data on a Google Map. I believe this can be found on the demo site. Furthermore, you require the Geocode of your customers if you want to show their turnover on your map and a Google Maps API key, which you can obtain for free from Google. There are some restrictions though but these restrictions will be explained to you when apply for the key.

Good luck.

Not applicable

map in qlikview

Can u please explain in detail the steps required to achieve this

raghavsurya
Valued Contributor

map in qlikview

Hi,

There is a standard google map API which u need to upload as a script, then identify the Longitude and latitude of the city you want to show in the map and link this data with your sales.

I have achieved in showing Sales using India map for one of my clients by following the same steps.

Regards,

Raghav

Not applicable

map in qlikview

Hi,

Can u please tell me the script for the google map API.

I have the latitude and logitude of the cities required.

raghavsurya
Valued Contributor

map in qlikview

Hi,

find below the api...... Just put it in the script window and upload the sales detials linked with longitude and latitude of cities Smiley Happy

// 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 = '123';
max_zoom_level = 17; //maximum value 17

// 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= '620';
map_size_y= '500';

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
];

Not applicable

map in qlikview

Hi,

If you want you could try out Idevio Maps as an alternative to Google Maps, it's a faster, more interactive way to use maps within Qlikview. Main benefits are:

  • Fast map with dynamic zoom and pan.
  • Client side rendering, handles thousands of objects with ease.
  • Plug and play, easy to setup and configure.
  • Extendable, the extension serves as a starting point.
  • World coverage, street level for many areas.
  • Secure, own hosting possible.

Idevio Maps are available to Qlikview 10 as an extension object.

Visit www.idevio.com/demo for more info and demo (logon on with demo demo).

business_geogra
New Contributor III

map in qlikview

Hi,

In order to display interactive maps into a QlikView document, we do provide a solution called GeoQlik for QlikView.

The main GeoQlik’s assets are:

- Integration into a QlikView document which allows you to select directly on the map
- Possibility to load your own geografic data
- Perform spatial analysis by tinging areas
- Make pie charts and bar charts
- Works offline
- Easy to use

To access GeoQlik online demo:

http://qonnections.geoqlik.com

If you want to know more about GeoQlik, please do not hesitate to register to webinars:
http://www.geoqlik.com

If you want to know more about GeoQlik v.10, you can register to webinars dedicated to this new version, following this link :

http://www.geoqlik.com/index.php?option=com_content&task=blogsection&id=9&Itemid=58

Not applicable

map in qlikview

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

maptype:

what is the idle range that we can use for HIDEPREFIX??

My zoom is not working properly i guess its due to this. bubbles concentrating in one area are stacking and not all of them are visible. do we have any solution for this?

sach_sahu1
New Contributor III

map in qlikview

Hello Friends

can Anyone Help me how to find longitudes and latitudes and place it over Google maps as im new to Qlikview World

Thanks in advance