topic Re: Counting frequent flyers in QlikView https://community.qlik.com/t5/QlikView/Counting-frequent-flyers/m-p/656876#M239849 <HTML><HEAD></HEAD><BODY><P>Hi Lee,</P><P>Post some sample and come up with an expected output, it would be easier go understand and provide solution.</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Fri, 11 Jul 2014 02:55:42 GMT jagan 2014-07-11T02:55:42Z Counting frequent flyers https://community.qlik.com/t5/QlikView/Counting-frequent-flyers/m-p/656875#M239848 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Firstly, new to QlikView and enjoying the experience so far.</P><P></P><P>Secondly, sorry if this has been previously answered, but searching on 'Frequent Flyer' and 'Repeat Customers' didn't yield any results.</P><P></P><P>Anyway, if I have a table with the fields</P><P>'<STRONG>STORE_ID</STRONG>', '<STRONG>CUSTOMER_ID</STRONG>', '<STRONG>PURCHASE_DATETIME</STRONG>'</P><P></P><P>How can I</P><P> 1 - Check for repeat customers per store (where the customer ID is unique only against a store id) within a timeframe?</P><P> 2 - Have the timeframe determined from the selection in a listbox (i.e. 24 hours, 7 days, 28 days)?</P><P></P><P>Many thanks,</P><P></P><P>Lee</P></BODY></HTML> Fri, 11 Jul 2014 00:54:54 GMT https://community.qlik.com/t5/QlikView/Counting-frequent-flyers/m-p/656875#M239848 2014-07-11T00:54:54Z Re: Counting frequent flyers https://community.qlik.com/t5/QlikView/Counting-frequent-flyers/m-p/656876#M239849 <HTML><HEAD></HEAD><BODY><P>Hi Lee,</P><P>Post some sample and come up with an expected output, it would be easier go understand and provide solution.</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Fri, 11 Jul 2014 02:55:42 GMT https://community.qlik.com/t5/QlikView/Counting-frequent-flyers/m-p/656876#M239849 jagan 2014-07-11T02:55:42Z