Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Find number of days in present month

Hi all,

How can i find the number of days in the month?

Regards,

Pramod

Tags (1)
1 Solution

Accepted Solutions

Re: Find number of days in present month

=Num(MonthStart(Max(DateField)) - MonthEnd(Min(DateField)))

Change the DateField according to your requirement.

Or simply try

=day(monthend(today() ) )

5 Replies

Re: Find number of days in present month

=Num(MonthStart(Max(DateField)) - MonthEnd(Min(DateField)))

Change the DateField according to your requirement.

Or simply try

=day(monthend(today() ) )

Re: Find number of days in present month

If you already have year and month calculated from date. You can use below expression

= sum(aggr(count(Date),Year,Month))

balrajahlawat
Esteemed Contributor

Re: Find number of days in present month

something like:



= sum(aggr(count(day(Date)),Month))

MVP
MVP

Re: Find number of days in present month

Hi,

Try like this

LOAD

*,

Num(MonthStart(DateField) - MonthEnd(DateField) + 1) AS NumberOfDaysInMonth

FROm DataSource;


Hope this helps you.


Regards,

jagan.

MVP
MVP

Re: Find number of days in present month

Day(Monthend(Today()))