topic Find Source and Destination based on visit sequence in QlikView https://community.qlik.com/t5/QlikView/Find-Source-and-Destination-based-on-visit-sequence/m-p/1343109#M413555 <HTML><HEAD></HEAD><BODY><P>!Greetings.</P><P></P><P>Dear All,</P><P></P><P>Attached is a sample dataset of planned shops visit.</P><P></P><P>1st sheet (Shops) comprises of all shops and shop names.</P><P>2nd sheet (Shops visit Sequence). One shop to another</P><P>3rd sheet (Visit Plan) comprises of daily visit plan (by week and by day) 1= Yes, 0 = No</P><P></P><P>I need help in deriving a new fields "From Destination" and "To Destination" on the bases of shops visit sequence .</P><P></P><P>For eg.</P><TABLE border="1" class="jiveBorder" style="border: 1px solid #000000; border-image: none; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>PlanID</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><P><STRONG>Visit Sequence</STRONG><STRONG><BR /></STRONG></P></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>From Destination</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>To Destination</STRONG></TH></TR><TR><TD style="padding: 2px;"><P>1</P></TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">1001</TD><TD style="padding: 2px;">1002</TD></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">1002</TD><TD style="padding: 2px;">1003</TD></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">1003</TD><TD style="padding: 2px;">1004</TD></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">4</TD><TD style="padding: 2px;">1004</TD><TD style="padding: 2px;">1005</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">1004</TD><TD style="padding: 2px;">1005</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">1005</TD><TD style="padding: 2px;">1003</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">1003</TD><TD style="padding: 2px;">1002</TD></TR></TBODY></TABLE><P></P><P>Any Quick help would be appreciated.</P></BODY></HTML> Wed, 19 Apr 2017 13:36:28 GMT Anonymous 2017-04-19T13:36:28Z Find Source and Destination based on visit sequence https://community.qlik.com/t5/QlikView/Find-Source-and-Destination-based-on-visit-sequence/m-p/1343109#M413555 <HTML><HEAD></HEAD><BODY><P>!Greetings.</P><P></P><P>Dear All,</P><P></P><P>Attached is a sample dataset of planned shops visit.</P><P></P><P>1st sheet (Shops) comprises of all shops and shop names.</P><P>2nd sheet (Shops visit Sequence). One shop to another</P><P>3rd sheet (Visit Plan) comprises of daily visit plan (by week and by day) 1= Yes, 0 = No</P><P></P><P>I need help in deriving a new fields "From Destination" and "To Destination" on the bases of shops visit sequence .</P><P></P><P>For eg.</P><TABLE border="1" class="jiveBorder" style="border: 1px solid #000000; border-image: none; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>PlanID</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><P><STRONG>Visit Sequence</STRONG><STRONG><BR /></STRONG></P></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>From Destination</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>To Destination</STRONG></TH></TR><TR><TD style="padding: 2px;"><P>1</P></TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">1001</TD><TD style="padding: 2px;">1002</TD></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">1002</TD><TD style="padding: 2px;">1003</TD></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">1003</TD><TD style="padding: 2px;">1004</TD></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">4</TD><TD style="padding: 2px;">1004</TD><TD style="padding: 2px;">1005</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">1004</TD><TD style="padding: 2px;">1005</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">1005</TD><TD style="padding: 2px;">1003</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">1003</TD><TD style="padding: 2px;">1002</TD></TR></TBODY></TABLE><P></P><P>Any Quick help would be appreciated.</P></BODY></HTML> Wed, 19 Apr 2017 13:36:28 GMT https://community.qlik.com/t5/QlikView/Find-Source-and-Destination-based-on-visit-sequence/m-p/1343109#M413555 Anonymous 2017-04-19T13:36:28Z