Discussion board where members can get started with QlikView.
How can I take a YearMonthId = 201501 and convert it to the month of Jan?
Go to Solution.
Do you mean only the Month() without Year info?=>
View solution in original post
I separated it out to the last 2 characters using right(YearMonthId, 2) now how do I convert this 01 to January?
Thank you. Much appreciated. Serious brainfart on that one.
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.
converting 01 to January could be done like:
hope this helps