2 Replies Latest reply: Feb 29, 2016 1:25 PM by Stefan Wühl RSS

    Pick the latest date

    Deepanshu Chamoli

      Hi All

       

      Kindly help in the below logic in Qlik Sense( both in the SQL Query and Visualization):

       

      In want to calculate the Age of the case as ( Snapshot attached )

       

      Age = 5/1/2016 - 1/1/2016

       

      i.e. the last Timestamp date (where case is closed) - the day on which the ticket is submitted.

       

      But the problem is there are so many dates between the start date and closed date, can you please guide me how can I get the age

       

      swuehl

      stalwar1

      gwassenaar

       

       

      Attached is the snapshot for your reference

       

      Thanks

      Deepanshu