topic finding the profitability threshold in QlikView https://community.qlik.com/t5/QlikView/finding-the-profitability-threshold/m-p/244198#M1206320 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I try to figure out how to calculate the number of subscription weeks to get the advertising investments profitable.</P><P>Materials I got is :</P><UL><LI>gross costs (I'm able to drill down to daily basis for each support / campaign)</LI><LI>subscription's fare is Z each week</LI><LI>records of unsubscriptions over time for each subscription day of last year (see picture attached)</LI><LI>those show a quite steady trend over time</LI></UL><P>My think is that :</P><UL><LI>I need to determine the right formula for unsubcription rate ; something like "ax² + bx + c = 0 " where x is the number of week</LI><LI>then for each week solve "ax² + bx + c = week gross cost "</LI></UL><P>Do you think my method is correct ? and can anyone help me make it works ?</P><P>Thanks a lot</P><P></P><P>Cheers</P><P></P><P>Julien</P></BODY></HTML> Wed, 24 Feb 2010 13:01:33 GMT 2010-02-24T13:01:33Z finding the profitability threshold https://community.qlik.com/t5/QlikView/finding-the-profitability-threshold/m-p/244198#M1206320 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I try to figure out how to calculate the number of subscription weeks to get the advertising investments profitable.</P><P>Materials I got is :</P><UL><LI>gross costs (I'm able to drill down to daily basis for each support / campaign)</LI><LI>subscription's fare is Z each week</LI><LI>records of unsubscriptions over time for each subscription day of last year (see picture attached)</LI><LI>those show a quite steady trend over time</LI></UL><P>My think is that :</P><UL><LI>I need to determine the right formula for unsubcription rate ; something like "ax² + bx + c = 0 " where x is the number of week</LI><LI>then for each week solve "ax² + bx + c = week gross cost "</LI></UL><P>Do you think my method is correct ? and can anyone help me make it works ?</P><P>Thanks a lot</P><P></P><P>Cheers</P><P></P><P>Julien</P></BODY></HTML> Wed, 24 Feb 2010 13:01:33 GMT https://community.qlik.com/t5/QlikView/finding-the-profitability-threshold/m-p/244198#M1206320 2010-02-24T13:01:33Z