topic Pick out max date from month in QlikView

Pick out max date from month

Wed, 13 Apr 2011 11:17:50 GMT

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!

Pick out max date from month

Wed, 13 Apr 2011 11:44:42 GMT

Hi,

You can use the function

MonthsEnd

Kind regards,

Martijn

Pick out max date from month

IAMDV — Wed, 13 Apr 2011 11:45:36 GMT

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!

Pick out max date from month

IAMDV — Wed, 13 Apr 2011 11:59:06 GMT

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!

Pick out max date from month

Thu, 14 Apr 2011 16:20:16 GMT

Thanks, it works!

Pick out max date from month

Fri, 15 Apr 2011 07:52:09 GMT

Good to hear that!

Could you "click" this question as answered?

Kind Regards,

Martijn