topic QV: detecting at risk customers through sales data in QlikView https://community.qlik.com/t5/QlikView/QV-detecting-at-risk-customers-through-sales-data/m-p/1211492#M388560 <HTML><HEAD></HEAD><BODY><P>I have in my QV application all sales data for all my customer from 2010 until this moment.</P><P></P><P>In this sales table there is:</P><P>- date of purchase</P><P>- item number</P><P>- group (items are devided into groups)</P><P>- qty</P><P>- selling price</P><P></P><P>For some of the items (depending on the group they are in) I want to do a customer analyse to detect if the customer is at risk.</P><P>In other words if the customer is depending on his purchase behavior overdue with his next order.</P><P></P><P>Can anybody help me with this?</P><P></P><P></P><P></P><P>Thx!</P></BODY></HTML> Tue, 11 Oct 2016 11:55:08 GMT 2016-10-11T11:55:08Z QV: detecting at risk customers through sales data https://community.qlik.com/t5/QlikView/QV-detecting-at-risk-customers-through-sales-data/m-p/1211492#M388560 <HTML><HEAD></HEAD><BODY><P>I have in my QV application all sales data for all my customer from 2010 until this moment.</P><P></P><P>In this sales table there is:</P><P>- date of purchase</P><P>- item number</P><P>- group (items are devided into groups)</P><P>- qty</P><P>- selling price</P><P></P><P>For some of the items (depending on the group they are in) I want to do a customer analyse to detect if the customer is at risk.</P><P>In other words if the customer is depending on his purchase behavior overdue with his next order.</P><P></P><P>Can anybody help me with this?</P><P></P><P></P><P></P><P>Thx!</P></BODY></HTML> Tue, 11 Oct 2016 11:55:08 GMT https://community.qlik.com/t5/QlikView/QV-detecting-at-risk-customers-through-sales-data/m-p/1211492#M388560 2016-10-11T11:55:08Z Re: QV: detecting at risk customers through sales data https://community.qlik.com/t5/QlikView/QV-detecting-at-risk-customers-through-sales-data/m-p/1211493#M388561 <HTML><HEAD></HEAD><BODY><P>I think you need something like<A href="https://community.qlik.com/qlik-blogpost/3913">Recipe for an ABC Analysis</A> and/or <A href="https://community.qlik.com/qlik-blogpost/3821">Buckets</A> to get a database to be able respectively to get nearer to predict a customer behaviour within the future.</P><P></P><P>- Marcus</P></BODY></HTML> Wed, 12 Oct 2016 12:38:34 GMT https://community.qlik.com/t5/QlikView/QV-detecting-at-risk-customers-through-sales-data/m-p/1211493#M388561 marcus_sommer 2016-10-12T12:38:34Z