Discussion Board for collaboration related to QlikView App Development.
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 .
Any Quick help would be appreciated.