Counting frequent flyers

[#1]

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

[jagan]

Hi Lee,

Post some sample and come up with an expected output, it would be easier go understand and provide solution.

Regards,

Jagan.