topic Subtracting Dates to determine Progress in QlikView

Subtracting Dates to determine Progress

Anonymous — Mon, 23 May 2016 12:51:07 GMT

I would like to calculate number of days on each WP Status. (Ageing per WP Status)

I have a Progress date when the workflow started and also
a WP ProgressID. Also a Created Date when the incident stated.

I basically need to take the lowest progress ID’s Progress date. Look at when the following one started – Then subtract the time diff.

Do you know how to structure this?

Thank you

Reference No	WP Created Date	WP Progress Date	WP Status	WP ProgressID	=[WP ProgressDate]-[WP CreatedDate]
					-
1	2016-05-16 17:39	2016-05-23 10:59	CLOSED	6816	7.0
1	2016-05-16 17:39	2016-05-23 10:57	FINALIZE	6813	7.0
1	2016-05-16 17:39	2016-05-17 9:00	UPDATE	5770	1.0
1	2016-05-16 17:39	2016-05-17 9:00	VERIFY	5769	1.0
1	2016-05-16 17:39	2016-05-16 17:39	NEW INCIDENT	5597	0.0

sunny_talwar — Mon, 23 May 2016 13:25:56 GMT

May be this:

[WP Progress Date] - FirstSortedValue(TOTAL <[Refrence No]> [WP Progress Date], [WP ProgressID])

With Reference No and WP ProgressID as dimension

sunny_talwar — Mon, 23 May 2016 13:29:32 GMT

Or are you trying to create Created date in the script?

Anonymous — Fri, 27 May 2016 08:57:24 GMT

Hi Sunny

Thanks for your speedy reply, but I had internet issues so only getting back to you now.

I'm happy with a backend or frontend expression that will solve this.

The expression you gave gives me the same answer as WP Progress Date - WP Created Date

What I do need is actually days on each WP Status.

This should take the lowest WP Progress Date/ID look at the next WP Progress Date and return the number of days on each WP Status

So by definition WP Progress Date is the Date where the WP Status stated.

So if you subtract the next WP Progress Date from the current WP Progress Date you should get the days on each status.

Is a backend or frontend script better for this and do you have a solution???

Kind regards