Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
hassam_ahmed
New Contributor III

Find Source and Destination based on visit sequence

!Greetings.

Dear All,

Attached is a sample dataset of planned shops visit.

1st sheet (Shops) comprises of all shops and shop names.

2nd sheet (Shops visit Sequence). One shop to another

3rd sheet (Visit Plan) comprises of daily visit plan (by week and by day) 1= Yes, 0 = No

I need help in deriving a new fields "From Destination" and "To Destination" on the bases of shops visit sequence .

For eg.

PlanID

Visit Sequence

From DestinationTo Destination

1

110011002
1210021003
1310031004
1410041005
2110041005
2210051003
2310031002

Any Quick help would be appreciated.