topic Count New or Returning Customers in QlikView https://community.qlik.com/t5/QlikView/Count-New-or-Returning-Customers/m-p/390209#M145584 <HTML><HEAD></HEAD><BODY><P>I am using QV ver 11. I have a list of sales transactions with the associated dates and customer IDs. What I require to know is the number of new or returning customers. That is defined as anyone who has bought from us for the first time since the last 90 days. </P><P></P><P>So for example I want to know the new or returning customers for Dec 29 2012. I need a count of the customer IDs who shopped on Dec 29 and who did not shop between Sep 30 and Dec 28. I did this manually by selecting the date range Sep 30 - Dec 28. Then I selected the excluded Customer IDs. Then I selected Dec 29th. I have a chart where I counted the distinct customer IDs and it generated the number I am looking for. Lets say that number is 10. I can do the same sort of excerise for Dec 30 and lets say that gets me 12 new or returning customers. I need to get 22 new or returning customers for the period Dec 29/30.</P><P></P><P>Thanks in Advance for any help you can offer...</P></BODY></HTML> Wed, 27 Feb 2013 19:15:22 GMT Anonymous 2013-02-27T19:15:22Z Count New or Returning Customers https://community.qlik.com/t5/QlikView/Count-New-or-Returning-Customers/m-p/390209#M145584 <HTML><HEAD></HEAD><BODY><P>I am using QV ver 11. I have a list of sales transactions with the associated dates and customer IDs. What I require to know is the number of new or returning customers. That is defined as anyone who has bought from us for the first time since the last 90 days. </P><P></P><P>So for example I want to know the new or returning customers for Dec 29 2012. I need a count of the customer IDs who shopped on Dec 29 and who did not shop between Sep 30 and Dec 28. I did this manually by selecting the date range Sep 30 - Dec 28. Then I selected the excluded Customer IDs. Then I selected Dec 29th. I have a chart where I counted the distinct customer IDs and it generated the number I am looking for. Lets say that number is 10. I can do the same sort of excerise for Dec 30 and lets say that gets me 12 new or returning customers. I need to get 22 new or returning customers for the period Dec 29/30.</P><P></P><P>Thanks in Advance for any help you can offer...</P></BODY></HTML> Wed, 27 Feb 2013 19:15:22 GMT https://community.qlik.com/t5/QlikView/Count-New-or-Returning-Customers/m-p/390209#M145584 Anonymous 2013-02-27T19:15:22Z