Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all Expert,
I have to add Lost customer, recovered customer and new customer with Month trend recently.
I found someone do Lost Customer with this method: http://community.qlik.com/thread/39754
however, if i use this method, i can't show the number of lost customer with month trend.
it can only show the total number of current month...
our definition of Lost Customer is: 1.customer have no sales in previous 6 months (e.g. now is 20 - Jan - 2015, customer has no sales between 19-Jul-2014 to 19-Jan-2015, then customer lost on the date of 20-Jan-2015) 2. have sales before (e.g. on 18-Jul-2014 or before have sales)
do you have any better idea to deal with the lost customer????
thanks,
Manie
why no experts answer this question....help help help~~