topic Re: Avg Time Period For A given Item in QlikView

Avg Time Period For A given Item

Sat, 02 Jun 2012 06:20:42 GMT

Dear

All.

Help me in the folloing scenario.

Kindly find the Attachments.

Thanks,

Mukram.

Re: Avg Time Period For A given Item

swuehl — Sat, 02 Jun 2012 13:02:08 GMT

Mukram,

If you use above(total), you will get the previous line disregarding the column sections (new ItemID).

I would suggest that you remove the CreationDate from the dimensions, using an Expression instead (it's a 1:1 relation to ProcedureID anyway, right?), then your Delta ProcedureTime expression could look like

=Interval((CreationDate)-Above( CreationDate))

and the average ProcedureTime:

=Interval(avg(total<ItemID> aggr((CreationDate)-Above( CreationDate),ItemID,ProcedureID)))

To make the last expression work, your ProcedureIDs should have the correct load order (chronological), as in your input file (because aggr() will order by load order).

Re: Avg Time Period For A given Item

Sat, 02 Jun 2012 16:24:44 GMT

Dear,

Swuehi.

Thank you for your Reply.

i will clear one thing.

The Item is Moving from source to Destination by passing through the diffrent ProcedureID's.

when an item is moving from One ProcedureID To another ProcedureID i need to calculate time interval between those two ProcedureID's, and at the end of that of the ProdedureID i need to calculate Total Avg time to reach the Item From Source to Destination.

in below attached you can see the Item Movments, from Different ProcedureID's.

and May be sometimes ProcedureID's are not Order.means

an item can move first ProcedureID=54 then ProcedureID=35 and so on.

below attached is the scenario of the ItemID=107 which is moving from Different ProceDureID's.

when item is move from ProcedureID=35 to 38 i need the Time Difference.(00:00:03) (3 seconds) and so on.

Thanks,

Mukram.

Re: Avg Time Period For A given Item

swuehl — Sat, 02 Jun 2012 16:48:22 GMT

I created a new field in the script that allows to order your second dimesion ProcedureID accordingly.

Thus I think the first expression should work fine now, not 100% sure about the second (the average).

Regards,

Stefan

Re: Avg Time Period For A given Item

Sat, 02 Jun 2012 17:23:09 GMT

Dear,

Swuehi.

Thanks for help.

yes first expression is working 100% correct and full filling my requirement.

Thanks,

Mukram.