Locations on the map

[qlikviewwizard]

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

];

[qlikviewwizard]

Hi All, Please help me.

[Kushal_Chawda]

Do you have lattitude and longitude?

[qlikviewwizard]

No. Thank you.

[jonathandienst]

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.

[qlikviewwizard]

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

[daniel_kusiak]

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]

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.

[jagan]

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]

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

];