Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT

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

cancel
Showing results for 
Search instead for 
Did you mean: 
vikasmahajan

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

Last Update:

Jun 28, 2022 7:38:48 AM

Updated By:

Sonja_Bauernfeind

Created date:

Oct 31, 2018 12:43:49 AM

Attachments

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

Labels (1)
Version history
Last update:
‎2022-06-28 07:38 AM
Updated by: