Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikviewwizard
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
14 Replies
qlikviewwizard
Master II
Master II
Author

Hi All, Please help me.

Kushal_Chawda

Do you have lattitude and longitude?

qlikviewwizard
Master II
Master II
Author

No. Thank you.

jonathandienst
Partner - Champion III
Partner - Champion III

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
qlikviewwizard
Master II
Master II
Author

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

daniel_kusiak
Creator II
Creator II

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.

jonathandienst
Partner - Champion III
Partner - Champion III

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
jagan
Luminary Alumni
Luminary Alumni

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.

qlikviewwizard
Master II
Master II
Author

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

];