topic Date difference based on status in QlikView

Date difference based on status

aveeeeeee7en — Sat, 07 Sep 2013 21:47:24 GMT

TICKETNUMBER	WORKSTATUS	MODIFIEDON				11.85318
CD1300000292734	Pending for Customer Approval	20/05/13	Pick Minimum Date	20/05/13	Maximum Date - Minimum Date
CD1300000292734	Pending for Customer Approval	21/05/13
CD1300000292734	Pending for Customer Approval	23/06/13
CD1300000292734	Customer Approved	01/06/13	Pick Maximum Date	01/06/13
CD1300000292734	Pending for Customer Approval	29/05/13	Pick Minimum Date1	29/05/13	Maximum Date1 - Minimum Date1	6.8136
CD1300000292734	Pending for Customer Approval	30/05/13
CD1300000292734	Pending for Customer Approval	03/06/13
CD1300000292734	Customer Approved	03/06/13	Pick Maximum Date1
CD1300000292734	Customer Approved	05/06/13	Pick Maximum Date1	05/06/13
CD1300000292734	Pending for Customer Approval	17/06/13	Not to be used since after 'Pending for Customer Approval' there is no 'Customer Approval'. So, I don’t have to consider these cases.
CD1300000292734	Pending for Customer Approval	17/06/13
CD1300000292734	Pending for Customer Approval	19/06/13
CD1300000292734	Pending for Customer Approval	22/06/13
CD1300000292734	Pending for Customer Approval	26/06/13
CD1300000292734	Pending for Customer Approval	01/07/13
CD1300000292734	Pending for Customer Approval	04/07/13
CD1300000292734	Pending for Customer Approval	09/07/13
					Total	18.6667

Need help on the above example.

swuehl — Sat, 07 Sep 2013 22:12:41 GMT

Have you looked into my suggested solution I posted to your previous thread?

aveeeeeee7en — Sat, 07 Sep 2013 22:17:51 GMT

Yes Sir. I have seen your previous thread. That was wonderful but it was not giving me desired output.

Kindly help me on this.

adnan_rafiq — Sun, 08 Sep 2013 05:59:19 GMT

Hi,

when you reload data user group by. it will be like

load Ticket_id,

Status,

if(Status = 'Customer approval', Max(date) )as Maxdate,

if(Status <>' Customer Approval', Min(date))as Min_date

From File group by Ticket_id, Status ;

swuehl — Sun, 08 Sep 2013 08:57:24 GMT

well, I do get your desired output (as posted in your sample data), just loading your data with my suggested solution.

see attached.

Please exactly point out the issue with this solution.