Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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
];
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?
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.
Thanks for your help really appreciate it.