How to calculate time between dynamically selected steps ?

[#1]

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 ?

[#2]

Hi:

Maybe using:

     Max(DATE) -  Min (DATE)

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

Regards

[#3]

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...