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
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.
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..
