4 Replies Latest reply: Jun 17, 2011 4:01 PM by afronczek RSS

    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