https://community.qlik.com/t5/QlikView/Average-customer-lifetime/m-p/1003132#M647694 <HTML><HEAD></HEAD><BODY><P><SPAN class="hps">Good afternoon</SPAN></P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="hps">I am trying to</SPAN> <SPAN class="hps">calculate the mean</SPAN> <SPAN class="hps">lifetime of</SPAN> <SPAN class="hps">customers</SPAN> <SPAN class="hps">every month.</SPAN> <SPAN class="hps">I have</SPAN> <SPAN class="hps">a table</SPAN> <SPAN class="hps">where</SPAN> <SPAN class="hps">the discharge date</SPAN> <SPAN class="hps">and</SPAN> <SPAN class="hps">date low of</SPAN> <SPAN class="hps">each</SPAN> <SPAN class="hps">customer</SPAN> <SPAN class="hps">appears</SPAN>. <SPAN class="hps">I want to calculate</SPAN> <SPAN class="hps">the number</SPAN> <SPAN class="hps">of</SPAN> <SPAN class="hps">customers who</SPAN> <SPAN class="hps">are active</SPAN> <SPAN class="hps">each month and</SPAN> <SPAN class="hps">the number of days</SPAN> <SPAN class="hps">that have been active</SPAN> <SPAN class="hps">until this</SPAN> <SPAN class="hps">month</SPAN>, later to <SPAN class="hps">calculate the average</SPAN>.</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="hps">Excel</SPAN> <SPAN class="hps">attached</SPAN> <SPAN class="hps">an example</SPAN> <SPAN class="hps">of</SPAN> <SPAN class="hps">what I'm</SPAN> <SPAN class="hps">trying to do.</SPAN></P><P></P><P> <SPAN class="hps">Many thanks for your time.</SPAN></P></BODY></HTML> Sun, 18 Oct 2015 18:38:11 GMT 2015-10-18T18:38:11Z https://community.qlik.com/t5/QlikView/Average-customer-lifetime/m-p/1003132#M647694 <HTML><HEAD></HEAD><BODY><P><SPAN class="hps">Good afternoon</SPAN></P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="hps">I am trying to</SPAN> <SPAN class="hps">calculate the mean</SPAN> <SPAN class="hps">lifetime of</SPAN> <SPAN class="hps">customers</SPAN> <SPAN class="hps">every month.</SPAN> <SPAN class="hps">I have</SPAN> <SPAN class="hps">a table</SPAN> <SPAN class="hps">where</SPAN> <SPAN class="hps">the discharge date</SPAN> <SPAN class="hps">and</SPAN> <SPAN class="hps">date low of</SPAN> <SPAN class="hps">each</SPAN> <SPAN class="hps">customer</SPAN> <SPAN class="hps">appears</SPAN>. <SPAN class="hps">I want to calculate</SPAN> <SPAN class="hps">the number</SPAN> <SPAN class="hps">of</SPAN> <SPAN class="hps">customers who</SPAN> <SPAN class="hps">are active</SPAN> <SPAN class="hps">each month and</SPAN> <SPAN class="hps">the number of days</SPAN> <SPAN class="hps">that have been active</SPAN> <SPAN class="hps">until this</SPAN> <SPAN class="hps">month</SPAN>, later to <SPAN class="hps">calculate the average</SPAN>.</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="hps">Excel</SPAN> <SPAN class="hps">attached</SPAN> <SPAN class="hps">an example</SPAN> <SPAN class="hps">of</SPAN> <SPAN class="hps">what I'm</SPAN> <SPAN class="hps">trying to do.</SPAN></P><P></P><P> <SPAN class="hps">Many thanks for your time.</SPAN></P></BODY></HTML> Sun, 18 Oct 2015 18:38:11 GMT https://community.qlik.com/t5/QlikView/Average-customer-lifetime/m-p/1003132#M647694 2015-10-18T18:38:11Z