topic Churn and Retention Analysis in QlikView https://community.qlik.com/t5/QlikView/Churn-and-Retention-Analysis/m-p/682780#M476158 <HTML><HEAD></HEAD><BODY><P>Hi fellow QlikViewers.</P><P></P><P>Does anyone having any example documents with charts of retention analysis or churn stats that they would like to share here.</P><P></P><P>I need to create a chart showing how many customers were active on each day in a month - that is easy. I then need to show for each day, how many of those SAME customers were still active D+1, D+2 up to D+7 days after that, e.g.</P><P></P><P><SPAN style="font-family: courier new,courier;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Number on Day&nbsp;&nbsp;&nbsp; Day+1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Day+2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; etc etc</SPAN></P><P>01-JUN-2014&nbsp;&nbsp;&nbsp; 60&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <STRONG>30</STRONG> ( 50% )&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20 ( 33% )&nbsp;&nbsp;&nbsp; ...</P><P>02-JUN-2014&nbsp;&nbsp;&nbsp; 50&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 40 ( 80% )&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10 ( 20% )&nbsp;&nbsp;&nbsp; ...</P><P>03-JUN-2014&nbsp;&nbsp;&nbsp; 32&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 24 ( 75% )&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 16 ( 50% )</P><P>...</P><P></P><P>In other words the 30 customers active on 02-JUN-2014 were only one half of those active on 01-JUN-2014. The fact that there were 50 people active on 02-JUN-2014 is immaterial for the 01-JUN-2014 retention line as some of these 50 people are new customers who were not active on 01-JUN-2014. Each date can be considered in isolation.</P><P></P><P>Regards</P><P>Andrew.</P></BODY></HTML> Sun, 15 Jun 2014 17:04:12 GMT 2014-06-15T17:04:12Z Churn and Retention Analysis https://community.qlik.com/t5/QlikView/Churn-and-Retention-Analysis/m-p/682780#M476158 <HTML><HEAD></HEAD><BODY><P>Hi fellow QlikViewers.</P><P></P><P>Does anyone having any example documents with charts of retention analysis or churn stats that they would like to share here.</P><P></P><P>I need to create a chart showing how many customers were active on each day in a month - that is easy. I then need to show for each day, how many of those SAME customers were still active D+1, D+2 up to D+7 days after that, e.g.</P><P></P><P><SPAN style="font-family: courier new,courier;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Number on Day&nbsp;&nbsp;&nbsp; Day+1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Day+2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; etc etc</SPAN></P><P>01-JUN-2014&nbsp;&nbsp;&nbsp; 60&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <STRONG>30</STRONG> ( 50% )&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20 ( 33% )&nbsp;&nbsp;&nbsp; ...</P><P>02-JUN-2014&nbsp;&nbsp;&nbsp; 50&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 40 ( 80% )&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10 ( 20% )&nbsp;&nbsp;&nbsp; ...</P><P>03-JUN-2014&nbsp;&nbsp;&nbsp; 32&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 24 ( 75% )&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 16 ( 50% )</P><P>...</P><P></P><P>In other words the 30 customers active on 02-JUN-2014 were only one half of those active on 01-JUN-2014. The fact that there were 50 people active on 02-JUN-2014 is immaterial for the 01-JUN-2014 retention line as some of these 50 people are new customers who were not active on 01-JUN-2014. Each date can be considered in isolation.</P><P></P><P>Regards</P><P>Andrew.</P></BODY></HTML> Sun, 15 Jun 2014 17:04:12 GMT https://community.qlik.com/t5/QlikView/Churn-and-Retention-Analysis/m-p/682780#M476158 2014-06-15T17:04:12Z Re: Churn and Retention Analysis https://community.qlik.com/t5/QlikView/Churn-and-Retention-Analysis/m-p/682781#M476159 <HTML><HEAD></HEAD><BODY><P>You can find some examples here:</P><P><A href="https://community.qlik.com/message/238025">Bridge Analysis : New, Lost, Loyal customer</A></P><P><A href="https://community.qlik.com/thread/95329">how to count null records</A></P><P>Not quite what you seem to want to do, but perhaps enough to get you started.</P></BODY></HTML> Sun, 15 Jun 2014 18:53:53 GMT https://community.qlik.com/t5/QlikView/Churn-and-Retention-Analysis/m-p/682781#M476159 Gysbert_Wassenaar 2014-06-15T18:53:53Z