Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
ali_hijazi
Partner - Master II
Partner - Master II

get the number of days in a selected month

Hello

is there a way to calculate the number of days in a selected month?

I mean if I select Feb -> 28

January->31 ....

I can walk on water when it freezes
3 Replies
Not applicable

Hi,

i don't know is there is a specific function, otherwise u can use something like day(monthsend(..))

C u,

Stefano

Anonymous
Not applicable

If you just want a list of the months with the numbers you can (assuming you have a monthfield) just set your Month as a dimension and use 'max(Day(datum))' as your expression.

its_anandrjs

Hi,

If you have Date field so use Max(Day(Date field))

Rgds

Anand