Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
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 II
Specialist II

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 II
Specialist II

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

Barry-Gon
Contributor II
Contributor II
Author

Thank you @QFabian  it works perfect! 😀