topic Converting Period # into MonthNames in QlikView

Converting Period # into MonthNames

Fri, 17 Jun 2011 13:39:19 GMT

Hi I'm new to qlikview and need to convert a fiscal period number (my field) into text a MonthNames.

So my document has the field period, and within it are simple 1,2,3....etc. with 1 representing feb. because its the start of the fiscal year for our company. How would I go about converting the 1-Feb, 2-Mar., 3-April, etc. and continually update including reset once the fiscal year resets?

Thanks for all your help,

alex

Converting Period # into MonthNames

Fri, 17 Jun 2011 16:37:49 GMT

Create a inline and join it with MonthNo

LOAD * INLINE [

MonthNo, Name

1, Feb

2, Mar

3, Apr

4, May

5, Jun

6, Jul

7, Aug

8, Sep

9, Oct

10, Nov

11, Dec

12, Jan

];

Converting Period # into MonthNames

Fri, 17 Jun 2011 17:38:23 GMT

Thanks for the help, but all this did was expand my periods from 5 to 12, no text. Does it help/change anything if i tell you my original load from excel is called periods, and my set=MonthNames?

Re: Converting Period # into MonthNames

nagaiank — Fri, 17 Jun 2011 17:59:21 GMT

You may use the 'dual' function to associate a field to a number and string values.

In the attached example, I have loaded Period data as number and displayed it as a string.

Hope this helps.

Re: Converting Period # into MonthNames

Fri, 17 Jun 2011 20:01:25 GMT

Thanks for your help really appreciate it.