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.
