Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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
Champion III
Champion III

Hi,

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

Rgds

Anand