12 Replies Latest reply: Aug 10, 2015 10:40 PM by Sunny Talwar RSS

    Date Difference Calculation

    Damien Castillo

      Hi All,


      Good Day!

       

      I am currently working on a date calculation using QlikSense, I have a Customer column and an Order Date Column, and I need to calculate for the date difference between the customer orders and at the same time the average of the date difference of their orders. Please refer to the example below regarding the output of the date difference I am calculating for.

      DateComputation.PNG

      I've been working on this for quite a long time now but I can't get the result I wanted to see.

      Hope you can help me on this. Thanks in advance for your help everyone.