topic Re: Convert 201501 to Jan in QlikView

Convert 201501 to Jan

Fri, 16 Jan 2015 18:42:47 GMT

How can I take a YearMonthId = 201501 and convert it to the month of Jan?

Thanks,

Joe

Re: Convert 201501 to Jan

jonasheisterkam — Fri, 16 Jan 2015 18:49:52 GMT

Do you mean only the Month() without Year info?=>

=month(date#(201501,'YYYYMM'))

Re: Convert 201501 to Jan

Fri, 16 Jan 2015 18:49:53 GMT

I separated it out to the last 2 characters using right(YearMonthId, 2) now how do I convert this 01 to January?

Re: Convert 201501 to Jan

Fri, 16 Jan 2015 18:51:41 GMT

Thank you. Much appreciated. Serious brainfart on that one.

Joe

Re: Convert 201501 to Jan

jonasheisterkam — Fri, 16 Jan 2015 19:00:26 GMT

If you have only the number you need creation of date/timestamp if you want to use month(). You can create string and use functions like date#() oder you use makedate() with a fix year.

You can also use the defined Monthnames from the beginning of youre Skript, generatet by qlick.

=subfield(MonthNames,';',01)

Re: Convert 201501 to Jan

MarcoWedel — Fri, 16 Jan 2015 23:38:09 GMT

converting 01 to January could be done like:

=Month(Date#('01','MM'))

hope this helps

regards

Marco