Qlik Community

Ask a Question

Qlik Sense Documents

Qlik Sense documentation and resources.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY

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

vikasmahajan
Champion
Champion

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

Hi All,

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

Route Map.jpg

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

Attachments
Version history
Revision #:
1 of 1
Last update:
‎2018-10-31 12:43 AM
Updated by: