Evaluating user selected dates, and particularly "2010/12" format

[#1]

Hi,

Am trying to evaluate current user date selection.

If multiple years have been selected, I am able to evaluate which is the latest date using the "max" function

Am trying to do the same using months, which appear in the current database as "2010/12" or "2010/01". Is it possible to retain these values, but still apply the "max" function?

Please advise,

Kind regards,

Rich

[Miguel_Angel_Baeyens · Accepted solution]

Hello Rich,

Dates are numeric values for QlikView, so something like

=Month(Date#('2010/12', 'YYYY/MM'))

will return the month. Now you have the months you can get the maximum value.

Anyway, I'd suggest to create a master calendar so you can have as many dimensions as you want (year, month, week, quarter, etc.)

Hope that helps

[#3]

Hi,

Right solutuion is the response from Miguel Angel Baeyens,

because here you are crunching with real date.

You cat try this: =MaxString(CalYearMonth)

Ciao