Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

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
Author

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

raghavsurya
Partner - Specialist
Partner - Specialist

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
Author

Hi,

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

I have the latitude and logitude of the cities required.

raghavsurya
Partner - Specialist
Partner - Specialist

Hi,

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

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

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

Anonymous
Not applicable
Author

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
Author

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?

Anonymous
Not applicable
Author

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