topic Cohort Analysis - Old plus New Customers in App Development https://community.qlik.com/t5/App-Development/Cohort-Analysis-Old-plus-New-Customers/m-p/2048502#M86214 <P>Hi, I am trying to come up with a cohort retention analysis in Qlik of this sort to see how customers are retained over time</P> <DIV class="s-table-container"> <TABLE class="s-table"> <THEAD> <TR> <TH>Month</TH> <TH>New Customers</TH> <TH>Month 1</TH> <TH>Month 2</TH> <TH>Month 3</TH> </TR> </THEAD> <TBODY> <TR> <TD>Jan 2023</TD> <TD>100</TD> <TD>100</TD> <TD>85</TD> <TD>50</TD> </TR> <TR> <TD>Feb 2023</TD> <TD>1000</TD> <TD>&nbsp;</TD> <TD>1085*</TD> <TD>900</TD> </TR> <TR> <TD>Mar 2023</TD> <TD>500</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>1400*</TD> </TR> </TBODY> </TABLE> </DIV> <P>*This displays total customers, that is New customers in Month 2 + returning customers from Month 1 (e.g. 1000 + 85 and 900 + 500)</P> <P>The only way I managed to do is come up with a pivot table to show the retained customers but I cannot find a way to add the new customers. How can I do this to achieve the above cohort chart?</P> <P>&nbsp;</P> Mon, 13 Mar 2023 13:13:48 GMT daniela5 2023-03-13T13:13:48Z Cohort Analysis - Old plus New Customers https://community.qlik.com/t5/App-Development/Cohort-Analysis-Old-plus-New-Customers/m-p/2048502#M86214 <P>Hi, I am trying to come up with a cohort retention analysis in Qlik of this sort to see how customers are retained over time</P> <DIV class="s-table-container"> <TABLE class="s-table"> <THEAD> <TR> <TH>Month</TH> <TH>New Customers</TH> <TH>Month 1</TH> <TH>Month 2</TH> <TH>Month 3</TH> </TR> </THEAD> <TBODY> <TR> <TD>Jan 2023</TD> <TD>100</TD> <TD>100</TD> <TD>85</TD> <TD>50</TD> </TR> <TR> <TD>Feb 2023</TD> <TD>1000</TD> <TD>&nbsp;</TD> <TD>1085*</TD> <TD>900</TD> </TR> <TR> <TD>Mar 2023</TD> <TD>500</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>1400*</TD> </TR> </TBODY> </TABLE> </DIV> <P>*This displays total customers, that is New customers in Month 2 + returning customers from Month 1 (e.g. 1000 + 85 and 900 + 500)</P> <P>The only way I managed to do is come up with a pivot table to show the retained customers but I cannot find a way to add the new customers. How can I do this to achieve the above cohort chart?</P> <P>&nbsp;</P> Mon, 13 Mar 2023 13:13:48 GMT https://community.qlik.com/t5/App-Development/Cohort-Analysis-Old-plus-New-Customers/m-p/2048502#M86214 daniela5 2023-03-13T13:13:48Z