topic Re: new and regained customer in QlikView https://community.qlik.com/t5/QlikView/new-and-regained-customer/m-p/805287#M284318 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>This really depends on what data you have in your model. Do you want thsi to be done in the front-end or during reload?</P><P></P><P>It will be a lot easier to help you if you post a sample model and/or source file with the underlying data for your requirements. You will also get more accurate advice.</P><P></P><P>Jonathan</P></BODY></HTML> Mon, 24 Nov 2014 08:03:55 GMT jonathandienst 2014-11-24T08:03:55Z new and regained customer https://community.qlik.com/t5/QlikView/new-and-regained-customer/m-p/805286#M284317 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; I want to have two tables, where only data about new and regained customers are included.</P><P></P><P>Definition of new customer - &gt;he has sum of sales bigger than 7500 in last three months but was totally inactive earlier </P><P>Definition of regained customer - &gt; he has sum of sales bigger than 7500 in last three months, then he has been inactive for 18 months and has some sales before.</P><P></P><P>Do you have any ideas how can I achieve that?</P></BODY></HTML> Mon, 24 Nov 2014 07:55:00 GMT https://community.qlik.com/t5/QlikView/new-and-regained-customer/m-p/805286#M284317 2014-11-24T07:55:00Z Re: new and regained customer https://community.qlik.com/t5/QlikView/new-and-regained-customer/m-p/805287#M284318 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>This really depends on what data you have in your model. Do you want thsi to be done in the front-end or during reload?</P><P></P><P>It will be a lot easier to help you if you post a sample model and/or source file with the underlying data for your requirements. You will also get more accurate advice.</P><P></P><P>Jonathan</P></BODY></HTML> Mon, 24 Nov 2014 08:03:55 GMT https://community.qlik.com/t5/QlikView/new-and-regained-customer/m-p/805287#M284318 jonathandienst 2014-11-24T08:03:55Z Re: new and regained customer https://community.qlik.com/t5/QlikView/new-and-regained-customer/m-p/805288#M284319 <HTML><HEAD></HEAD><BODY><P>I want to do this in front-end because users may want to know who was "new" customer for example in april 2008. I think that this will be working only with these three tables</P><P></P><P>SALES -&gt; id of customer, date, id of goods, count of goods, price..</P><P></P><P>CUSTOMERS -&gt; id of customer, name...</P><P></P><P>CALENDAR -&gt;&nbsp; date, month, year, week, day, monthSerial, weekSerial...</P><P></P><P>Data model is pretty big and I cant upload it to internet. What exactly you would like to know?</P></BODY></HTML> Mon, 24 Nov 2014 09:16:54 GMT https://community.qlik.com/t5/QlikView/new-and-regained-customer/m-p/805288#M284319 2014-11-24T09:16:54Z