topic How to calculate time between dynamically selected steps ? in QlikView

How to calculate time between dynamically selected steps ?

Tue, 21 May 2013 20:16:42 GMT

I need to calculate the time it took from an item to go from step X to step Y.

The client wants to dynamically select those steps for comparison.

So, in the example table:

ITEM | STEP | DATE

------------------------------

A | 1 | 01/01/2012

A | 2 | 01/02/2012

A | 5 | 01/03/2012

A | 6 | 01/04/2012

A | 7 | 01/05/2012

A | 9 | 01/06/2012

B | 1 | 01/01/2012

B | 2 | 01/02/2012

B | 3 | 01/03/2012

B | 5 | 01/04/2012

B | 6 | 01/05/2012

B | 7 | 01/06/2012

The client would choose steps 2 and 5 and I would show :

ITEM | TIME (days)

-----------

A | 30

B | 60

Any way to do this in qlikview ?

Re: How to calculate time between dynamically selected steps ?

Wed, 22 May 2013 14:53:59 GMT

Hi:

Maybe using:

Max(DATE) - Min (DATE)

as Expression in a pivot table whre the only dimension is the Item?

Regards

Re: How to calculate time between dynamically selected steps ?

Wed, 22 May 2013 19:10:56 GMT

That would work but as you said only if Item is used as dimension, there are dimensions above the item and I would like to show the average time it took, using max/min wouldn't work on those cases...