topic Re: GeoSpatial Solutions for Qlikview in QlikView

GeoSpatial Solutions for Qlikview

Wed, 16 Apr 2014 01:56:03 GMT

Hi, We are looking for a best solution for geospatials in qlikview. I know there is something called GeoQlik. Are there any other good options? Please let me know.

Thanks,

Ram

Re: GeoSpatial Solutions for Qlikview

fkeuroglian — Wed, 16 Apr 2014 02:37:07 GMT

Hi, you could use a Google api , it is very easy to integrate(one differences with geoqlik is that is free)

I attached a doc to explain and a qvw example

good luck

Fernando

Re: GeoSpatial Solutions for Qlikview

Wed, 16 Apr 2014 03:46:47 GMT

Hi Fernando, I followed the exact steps but don't get to see the map. I already have the latitude and longitude in my qlikview data model. How do I use it. If you can provide that step that'll be useful. The field names are called WorkLat and WorkLong. What is the statement that associates these fields with google maps?

Re: Re: GeoSpatial Solutions for Qlikview

Wed, 16 Apr 2014 03:59:37 GMT

Hi.. Ramkumar

Can you please attach your file.

Re: GeoSpatial Solutions for Qlikview

Wed, 16 Apr 2014 04:07:24 GMT

No Senthil. I cannot copy, the file is in a production box. I'll explain you what is happening. I have the PostCode(Postal Code) that is already part of the model. I have an excel file containing the latitutde and longitudes of these postal codes. I brought them in and joined with the data model as follows:

WorkPostCodeData:

load PCode as [PostCode], Lat * pi() / 180 as WorkLat, Long * pi() /180 as WorkLong

from

pc_full_lat_long.csv

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

Once I did this I was able to do the distance analysis perfectly using the Haversine method. All I now want is the GeoSpatials, plot the numbers on the map.

Re: GeoSpatial Solutions for Qlikview

Wed, 16 Apr 2014 05:35:54 GMT

Is this just a problem with my background dynamic image?

Re: GeoSpatial Solutions for Qlikview

Wed, 16 Apr 2014 05:40:59 GMT

Hi.. Can you try the below code for Dynamic Image

='http://maps.google.com/maps/api/staticmap?center='

num(var_mid_lat, '##############', '.', ',' )

','

num(var_mid_long, '##############', '.', ',' )

'&zoom=$(var_zoom)'

'&maptype='&var_maptype

'&size='&map_size_x&'x'&map_size_y

'&sensor=false'

Re: Re: GeoSpatial Solutions for Qlikview

fkeuroglian — Wed, 16 Apr 2014 13:00:40 GMT

Hi Ramkumar

Could you please chekc that you have set all the correct properties in this tab attach?

have you internet conecction when you open the document?