Qlik Community

Qlik GeoAnalytics Discussions

Discussion Board for collaboration regarding Qlik GeoAnalytics.

Highlighted
sajalgour2309
New Contributor

Within Function Error

Hello Guys,

I want to do very simple thing but not sure why and where i am going wrong. I have a table in which i have got store's Lat, Lng  information and i have one KML file which has area location of different region.

 Now i just want to use Within function of geoanalytics so that if user qlik on any Region area he will get stores in that region.

There is no direct relation or field on which i can join these tables. I have created a geo analytics connector and trying to load this but i am getting error of request time out (ran out of memory)

Is it because in my KML file polygon information is very big or something else is going wrong ?

Attached is one sample KML file and connector information i am using.Untitled.png

 

Labels (1)
1 Solution

Accepted Solutions
Employee
Employee

Re: Within Function Error

Ok, if the areas is of super high resolution that can make memory run out. Here's some suggestions:

  1. Install and use QGA Plus, then the "Within" will be executed on premise, sending to cloud is demanding.
  2. Run first run the QGA operation "Simplify" first on the areas. Note, that will make the areas smaller but not exactly align with the original areas.
  3. Consider is to splitting the operation in batches, specially if there are many base stations.

Thanks,
Patric

View solution in original post

5 Replies
Employee
Employee

Re: Within Function Error

Make sure you only select the first table from the options shown after you select next
sajalgour2309
New Contributor

Re: Within Function Error

Hello,

I am sorry i am not getting which table should i select first ?

Can you please point ?

Many Thanks

Sajal

Employee
Employee

Re: Within Function Error

Hi,
The input looks ok except for the last Geometry type, change that to "Area" instead of "Point".

For me it helps to think that the first dataset is what we iterate over, like in this case: "For each BaseStation which Region is it Within?"

This is the same for all ops with two datasets, like Closest, Within, Intersects

Thanks,
Patric
sajalgour2309
New Contributor

Re: Within Function Error

Hello Patric,

I was just waiting for your reply only. Every time i search anything related to Geo analytics i see your name coming up...

I have tried changing to Area instead of Point but still no luck. Error i am getting is object out of memory. Script fails when it tries to read data from KML (auto script which connector generates)

You are right i just want to know if i select any base station it should give me back a region in which it belongs. I have actual latitude and Longitude of base stations and i have one KML file (attached) which has area location. (There is no relation between these two table)

 

 

Employee
Employee

Re: Within Function Error

Ok, if the areas is of super high resolution that can make memory run out. Here's some suggestions:

  1. Install and use QGA Plus, then the "Within" will be executed on premise, sending to cloud is demanding.
  2. Run first run the QGA operation "Simplify" first on the areas. Note, that will make the areas smaller but not exactly align with the original areas.
  3. Consider is to splitting the operation in batches, specially if there are many base stations.

Thanks,
Patric

View solution in original post