topic Date Last Used in QlikView https://community.qlik.com/t5/QlikView/Date-Last-Used/m-p/16435#M2709 <HTML><HEAD></HEAD><BODY><P>I am trying to figure out the best way to do this.&nbsp; I have a qvd which has Equipment numbers, dates and billed hours.&nbsp; I have a request to find all pieces of equipment where billed hours are equal to 0 and when was the last time (date) the piece of equipment had hours. I have attached an spreadsheet of the data.&nbsp; Thanks</P></BODY></HTML> Tue, 13 Feb 2018 13:08:22 GMT tmumaw 2018-02-13T13:08:22Z Date Last Used https://community.qlik.com/t5/QlikView/Date-Last-Used/m-p/16435#M2709 <HTML><HEAD></HEAD><BODY><P>I am trying to figure out the best way to do this.&nbsp; I have a qvd which has Equipment numbers, dates and billed hours.&nbsp; I have a request to find all pieces of equipment where billed hours are equal to 0 and when was the last time (date) the piece of equipment had hours. I have attached an spreadsheet of the data.&nbsp; Thanks</P></BODY></HTML> Tue, 13 Feb 2018 13:08:22 GMT https://community.qlik.com/t5/QlikView/Date-Last-Used/m-p/16435#M2709 tmumaw 2018-02-13T13:08:22Z Re: Date Last Used https://community.qlik.com/t5/QlikView/Date-Last-Used/m-p/16436#M2710 <HTML><HEAD></HEAD><BODY><P>I don't see any Hours Used = 0 in your data.</P><P></P><P>If there was, you could use peek to get the record just before the 0.</P></BODY></HTML> Tue, 13 Feb 2018 13:54:36 GMT https://community.qlik.com/t5/QlikView/Date-Last-Used/m-p/16436#M2710 m_woolf 2018-02-13T13:54:36Z