2 Replies Latest reply: May 22, 2013 3:10 PM by Rafael Forchetti RSS

    How to calculate time between dynamically selected steps ?

      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 ?