topic Re: customer count, new,lost, total in QlikView

customer count, new,lost, total

Sun, 13 Oct 2013 21:45:39 GMT

I have the following logic to calculate

Lost Customer - hasn't bought anything the last two years

New Customer - bought something this year, but nothing the last two years

Total Customers - everyone who has bought something this year

i have attached my model to this post.

i worked out how to calculate New Customer , however am really battling with the other two lost customer and Total customer.

any help is greatly appreciated.

Best,

Brad

Anonymous — Sun, 13 Oct 2013 22:27:20 GMT

Try this =if(Count(Year(Year) = 2013),sum(amt)) I hope it helps!

jagan — Mon, 14 Oct 2013 03:10:33 GMT

Hi,

Please find attached file for solution. Calculated Total and Lost customer in script.

Hope this helps you.

Regards,

Jagan.

Mon, 14 Oct 2013 09:05:06 GMT

Total Customers can be done by :

Count(DISTINCT {<Year={2013}>} customer)

Mon, 14 Oct 2013 09:59:55 GMT

Hi,

New customer can be done by :

= count({<Year=-{2012,2011}>} distinct customer)

Total customer :

= count (distinct customer)

Lost customer:

= count({<Year=-{2012,2013}>} distinct customer)