topic Re: Locations on the map in QlikView

Locations on the map

qlikviewwizard — Tue, 04 Aug 2015 01:48:16 GMT

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

];

Re: Locations on the map

qlikviewwizard — Wed, 05 Aug 2015 13:59:24 GMT

Hi All, Please help me.

Re: Locations on the map

Kushal_Chawda — Wed, 05 Aug 2015 14:05:27 GMT

Do you have lattitude and longitude?

Re: Locations on the map

qlikviewwizard — Wed, 05 Aug 2015 14:19:02 GMT

No. Thank you.

Re: Locations on the map

jonathandienst — Wed, 05 Aug 2015 14:26:00 GMT

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.

Re: Locations on the map

qlikviewwizard — Wed, 05 Aug 2015 14:37:21 GMT

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

Re: Locations on the map

daniel_kusiak — Wed, 05 Aug 2015 14:47:40 GMT

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.

Re: Locations on the map

jonathandienst — Wed, 05 Aug 2015 14:51:16 GMT

Create an inline table:

Locations:

LOAD * INLINE

[

LOC, Latitude, Longitude

NEW YORK, 123456.789012, -9876543.21098

DALLAS, 23456.789012, 9876543.21098

];

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.

Re: Locations on the map

jagan — Wed, 05 Aug 2015 15:12:28 GMT

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.

Re: Locations on the map

qlikviewwizard — Thu, 06 Aug 2015 01:56:47 GMT

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

];

Re: Locations on the map

qlikviewwizard — Thu, 06 Aug 2015 01:59:02 GMT

Hi All,

Please find the application.

Re: Locations on the map

jagan — Thu, 06 Aug 2015 02:46:52 GMT

Hi,

Please find attached file for solution.

Regards,

Jagan.

Re: Locations on the map

jagan — Thu, 06 Aug 2015 02:47:20 GMT

Used below link to create this file

Steps for beginners to implement Google Maps in Qlikview

Re: Locations on the map

jagan — Thu, 06 Aug 2015 02:48:03 GMT

Also check this link, it helps you in implementing various maps

Google MAPs related APPs

Regards,

Jagan.

Re: Locations on the map

qlikviewwizard — Thu, 06 Aug 2015 03:04:11 GMT

Thank you All