Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Master II
Master II

Locations on the map

Hi All,

I have two tables EMP and DEPT. Employees are belongs to the NEW YORK,DALLAS,CHICAGO,BOSTON areas.

I want to show a google map like this:

Employees need to be shown on google map respective location and his\her Sal.

Kindly help me.

EMP:

LOAD * INLINE [

EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO

7369,SMITH,CLERK,7902,17-Dec-1980,800,NULL,20

7499,ALLEN,SALESMAN,7698,20-Feb-1981,1600,300,30

7521,WARD,SALESMAN,7698,22-Feb-1981,1250,500,30

7566,JONES,MANAGER,7839,02-Apr-1981,2975,NULL,20

7654,MARTIN,SALESMAN,7698,28-Sep-1981,1250,1400,30

7698,BLAKE,MANAGER,7839,01-May-1981,2850,NULL,30

7782,CLARK,MANAGER,7839,09-Jun-1981,2450,NULL,10

7788,SCOTT,ANALYST,7566,09-Dec-1982,3000,NULL,20

7839,KING,PRESIDENT,NULL,17-Nov-1981,5000,NULL,10

7844,TURNER,SALESMAN,7698,08-Sep-1981,1500,0,30

7876,ADAMS,CLERK,7788,12-Jan-1983,1100,NULL,20

7900,JAMES,CLERK,7698,03-Dec-1981,950,NULL,30

7902,FORD,ANALYST,7566,03-Dec-1981,3000,NULL,20

7934,MILLER,CLERK,7782,23-Jan-1982,1300,NULL,10

];

LOAD * INLINE [

DEPTNO,DNAME,LOC

10,ACCOUNTING,NEW YORK

20,RESEARCH,DALLAS

30,SALES,CHICAGO

40,OPERATIONS,BOSTON

];

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

Re: Locations on the map

14 Replies
Highlighted
Master II
Master II

Re: Locations on the map

Hi All, Please help me.

Highlighted
MVP
MVP

Re: Locations on the map

Do you have lattitude and longitude?

Highlighted
Master II
Master II

Re: Locations on the map

No. Thank you.

Highlighted
MVP
MVP

Re: Locations on the map

Well you need to supply the map coordinates to overlay this data on a map. Google city coordinates and create a table containing LOC, latitude and longitude which you can join to your second inline table.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Highlighted
Master II
Master II

Re: Locations on the map

LOC means Location. I am very new to this. Please help me. Thank you.

Highlighted
Creator II
Creator II

Re: Locations on the map

For every LOC you have to have latitude and longitude so it can be put on the map. For NY it is 40.7127840 -74.0059410 (you can use google for that).


I've used this guide for maps Step-by-Step Google Map API v3 integration.

It worked for me.

Highlighted
MVP
MVP

Re: Locations on the map

Create an inline table:

Locations:

LOAD * INLINE

[

  LOC, Latitude, Longitude

  NEW YORK, 123456.789012, -9876543.21098

  DALLAS, 23456.789012, 9876543.21098

  <and so on for other locations>

];

Then replace the numbers with the actual latitude and longitude. You will have to look this up yourself.

Is this your first model? I would consider dynamic mapping to be a rather advanced topic and you might be better off with simpler models until you have a firmer understanding.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Highlighted
MVP & Luminary
MVP & Luminary

Re: Locations on the map

Hi, 

To plot values on map you need location details like Latitude and Longitude, with out this it is not possible and no meaning in using the maps.

Regards,

Jagan.

Highlighted
Master II
Master II

Re: Locations on the map

Please find the LOC details.


LOCATIONS:

LOAD * INLINE [

LOC,LATITUDE,LONGITUDE,SEA LEVEL

NEW YORK,40.80549384,-73.59809875,77 m

DALLAS,32.7766642,-96.7969879,138 m

CHICAGO,41.8781136,-87.6297982,181 m

BOSTON,42.3600825,-71.0588801,10 m

];