How to create a Route map using line layer in Qlik Sense

vikasmahajan — Tue, 28 Jun 2022 11:38:48 GMT

Hi All,

Following are the steps for creating a line layer ( Route Map ) in Qlik Sense.

Script :

Cities:

LOAD

Distinct

Source

FROM [lib://RouteMap/Route-Map Data.xlsx]

(ooxml, embedded labels, table is [Routes- Output]);

Cities:

LOAD

Distinct

Destination

FROM [lib://RouteMap/Route-Map Data.xlsx]

(ooxml, embedded labels, table is [Routes- Output]);

Temp_Facts:

LOAD

Source as CityFrom,

Destination as CityTo,

"FC Plying",

"No of Transactions",

"Actual Sales",

"Lost Opportunity"

FROM [lib://RouteMap/Route-Map Data.xlsx]

(ooxml, embedded labels, table is [Routes- Output]);

Facts:

NoConcatenate

LOAD

CityFrom AS City

Resident Temp_Facts;

Drop Table Temp_Facts;

This way we can develop route map in Qlik Sense , Please ensure you have Sept-2018 release for implementing the same.

Thanks

Vikas

article How to create a Route map using line layer in Qlik Sense in Member Articles