topic Return text value for Max(Month) in QlikView

Return text value for Max(Month)

stjernvd — Thu, 12 Nov 2015 16:06:19 GMT

Hey,

I would like to do this:

Date(Date#([Date],'DD-MMM-YY'),'DD MMM YYYY') as Day,
Month(Date(Date#([Date],'DD-MMM-YY'),'DD MM YYYY') ) as Month,
Year(Date(Date#([Date],'DD-MMM-YY'),'DD MM YYYY')) as Year

My months are May, June, and July.

When I do Max(Month), I get 7, how do I get it to return Jul?

Re: Return text value for Max(Month)

Peter_Cammaert — Thu, 12 Nov 2015 16:15:07 GMT

Something like this?

=Date(Max(TradeMonth), 'MMM')

Re: Return text value for Max(Month)

alexandros17 — Thu, 12 Nov 2015 16:15:56 GMT

SubField(MonthNames,';',Max(TradeMonth))

let me know

Re: Return text value for Max(Month)

swuehl — Thu, 12 Nov 2015 16:17:45 GMT

=Month(Max(TradeDay))

Re: Return text value for Max(Month)

Peter_Cammaert — Thu, 12 Nov 2015 16:19:29 GMT

Or this?

=Capitalize(SubField(MonthNames, ';', Max(TradeMonth)))

Re: Return text value for Max(Month)

swuehl — Thu, 12 Nov 2015 16:30:02 GMT

BTW, there is no need to format a date value using Date() function if you want to further transform it to month or year value:

Month(Date#([TradeDate],'DD-MMM-YY') ) as TradeMonth,
Year(Date#([TradeDate],'DD-MMM-YY') ) as TradeYear

should be enough.

Re: Return text value for Max(Month)

Peter_Cammaert — Thu, 12 Nov 2015 18:23:34 GMT

Please note that Stefan's solution returns the Month of the latest date and not the Maximum Month overall (as you seemed to require)

Best,

Peter