Count Distinct - Customer Cycle

[Jamal]

Dear QlikView Experts,

I need to calculate :

1- count distinct  customer  with Datefin<= MakeDate($(vCurrentYear),$(vCurrentMonthNum),$(vCurrentDay))

Formula : count(distinct aggr(if(Datefin>0 and Datefin<= MakeDate($(vCurrentYear),$(vCurrentMonthNum),$(vCurrentDay)),[IDCLIENT]),[IDCLIENT],DATEPRODSQL))

2- Cumulative count of customers with Datefin <= MakeDate($(vCurrentYear),$(vCurrentMonthNum),$(vCurrentDay))

==> When I select year in dateField , I need to display all customers with datefin <= $(vCurrentYear)

3 - Returning Customer :

Formula :  count( distinct aggr(if(DATEPRODSQL > 0 and DATEPRODSQL > DATEFIN_LASTDOS AND DRetour<=360,[IDCLIENT]),[IDCLIENT],DATEPRODSQL))

Thank you for your help.