Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have the same error using the Qlik GeoAnalytic Connector for Interset and Within query.
I tried these function with very simple table to be sure of the syntax, i got you some screencap:
Here is the scriptrequest:
[WithinResultTable]:
Load * Extension GeoOperations.ScriptEval('
Within()
DATASOURCE City INTABLE keyField="City_ID", crs="auto", pointField="City_LocationPoint"
DATASOURCE Country INTABLE keyField="Country_ID", crs="auto", polygonField="Country.Country_Name_GeoInfo"
', City);
So i basically trying to make the script work for a City ($Geopoint) Within a Country ($GeoPolygon). I receive this error:
Hey Joost,
Querry with two intable doesn't seem to work. I recommend you save one of your dataset externally as a CSV or even better a GeoJson.
Hi Peter,
You are making the querry with two tabled previously loaded into the qlik engine (Intable parameters).
Most of geoanaylitcs work with a max of one Intable, the other data must be loaded from elsewhere (made it through a Dropbox if I recall)....
Best regards,
O.
I've got the same problem using the Within function in Qlik SAAS. I think it's a bug because it works in Qlik Sense Eneterprise Geo Analytics
Hey Joost,
Querry with two intable doesn't seem to work. I recommend you save one of your dataset externally as a CSV or even better a GeoJson.
Hi Jerome,
Thanks for your reply. I think you're right, hopefully the functionality of using two loaded tables will be in a new release of Qlik SAAS shortly.
202-01-18: I'm experiencing the same issue, moving an app from QlikSense (which worked 100% perfect with the GeoAnalytics connector "within") to SaaS and using GeoOperations instead. Identical data in both applications.
Are loaded tables the problem?
Error
GeoAnalytics script (ok)
GeoOperation script (error)
[WithinResultTable]:
Load * Extension GeoOperations.ScriptEval('
SELECT enclosed_enclosing_RelationId, V_ID, ICE_AREAS.Name, enclosing.ICE_AREAS.Area, enclosed.Position FROM
Within()
DATASOURCE enclosed INTABLE keyField="V_ID", crs="auto", pointField="Position"
DATASOURCE enclosing INTABLE keyField="ICE_AREAS.Name", crs="auto", polygonField="ICE_AREAS.Area"
', VESSEL_AIS_POS);
Hi Peter,
You are making the querry with two tabled previously loaded into the qlik engine (Intable parameters).
Most of geoanaylitcs work with a max of one Intable, the other data must be loaded from elsewhere (made it through a Dropbox if I recall)....
Best regards,
O.
Hi Oliver,
Thank you for your response. This was not clear to me.
So, what is best practice here? My point-data file is residing on SaaS as a QVD - changing daily whilst my polygon KML file is static. The file contains a few named polygons. Do you think it is it possible to convert the KML file to a usable format and place same in a catalogue on SaaS rather to have it somewhere externally (e.g. Dropbox)?
LOAD
ICE_AREAS.Name,
ICE_AREAS.Area,
FROM [lib://Static content:DataFiles/ICE_AREAS.KML]
Don't worry, it is not clear for anyone seeing this specific point isn't detailled in the documentation and can only be founded in specific post in the forum 😉
I didn't try to work with the kml file, maybe you can try it's relative cloud address and use that address inside the geoanalytics connect parameters.