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: 
Not applicable

Pick out max date from month

Hi,

So this is my case:

I have a calendar_date which is based on a start date and until a maximum date. I have divided this calendar_date to calendar_year/week/month. What I want to accomplish is by choosing a calendar month and year I want the max date of that YearMonth. How should I do to accomplish that?

Ex: calendar_month = june & calendar_year = 2010 -> max calendar_date = 2010-06-30

Thanks!

1 Solution

Accepted Solutions
Not applicable
Author

Hi,

You can use the function

MonthsEnd



Kind regards,

Martijn

View solution in original post

5 Replies
Not applicable
Author

Hi,

You can use the function

MonthsEnd



Kind regards,

Martijn

IAMDV
Master II
Master II

Hi,

You need to use Set Analysis to get this working. Please can you post the QV document with some sample data? That will be really helpful for one of us to provide the solution.

Cheers!

IAMDV
Master II
Master II

Please ignore my previous post. I was thinking of calculating the Max Date based on the Current data. I mean if you 2011 April data loaded in your document. QV has to identify the Max Year, Max Month & Max Date without making selections on the calendar.

However, if you are making selections on Month & Year then please follow Martijn's solution. Yes is absolutely right (with minor typo error). Here is the syntax..

=MonthEnd(Date)

Cheers!

Not applicable
Author

Thanks, it works!

Not applicable
Author

Good to hear that!

Could you "click" this question as answered?

Kind Regards,

Martijn