article Connector Examples Qlik GeoAnalytics in Qlik Sense Documents

Connector Examples Qlik GeoAnalytics

Patric_Nordstrom — Fri, 02 Apr 2021 08:29:01 GMT

Examples and guides for the Qlik GeoAnalytics Connector operations. The examples are self sufficient with data and reloadable. The examples are minimal to explain to basic functionality. Please use the documentation for details of the operations.

Although the examples are made with Qlik Sense the load script code will work in QlikView too. The following operations are covered

AddressPointLookup (Separate license required, Qlik Geocoding)
Binning
Closest
Cluster Guide
Dissolve Guide
Intersects
IntersectsMost
IpLookup
Load
NamedAreaLookup
NamedPointLookup
PointToAddressLookup (Separate license required, Qlik Geocoding)
Routes
Simplify
SpatialIndex
TravelAreas
Within

Edit, the examples have been updated to use map chart.

Re: Connector Examples Qlik GeoAnalytics

shaybitton — Fri, 29 Mar 2019 10:33:22 GMT

Hi Patric,

I tried to use your example of Routes, but did'nt manage to generate the script.

there is an error in the browser console on the developer tools on chrome.

I even tried to use your example on a new app with the same inline table.

After clicking next, the insert button doesn't do anything and the console error shows up.

did i miss somthing?

BR,

Shay

Re: Connector Examples Qlik GeoAnalytics

Patric_Nordstrom — Sun, 31 Mar 2019 11:38:28 GMT

Ok, that looks strange, I could repeat the example without errors on my machine.

Which version of Qlik Sense, Web Browser and Qlik GeoAnalytics are you running?

Thanks,

Patric

Re: Connector Examples Qlik GeoAnalytics

shaybitton — Tue, 02 Apr 2019 21:08:20 GMT

Hi,

Thanks for your reply,

Problem solved, after closing and reopening the browser.

Anyway, I am using Feb 12 for QS (Patch 1) & QGA

and Version 73.0.3683.86 (Official Build) (64-bit) of Chrome.

Shay

Re: Connector Examples Qlik GeoAnalytics

savheid — Wed, 26 Feb 2020 14:41:56 GMT

Hello Patric,

I used your code like this :

/* Calculate travel areas with 30 min drive time from the sales offices. */
/* At the same time, load the sales offices data. */

LIB CONNECT TO 'GA_she (groupe_hvanderheyden)';

// /* Generated by Qlik GeoAnalytics for operation TravelAreas ---------------------- */
// SQL SELECT OfficeId, SalesOffices_TravelArea, SalesOffices_Status FROM TravelAreas(costValue='1800', costField='', costUnit='Seconds', transportation='car', dataset='SalesOffices')
// DATASOURCE SalesOffices CSV url='https://download.idevio.com/demodata/USLocationDemo/SalesOfficesNE.csv', keyField='OfficeId', geometryField='OfficePoint', geometryType='POINT', suffix='', encoding='UTF-8', fieldSeparator='TAB', recordSeparator='NEWLINE'
// SELECT OfficeId, OfficePoint, OfficeState FROM SalesOffices;
// SQL LOAD * FROM SalesOffices;
// /* End Qlik GeoAnalytics operation TravelAreas ----------------------------------- */

LIB CONNECT TO 'GA_she (groupe_hvanderheyden)';

/* Generated by GeoAnalytics for operation TravelAreas ---------------------- */
[_inlineMap_]:
mapping LOAD * inline [
_char_, _utf_
"'", '\u0027'
'"', '\u0022'
"[", '\u005b'
"/", '\u002f'
"*", '\u002a'
";", '\u003b'
"}", '\u007d'
"{", '\u007b'
"`", '\u0060'
"´", '\u00b4'
" ", '\u0009'
];

IF FieldNumber('OfficeId', 'offices') = 0 THEN
call InvalidInlineData('The field OfficeId in offices is not available');
END IF
IF FieldNumber('OfficeLat', 'offices') = 0 THEN
call InvalidInlineData('The field OfficeLat in offices is not available');
END IF
IF FieldNumber('OfficeLon', 'offices') = 0 THEN
call InvalidInlineData('The field OfficeLon in offices is not available');
END IF
Let [SalesOfficesInlineTable] = 'OfficeId' & Chr(9) & 'OfficeLat' & Chr(9) & 'OfficeLon';
Let numRows = NoOfRows('offices');
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 'OfficeId', 'OfficeLat', 'OfficeLon'
row = row & Chr(9) & MapSubString('_inlineMap_', Peek('$(f)', $(rowNr), 'offices'));
Next
chunkText = chunkText & Chr(10) & Mid('$(row)', 2);
Next
[SalesOfficesInlineTable] = [SalesOfficesInlineTable] & chunkText;
Next
chunkText=''

