topic Re: How to build routes between From and To locations in GeoAnalytics

How to build routes between From and To locations

didierodayo — Fri, 16 Mar 2018 23:12:29 GMT

Hello,

I have put together this sample holiday data which consists of hotel and all the places to visit. I have also attached a qvf with a simple bubble map.

I need helpt to determine (in a KPI and on the map)

- the distance to each place to visit from the hotel as a line on the map and a KPI

- the distance between locations so I can see the closest place to visit when am at another particular location

- Total distance

I appreciate any assistance on this.

Thanks

Re: sample distance app

Qrishna — Sat, 17 Mar 2018 01:44:22 GMT

I am not able to see any map on my QS desktop.

Re: sample distance app

didierodayo — Sat, 17 Mar 2018 03:36:34 GMT

Hi Krishana. I think you will need the geoanalytics installed and licensed to be able to see the map. Not sure if they have trial versions for it though.

Re: sample distance app

Patric_Nordstrom — Wed, 21 Mar 2018 15:01:29 GMT

Hi Didier,

Check out the app "Routing Danish Cities" at

http://bi.idevio.com/products/idevio-maps-for-qlik-sense/qlik-sense-2

that does almost the same thing, calculating all distances between positions.

You need to build a cross table that holds the routes you want and then feed that to the QGA connector "Route" operation.

Thanks,

Patric

Re: How to build routes between From and To locations

didierodayo — Wed, 21 Mar 2018 18:59:15 GMT

Thanks Patric. I will check it out.

Re: How to build routes between From and To locations

mohan_1105 — Mon, 20 Aug 2018 07:26:06 GMT

Hi Patric,

I know this is an irrelevant question on this thread, I'm working on Geoanalytics, I couldn't able download any example qvf application from the website. I tried to download as suggested on the page in Internet explorer.

Regards,

Mohan

Re: How to build routes between From and To locations

Patric_Nordstrom — Tue, 30 Oct 2018 07:53:16 GMT

Ok strange, works in most cases with right click and ”save link as...”

‌

Re: sample distance app

Karen_Gumerov — Tue, 14 Apr 2020 10:38:42 GMT

Hi @Patric_Nordstrom,

Now bi.idevio.com is unavailable and so is the app you mentioned. Is there any way to locate it at the moment?

Thanks.

Re: sample distance app

Patric_Nordstrom — Tue, 14 Apr 2020 11:45:33 GMT

Yes, that was an old link. Examples have been moved to here:

https://help.qlik.com/en-US/geoanalytics/Content/Qlik_GeoAnalytics/GeoAnalytics-Sense/GeoAnalytics-Examples-Sense.htm

Thanks,

Patric

Re: sample distance app

hopkinsc — Thu, 25 Jun 2020 14:49:19 GMT

Hi @Patric_Nordstrom I hope you are well and safe.

Is there an up to date link to get the actual example qvf for the 'routing danish cities' app. I am trying to get route times from postal code to postal code.

Many thanks

P.s. loved your presentation on QlikWorld 2020, amazing work.

Re: sample distance app

Patric_Nordstrom — Fri, 26 Jun 2020 08:05:36 GMT

Thanks! The link on the page above points to the home of the examples:

https://community.qlik.com/t5/Qlik-GeoAnalytics-Documents/Qlik-Sense-Examples-Qlik-GeoAnalytics/ta-p/1548751

Thanks,

Patric

Re: sample distance app

Karen_Gumerov — Mon, 13 Jul 2020 22:00:32 GMT

Hi@Patric_Nordstrom,

Is there any way to modify routes on the fly, for example, if I need to switch between the fastest route and the shortest route? It seems that Qlik is able to display only preloaded geodata. Or should I load both types of routes (fastest/shortest) and then apply filters? Along with route type it might also be useful to select transportation type (car/plane/walk). Are these features supported?

Thanks.

Re: sample distance app

Patric_Nordstrom — Tue, 14 Jul 2020 10:01:31 GMT

@Karen_Gumerov GeoAnlaytics connector operations are performed at load time so either:

Calculate all options like you suggest.
Use ODAG or Dynamic Views to spawn new calculations: https://community.qlik.com/t5/Qlik-GeoAnalytics-Documents/Geo-operations-with-ODAG/ta-p/1485306

The new service GeoOperations is based on SSE and can perform certain operations in runtime. GeoOperations is currently only available for QCS and QSEoK.

https://help.qlik.com/en-US/geoanalytics/Content/Qlik_GeoAnalytics/GeoOperationsFunctions/GeoOperations.htm

Thanks,

Patric

Re: sample distance app

Karen_Gumerov — Fri, 17 Jul 2020 11:22:10 GMT

@Patric_Nordstromthanks for the information.

I tried the sample app in QSE, but the ODAG button is displayed as invalid visualization. Do I need any additional extensions or whatever?

Re: sample distance app

Patric_Nordstrom — Fri, 17 Jul 2020 19:31:45 GMT

Hi, yes you need to recreate the odag link when copying to a new environment.

And odag needs to be enabled.

Re: sample distance app

Karen_Gumerov — Wed, 22 Jul 2020 08:09:46 GMT

@Patric_Nordstromis there any way to find out the possible criteria values of GeoAnalytics location service?
For example, in Routing Danish Cities app the routes are built using the following parameters: criteria='fastest', transportation='car'. Just by chance I guessed, that criteria could also be 'shortest' and it really worked. But I have no idea what are the other (if exist) options for transportation type. I tried different stuff like 'walk', 'plane', 'train', but none worked.

This page https://help.qlik.com/en-US/geoanalytics/Content/Qlik_GeoAnalytics/GeoAnalytics-Sense/Location-Service-Sense.htm doesn't mention such parameters at all. It is more about addresses and administrative divisions.

Thanks.

Re: sample distance app

Patric_Nordstrom — Thu, 23 Jul 2020 21:02:18 GMT

The "Routes" operation is documented under the QGA Connector section:

https://help.qlik.com/en-US/geoanalytics/Subsystems/GeoConnector/Content/connector/connector-geoanalytics_reference-Operation.htm#Operation.Routes

Thanks,

Patric