topic Count distinct new and old client in QlikView

Count distinct new and old client

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I have a customer base on orders of 36 months of purchase.I wanted to know if we could from a period of date to verify if this same customer has already ordered over the last 24 months to know if It is a new or old customer to subsequently caculate a number of old and new customers

thanks for your help

Re: Count distinct new and old client

ahaahaaha — Wed, 14 Jun 2017 14:43:59 GMT

Hi,

May be like in attached file

Regards,

Andrey

Re: Count distinct new and old client

Anonymous — Wed, 14 Jun 2017 16:10:39 GMT

Hi,

Thanks for your help

This is practically that but why does not it work when I select a date and more it is possible to get at the end only two figures. A separate discount from customers for old and another for new?

regards

Re: Count distinct new and old client

Anonymous — Thu, 29 Jun 2017 14:00:46 GMT

Hello, I wanted to thank you for your help not looking with your track I found a solution

New client=>301 = Sum(If(Aggr(Min({<Date=>} Date), [Code Client]) < AddMonths(vDateDébut,-24), 1, 0))