topic Re: How to retrieve the number of lost customer in actual month in QlikView

How to retrieve the number of lost customer in actual month

Mon, 14 Aug 2017 12:23:47 GMT

Hi everybody ,
I need your help :

I have sales revenues on customers in August 2017.
Among these clients active in August 2017, I would like to have the number of customers who are at 0 euros on the month of August 2018

How can I have this information please ( using Text box not chart )

Re: How to retrieve the number of lost customer in actual month

jmvilaplanap — Mon, 14 Aug 2017 12:36:03 GMT

Hi,

You can use Set Analysis, for example:

Count({<Month={'August'}, Revenue={0}>} Distinct Customer)

I don't know your data model exactly, but this more or less can work.

Regards

Re: How to retrieve the number of lost customer in actual month

Kushal_Chawda — Mon, 14 Aug 2017 12:45:33 GMT

like this?

=Count({<Customers ={"=sum(Revenue)=0"}>}distinct Customers)

Re: How to retrieve the number of lost customer in actual month

Mon, 14 Aug 2017 13:39:34 GMT

Hi , thanks for your time.
But this not what I expect , indeed : this return customer with revenue = 0 in August.

I need to retrun the number of customer who were actif in last year and not now :

For example :

In august 2017

Customer ID , Revenue

Customer1 , 10 $

Customer2 , 20 $

Customer3 , 30 $

In August 2018

Customer1 , 20$

my request must return ==> 2 ( 2 lost customers )

Re: How to retrieve the number of lost customer in actual month

Kushal_Chawda — Mon, 14 Aug 2017 13:52:42 GMT

try this

Count({<Customers =p({1<Customers={"=sum({1<Year={'$(=max(Year)-1)'}>}Revenue)>0"}>}Customers)>}distinct Customers)

Re: How to retrieve the number of lost customer in actual month

antoniotiman — Mon, 14 Aug 2017 16:07:47 GMT

Hi,

try like this

=Count({<Customer=P({<Month={'Aug 2017'}>})-P({<Month={'Aug 2018'}>})>} Distinct Customer)
&Chr(10)&
Concat({<Customer=P({<Month={'Aug 2017'}>})-P({<Month={'Aug 2018'}>})>} Distinct Customer,'-')

Regards,

Antonio

Re: How to retrieve the number of lost customer in actual month

Kvr — Thu, 07 Mar 2019 08:37:55 GMT

Hi All,

I have same kind of question but little tricky that I have to find no of lost customer in current year compare to previous years.

Thanks in adavance