Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Barry-Gon
Contributor II
Contributor II

Pivot Table - Count days from selected Year and Month

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"

Barry-Gon_0-1617823136311.png

The result should be like this

Barry-Gon_1-1617823270868.png

Please help

 

Thank you

 

Labels (2)
1 Solution

Accepted Solutions
QFabian
Specialist III
Specialist III

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

 

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

QFabian_0-1617826448114.png

 

QFabian

View solution in original post

2 Replies
QFabian
Specialist III
Specialist III

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

 

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

QFabian_0-1617826448114.png

 

QFabian
Barry-Gon
Contributor II
Contributor II
Author

Thank you @QFabian  it works perfect! 😀