Count Distinct - Customer Cycle

Jamal — Sat, 18 Jun 2022 07:51:28 GMT

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.

topic Count Distinct - Customer Cycle in QlikView

Count Distinct - Customer Cycle