Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld online is next week! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Find number of days in present month

Hi all,

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

Regards,

Pramod

1 Solution

Accepted Solutions
tamilarasu
Champion
Champion

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

Change the DateField according to your requirement.

Or simply try

=day(monthend(today() ) )

View solution in original post

5 Replies
tamilarasu
Champion
Champion

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

Change the DateField according to your requirement.

Or simply try

=day(monthend(today() ) )

Kushal_Chawda

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

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

balrajahlawat
Champion
Champion

something like:



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

jagan
Partner
Partner

Hi,

Try like this

LOAD

*,

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

FROm DataSource;


Hope this helps you.


Regards,

jagan.

tresesco
MVP
MVP

Day(Monthend(Today()))