topic Re: Pivot Table - Count days from selected Year and Month in QlikView

Pivot Table - Count days from selected Year and Month

Barry-Gon — Wed, 07 Apr 2021 19:24:40 GMT

Hello,

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

Please help

Thank you

QFabian — Wed, 07 Apr 2021 20:13:33 GMT

Hi @Barry-Gon , your second expression should be like this :

=Sum(total <Año> Aggr(Sum(DISTINCT Day(MonthEnd(InicioDelMes))),InicioDelMes))

Barry-Gon — Wed, 07 Apr 2021 22:10:43 GMT

Thank you @QFabian it works perfect! 😀