topic Re: Retention rate/repeat customer in QlikView

Retention rate/repeat customer

luckanpej — Mon, 19 Jun 2017 08:35:09 GMT

Hi!

I'm having some issues calculating customers with repeat purchases.

I have a table similar to this:

Week	CustomerId	OrderId
5	200	1000
5	300	2000
6	400	3000
6	200	4000
7	300	5000
7	200	6000

How would I do to get a value of how many repeat customer purchases there are in week 7 for example? As you can see, CustomerId 200 and 300 are both recurring, so the value I'm looking for for week 7 would be "2" repeat customers.

I was thinking Set Analysis but can't get it to work, anyone have any ideas?

Best

Re: Retention rate/repeat customer

Anil_Babu_Samineni — Mon, 19 Jun 2017 09:33:28 GMT

May be use

Count(CustomerId)

Re: Retention rate/repeat customer

luckanpej — Mon, 19 Jun 2017 09:34:57 GMT

Hi,

Sorry if I was unclear, but when selected only week 7 I would like to count if there is any previous orders by each customer

Re: Retention rate/repeat customer

sunny_talwar — Mon, 19 Jun 2017 10:11:42 GMT

May be like this

Count(DISTINCT {<Week = {'$(=Max(Week))'}, CustomerId = p({<Week = {"$(='<' & Max(Week))"}>} CustomerId)>} CustomerId)

Re: Retention rate/repeat customer

sunny_talwar — Mon, 19 Jun 2017 10:14:01 GMT

Based on selection in Week 6, I am getting only 1 repeat customer

Re: Retention rate/repeat customer

Thu, 29 Jun 2017 08:59:21 GMT

hi,

how do you use the same formula to check how many repeats called in 24 hours, 48hours and 72 hours?

Re: Retention rate/repeat customer

jas0012qlik — Wed, 09 Aug 2017 16:30:09 GMT

Do you know a way to do the same thing for consecutive giving years to find the retention rate for donors?