topic Change YearMonth or Month from numeric to Text Value in QlikView https://community.qlik.com/t5/QlikView/Change-YearMonth-or-Month-from-numeric-to-Text-Value/m-p/351363#M1175491 <HTML><HEAD></HEAD><BODY><P>how do I change YearMonth (201105) or Month (5) from a numeric to a text value?</P><P></P><P>I'm trying to do it in the following expression</P><P></P><P>Max(YearMonth)</P><P>Max(Month)</P></BODY></HTML> Tue, 15 May 2012 06:35:33 GMT Anonymous 2012-05-15T06:35:33Z Change YearMonth or Month from numeric to Text Value https://community.qlik.com/t5/QlikView/Change-YearMonth-or-Month-from-numeric-to-Text-Value/m-p/351363#M1175491 <HTML><HEAD></HEAD><BODY><P>how do I change YearMonth (201105) or Month (5) from a numeric to a text value?</P><P></P><P>I'm trying to do it in the following expression</P><P></P><P>Max(YearMonth)</P><P>Max(Month)</P></BODY></HTML> Tue, 15 May 2012 06:35:33 GMT https://community.qlik.com/t5/QlikView/Change-YearMonth-or-Month-from-numeric-to-Text-Value/m-p/351363#M1175491 Anonymous 2012-05-15T06:35:33Z Re: Change YearMonth or Month from numeric to Text Value https://community.qlik.com/t5/QlikView/Change-YearMonth-or-Month-from-numeric-to-Text-Value/m-p/351364#M1175492 <HTML><HEAD></HEAD><BODY><P>Try something like this (un-tested):</P><P></P><P>Date(makedate(left(YEARMONTH,4),right(YEARMONTH,2)),'MMMYY')</P></BODY></HTML> Tue, 15 May 2012 20:09:39 GMT https://community.qlik.com/t5/QlikView/Change-YearMonth-or-Month-from-numeric-to-Text-Value/m-p/351364#M1175492 goldnejea8 2012-05-15T20:09:39Z Re: Change YearMonth or Month from numeric to Text Value https://community.qlik.com/t5/QlikView/Change-YearMonth-or-Month-from-numeric-to-Text-Value/m-p/351365#M1175493 <HTML><HEAD></HEAD><BODY><P> You could also try Date(Date#(YearMonth,'YYYYMM')) for YearMonth, the Date# function is used to tell QlikView the current format of the value and Date (without #) to format it in another way.</P></BODY></HTML> Tue, 15 May 2012 20:45:49 GMT https://community.qlik.com/t5/QlikView/Change-YearMonth-or-Month-from-numeric-to-Text-Value/m-p/351365#M1175493 cesaraccardi 2012-05-15T20:45:49Z