Suggest an Idea

[Florent]

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/...)

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];

[Patric_Nordstrom]

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

[Meghann_MacDonald]

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.