topic Count status changes at a certain date in QlikView https://community.qlik.com/t5/QlikView/Count-status-changes-at-a-certain-date/m-p/286367#M712759 <HTML><HEAD></HEAD><BODY><P>I've done an intervalmatch so that I get each status for each person every day. What I want to do now is calculate who is a New customer.</P><P>The definition of a new customer is one that have moved from either&nbsp; LEAD,INACTIVE, TEMPORARYINACTIVE to status ACTIVE.</P><P></P><P>I've tried using peek(,-1) to get the previous status but the problem is that I get all the persons that have changed from any prior status to ACTIVE at any date historically, I just need to count the ones that had a change from LEAD,INACTIVE, TEMPORARYINACTIVE to status ACTIVE at the date or date range of my choice.</P><P></P><P>Uploaded an example and some testdata if anyone has any ideas.</P></BODY></HTML> Tue, 10 May 2011 09:37:33 GMT 2011-05-10T09:37:33Z Count status changes at a certain date https://community.qlik.com/t5/QlikView/Count-status-changes-at-a-certain-date/m-p/286367#M712759 <HTML><HEAD></HEAD><BODY><P>I've done an intervalmatch so that I get each status for each person every day. What I want to do now is calculate who is a New customer.</P><P>The definition of a new customer is one that have moved from either&nbsp; LEAD,INACTIVE, TEMPORARYINACTIVE to status ACTIVE.</P><P></P><P>I've tried using peek(,-1) to get the previous status but the problem is that I get all the persons that have changed from any prior status to ACTIVE at any date historically, I just need to count the ones that had a change from LEAD,INACTIVE, TEMPORARYINACTIVE to status ACTIVE at the date or date range of my choice.</P><P></P><P>Uploaded an example and some testdata if anyone has any ideas.</P></BODY></HTML> Tue, 10 May 2011 09:37:33 GMT https://community.qlik.com/t5/QlikView/Count-status-changes-at-a-certain-date/m-p/286367#M712759 2011-05-10T09:37:33Z