Hi,
Firstly, new to QlikView and enjoying the experience so far.
Secondly, sorry if this has been previously answered, but searching on 'Frequent Flyer' and 'Repeat Customers' didn't yield any results.
Anyway, if I have a table with the fields
'STORE_ID', 'CUSTOMER_ID', 'PURCHASE_DATETIME'
How can I
1 - Check for repeat customers per store (where the customer ID is unique only against a store id) within a timeframe?
2 - Have the timeframe determined from the selection in a listbox (i.e. 24 hours, 7 days, 28 days)?
Many thanks,
Lee
.png "Luminary Alumni"){kind=icon}