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

[vikasmahajan]

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