topic Check time difference since last action in App Development https://community.qlik.com/t5/App-Development/Check-time-difference-since-last-action/m-p/1137318#M20065 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I've been searching for an answer to this one for a while, but I couldn't figure it out based on existing posts, so I decided to ask a question instead.</P><P></P><P>I have a scenario where I have a table with events. These events have a DATE, a PERSON_ID and an EVENT_TYPE.</P><P>I would like to check, using set analysis, what is the avg time between 2 different actions.</P><P>Meaning, I'd like to know how long it took from since a person had an event of type 'BOOKING' to an event of type 'SALE'.</P><P>Also, it is possible the person never had the previous action.</P><P></P><P>I tried using above() with combination with aggr() to try and check the actions done previously by the person, but I couldn't ge it to work.</P><P></P><P>Could someone please give me an example for this?</P></BODY></HTML> Fri, 19 Aug 2016 06:21:27 GMT 2016-08-19T06:21:27Z Check time difference since last action https://community.qlik.com/t5/App-Development/Check-time-difference-since-last-action/m-p/1137318#M20065 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I've been searching for an answer to this one for a while, but I couldn't figure it out based on existing posts, so I decided to ask a question instead.</P><P></P><P>I have a scenario where I have a table with events. These events have a DATE, a PERSON_ID and an EVENT_TYPE.</P><P>I would like to check, using set analysis, what is the avg time between 2 different actions.</P><P>Meaning, I'd like to know how long it took from since a person had an event of type 'BOOKING' to an event of type 'SALE'.</P><P>Also, it is possible the person never had the previous action.</P><P></P><P>I tried using above() with combination with aggr() to try and check the actions done previously by the person, but I couldn't ge it to work.</P><P></P><P>Could someone please give me an example for this?</P></BODY></HTML> Fri, 19 Aug 2016 06:21:27 GMT https://community.qlik.com/t5/App-Development/Check-time-difference-since-last-action/m-p/1137318#M20065 2016-08-19T06:21:27Z