9 Replies Latest reply: Sep 3, 2015 6:09 AM by Joanna Seldon RSS

    Qlik Sense - time taken to reach target

    Joanna Seldon

      Hiya

       

      I have a customer column, Check Number column, date time column, and target column

       

      for each customer at different time intervals (Check Number)....a date and time is recorded in the date time column....and current target number

       

      I wish to calculate how much time is taken for the customer to reach the target from e.g 1-100

       

      can this be done?

       

      I know you can do interval (a-b) ect , but my time and date recordings, are all in one column not separate

       

      please help

       

      Kind Regards

       

      Joeybird