Discussion Board for collaboration related to QlikView App Development.
Given a Year and month selected, How could I get the Count number of days for each Year/Month selected in a pivot table?
The expected value is in column "Count Days"
The result should be like this
Hi @Barry-Gon , your second expression should be like this :
=Sum(total <Año> Aggr(Sum(DISTINCT Day(MonthEnd(InicioDelMes))),InicioDelMes))
View solution in original post
Thank you @QFabian it works perfect! 😀