Qlik Community

Qlik GeoAnalytics Discussions

Discussion Board for collaboration regarding Qlik GeoAnalytics.

larry_alwin
New Contributor

GeoAnalytics using Within Function

I have two associated datasets for households and bank branches.  I have created travel areas around each bank branch and a point map of the households using Lat, Lon.  I need the travel area (polygon) selectable to select the households (points) within that travel area.

When I load a small sample (10) of the housholds the data loads, creates 3 synthetic keys, a circular reference and the engine fails.

When I load a larger sample (100) of the households the load fails with a null error (though no nulls exist).

i am finding very very little documentation on using within and the within example is using a point within a standard area rather than a loaded table polygon and I am unable to use it to make my app work.

Is there anyone out there that has successfully done this that would be able to help me out?

Thanks

My data model and settings for the within are as follows.

8 Replies
Employee
Employee

Re: GeoAnalytics using Within Function

Hi Larry,

Switch the order of the indata, the first dataset should be the points you want to test with and the second dataset is the areas (in your case TravelAreas.)

Check out the example for "Within"

http://bi.idevio.com/geoanalytics/geoanalytics-connector-examples

Thanks,

Patric

larry_alwin
New Contributor

Re: GeoAnalytics using Within Function

I get the same result either way.  It doesn't populate the withinassociations table with either load order.

Employee
Employee

Re: GeoAnalytics using Within Function

Hi Larry,

I would plot the branches and the travelareas on a map first to get a visual check of which branches that falls into which area. Sorry for being unclear, I meant fill in the parameters like this:

Within_p.PNG

Thanks,

Patric

larry_alwin
New Contributor

Re: GeoAnalytics using Within Function

I have tried both and I get the same result.

here is a setup with your suggestion and i get the same result.  0 records found in the withinassociations table.

Within2.PNG

Employee
Employee

Re: GeoAnalytics using Within Function

Ok, that's odd, could you share the indata?

Please note the order for 'Latitude and Longitude Point', the last screenshot has the wrong order for the fields.

Should be HHkey,HHLat,HHLon.

I would also drop the 'B.' in front the travelarea table fields.

Thanks,

Patric

Asanchez77
New Contributor

Re: GeoAnalytics using Within Function

HI patrick, i need to know if the algorithm are to be able to test 4000 points in 12000 polygons

Employee
Employee

Re: GeoAnalytics using Within Function

Hi,
Should work, I recommend using QGA Plus or an own QGA Server.

Takes also a look at the following doc on how to split the operation into multiple calls, will even out the load and reduce the risk of time outs.

https://community.qlik.com/t5/Qlik-GeoAnalytics-Documents/Splitting-up-GeoAnalytics-connector-operat...

Thanks,
Patric
Asanchez77
New Contributor

Re: GeoAnalytics using Within Function

Thanks so much!

Community Browser