topic Re: Converting a month.num to month.text in QlikView

Converting a month.num to month.text

Tue, 09 Jul 2013 17:07:16 GMT

Can anyone help!

I want to load a date field which is in the excel file as "period" in the following concatenated format YYYYMM eg. 201306

I've split this into Month and Year as follows:

LOAD

left(PERIOD, 4) AS "Year",

right(PERIOD, 2) AS "Month",

How do I convert the numeric month into a text month within the load statement

does a switch case type statement work or is there a function to convert this?

Please give examples!

jerem1234 — Tue, 09 Jul 2013 17:25:52 GMT

Maybe try something like:

Year(Date#(PERIOD, 'YYYYMM')) as "Year"

e.g. for 201306 will return "2013"

Month(Date#(PERIOD, 'YYYYMM')) as "Month"

e.g. for 201306 will return "Jun"

Wed, 10 Jul 2013 08:15:18 GMT

Excellent, that worked perfectly. My thoughts were heading in the right direction but weren't concluding in anything as efficient as this.

Thanks alot for your help!