topic Re: US Map in geospatial view using scatter in QlikView

US Map in geospatial view using scatter

Fri, 17 Jul 2015 12:02:17 GMT

Hi,

I am trying to show US map using scatter plot and dynamic image as background with latitude and longitude of each city, but it's not coming up as expected. Please help.

Regards,

Navdeep

Re: US Map in geospatial view using scatter

stigchel — Fri, 17 Jul 2015 12:27:07 GMT

The minus sign in your longitude numbers got lost, fix that in your load or replace longitude with -longitude everywhere

e.g.

var_mid_long=min(-longitude)+(max(-longitude)-min(-longitude))/2

Re: US Map in geospatial view using scatter

Fri, 17 Jul 2015 12:34:34 GMT

Hey, Could you explain what you meant by negative sign or please share if you have done something like this, because I am not very much clear about this piece of code.

Regards,

Navdeep

Re: US Map in geospatial view using scatter

stigchel — Fri, 17 Jul 2015 12:43:25 GMT

The longitude numbers are wrong in your data, take e.g. New York, they should be 40.77,-73.98 instead as below from your load

join(Georaphy)

load * inline

[

City,State,latitude,longitude

...

New York,NY,40.77,73.98

Re: US Map in geospatial view using scatter

stigchel — Fri, 17 Jul 2015 12:54:00 GMT

You can e.g. do the following to correct, also see attached

join(Georaphy)

load City,State,latitude,-longitude as longitude;

load * inline

[

City,State,latitude,longitude

Re: US Map in geospatial view using scatter

Fri, 17 Jul 2015 13:01:25 GMT

Thanks, got your point.