GeoAnalytics: Improve "NamedPointLookup" functionalities in order obtain a sufficient quality of detection & search

Florent — Wed, 27 Jan 2021 22:04:01 GMT

QlikSense dashboard demo to show exemples of GPS coordinates detection issues with "NamedPointLookup" tool

(ref. to the idea https://community.qlik.com/t5/Ideas/GeoAnalytics-Improve-quot-NamedPointLookup-quot-functionalities/idi-p/1775512#comment-on-this)

Script used :

CityDetection: LOAD * INLINE [ Id, CityCountryName 1, "La Roche-sur-Yon,FR" 2, "La Roche sur Yon,FR" 3, "Saint-Gilles-Croix-de-Vie,FR" 4, "Saint-Gilles Croix de Vie,FR" 5, "La Rochelle,FR" 6, "La Rochelle,FR" ]; LIB CONNECT TO 'GeoAnalyticsPlusCloud'; /* Generated by GeoAnalytics for operation NamedPointLookup ---------------------- */ [_inlineMap_]: mapping LOAD * inline [ _char_, _utf_ "'", '\u0027' '"', '\u0022' "[", '\u005b' "/", '\u002f' "*", '\u002a' ";", '\u003b' "}", '\u007d' "{", '\u007b' "`", '\u0060' "´", '\u00b4' " ", '\u0009' ]; IF FieldNumber('Id', 'CityDetection') = 0 THEN call InvalidInlineData('The field Id in CityDetection is not available'); END IF IF FieldNumber('CityCountryName', 'CityDetection') = 0 THEN call InvalidInlineData('The field CityCountryName in CityDetection is not available'); END IF Let [CityDetectionInlineTable] = 'Id' & Chr(9) & 'CityCountryName'; Let numRows = NoOfRows('CityDetection'); Let chunkSize = 1000; Let chunks = numRows/chunkSize; For n = 0 to chunks Let chunkText = ''; Let chunk = n*chunkSize; For i = 0 To chunkSize-1 Let row = ''; Let rowNr = chunk+i; Exit for when rowNr >= numRows; For Each f In 'Id', 'CityCountryName' row = row & Chr(9) & MapSubString('_inlineMap_', Peek('$(f)', $(rowNr), 'CityDetection')); Next chunkText = chunkText & Chr(10) & Mid('$(row)', 2); Next [CityDetectionInlineTable] = [CityDetectionInlineTable] & chunkText; Next chunkText='' [LookupResult]: SQL SELECT [CityCountryName], [CityDetection_Geometry], [CityDetection_Name], [CountryIso2] FROM NamedPointLookup(nameField='CityCountryName', type='P*', country='', nameTable='CityDetection') DATASOURCE CityDetection INLINE tableName='CityDetection', tableFields='Id,CityCountryName', geometryType='NONE', loadDistinct='NO', suffix='', crs='Auto' {$(CityDetectionInlineTable)} ; tag field [CityCountryName] with '$primarykey'; tag field [CityDetection_Geometry] with '$geopoint'; tag field [CityCountryName] with '$geoname'; tag field [CityDetection_Geometry] with '$relates_CityCountryName'; tag field [CityCountryName] with '$relates_CityDetection_Geometry'; [CityDetectionInlineTable] = ''; /* End GeoAnalytics operation NamedPointLookup ----------------------------------- */ LEFT JOIN(CityDetection) LOAD * RESIDENT [LookupResult]; DROP TABLE [LookupResult];

Re: GeoAnalytics: Improve "NamedPointLookup" functionalities in order obtain a sufficient quality of detection & search - Status changed to: Open - Collecting Feedback

Patric_Nordstrom — Tue, 23 Feb 2021 18:16:26 GMT

Thank you for your feedback on ways to improve our product. While this is something we understand would be useful, it's not on the short-term roadmap. Please continue to show your support for this idea.

Thanks,

Patric

From now on, please track this idea from the Ideation por...

Meghann_MacDonald — Wed, 02 Aug 2023 15:32:56 GMT

From now on, please track this idea from the Ideation portal.

Link to new idea

Meghann

NOTE: Upon clicking this link 2 tabs may open - please feel free to close the one with a login page. If you only see 1 tab with the login page, please try clicking this link first: Authenticate me! then try the link above again. Ensure pop-up blocker is off.

Re: GeoAnalytics: Improve "NamedPointLookup" functionalities in order obtain a sufficient quality of detection & search - Status changed to: Closed - Archived

Ideation — Wed, 02 Aug 2023 15:32:58 GMT

idea From now on, please track this idea from the Ideation por... in Suggest an Idea

GeoAnalytics: Improve "NamedPointLookup" functionalities in order obtain a sufficient quality of detection & search

Re: GeoAnalytics: Improve "NamedPointLookup" functionalities in order obtain a sufficient quality of detection & search - Status changed to: Open - Collecting Feedback

From now on, please track this idea from the Ideation por...

Re: GeoAnalytics: Improve "NamedPointLookup" functionalities in order obtain a sufficient quality of detection & search - Status changed to: Closed - Archived