Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Converting Period # into MonthNames

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

1 Solution

Accepted Solutions
nagaiank
Valued Contributor III

Re: Converting Period # into MonthNames

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.

4 Replies
Not applicable

Converting Period # into MonthNames

Hi

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

];

Not applicable

Converting Period # into MonthNames

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?

nagaiank
Valued Contributor III

Re: Converting Period # into MonthNames

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.

Not applicable

Re: Converting Period # into MonthNames

Thanks for your help really appreciate it.