[TravelAreas]:
SQL SELECT [OfficeId], [SalesOffices_TravelArea], [SalesOffices_Origin], [SalesOffices_Cost],[SalesOffices_CostUnit], [SalesOffices_Status]
FROM TravelAreas(costValue='30', costField='', costUnit='Minutes', transportation='car',
dataset='SalesOffices')
DATASOURCE SalesOffices INLINE tableName='offices', tableFields='OfficeId,OfficeLat,OfficeLon',
geometryType='POINTLATLON',
loadDistinct='NO', suffix='', crs='Auto' {$(SalesOfficesInlineTable)}
;

tag field [OfficeId] with '$primarykey';
tag field [SalesOffices_TravelArea] with '$geopolygon';
tag field [OfficeId] with '$geoname';
tag field [SalesOffices_TravelArea] with '$relates_OfficeId';
tag field [OfficeId] with '$relates_SalesOffices_TravelArea';

[SalesOfficesInlineTable] = '';

/* End GeoAnalytics operation TravelAreas ----------------------------------- */

I want now to have multiple layer depending of the cost.

I tried to duplicate the code by changing the cost value but it doesn't work.

Could you help me ?

SQL SELECT [OfficeId], [SalesOffices_TravelArea], [SalesOffices_Origin], [SalesOffices_Cost],[SalesOffices_CostUnit], [SalesOffices_Status]
FROM TravelAreas(costValue='60', costField='', costUnit='Minutes', transportation='car',
dataset='SalesOffices')
DATASOURCE SalesOffices INLINE tableName='offices', tableFields='OfficeId,OfficeLat,OfficeLon',
geometryType='POINTLATLON',
loadDistinct='NO', suffix='', crs='Auto' {$(SalesOfficesInlineTable)}
;

Re: Connector Examples Qlik GeoAnalytics

savheid — Wed, 26 Feb 2020 14:55:56 GMT

Hi,

I used your code to perform travel area and it's working.

I tried to duplicate the corresponding code to have many layers on the map, depending of the value of the cost field

But it's not working.

Could you help me ?

Re: Connector Examples Qlik GeoAnalytics

Patric_Nordstrom — Sun, 01 Mar 2020 10:28:45 GMT

@savheid

Use the connector wizard and fill in the values instead of copying the code.

Making three TravelAreas after each other works fine.

Here's a video to get started with connector:

https://www.youtube.com/watch?v=ley7BH87qXw

Thanks,

Patric

Re: Connector Examples Qlik GeoAnalytics

gokulkumaravel — Tue, 21 Apr 2020 05:26:35 GMT

Hi Patric,

I tried to use your example of Dissolve, but did'nt manage to generate the script in qlikview.

IT is showing an error as below.

What is the mistake i am committing. Kindly let me know

Regards

Gokul

Re: Connector Examples Qlik GeoAnalytics

Patric_Nordstrom — Wed, 22 Apr 2020 14:39:50 GMT

@gokulkumaravel note that when copying to QV, it's necessary to generate a new connection string to the script. It's a button in the QGA connector dialogue.

Does any of the other scripts work?

Thanks,

Patric

Re: Connector Examples Qlik GeoAnalytics

sergiorey — Tue, 01 Dec 2020 20:58:18 GMT

Hi Patric,

Hope you are fine!

I tried to follow your example of TravelAreas and it is working fine with a costValue defined and blank costField but not working when using a specified CostField and blank CostValue. We are getting the following error:

QVX_FIELD_NOT_FOUND: Trying to get unknown column name: radius in the dataset Dataset

Where "radius" is the field used in "CostField" and it is available in the loaded table specified in the connection wizard.

Any ideas on this error?

Thanks in advance!

Regards,

Sergio.

PD:
Qlik Sense June 2020 and Qlik GeoAnalytics September 2019 using "bird" as transportation.

Re: Connector Examples Qlik GeoAnalytics

Patric_Nordstrom — Fri, 11 Dec 2020 09:17:41 GMT

The cost field has to be included in the table fields :

Re: Connector Examples Qlik GeoAnalytics

sergiorey — Fri, 18 Dec 2020 18:30:43 GMT

Thank you very much Patric!

Best regards,

Sergio.

Re: Connector Examples Qlik GeoAnalytics

ludovic5971 — Thu, 17 Mar 2022 10:06:03 GMT

Hi Patric,

Thank you very much for all these examples.

However I have a question about intersect. How can I change the color only of the common area between two?