Discussion board where members can get started with QlikView.
I need some help with a load script. I have the following table:
Each E demarcates the start of the process and N is the end. One Id can be linked to multiple processes. What I need is to create two additional fields like in the table below.
New fields needed
Date for N
Final Step is sequence for the particular process and continues till Next E
Date for N captures the date for N when CustomerCall appears after N and before E
Data in excel attached.
Go to Solution.
if(TouchPointStatus='E',1,peek([Final Step])+1) as [Final Step],
if(TouchPointStatus='CustomerCall' and previous(TouchPointStatus)='N',previous(Date),
if(TouchPointStatus='CustomerCall' and previous(TouchPointStatus='CustomerCall'),peek([Date for N]))) as [Date for N]
(ooxml, embedded labels, table is Sheet1);
See attached example.
You can find attached the requested script.
Hope this helps.
Thank you for your help, i got the desierd output using your solution.