10 Replies Latest reply: Oct 14, 2011 5:49 AM by Miguel Angel Baeyens de Arce RSS

    Representing a date as a month - but keep formatting when exported to excel

    Dayna Litherland

      Hello All,

       

      I don't know if its the version of Excel we are running, but on one of my QlikView reports when you export the data the month comes out as 1,2,3.. etc.. Rather than Jan, Feb. 

       

      My expression is simply =month(date), what I found, is that I can do a =text(month(date)) and it'll keep the representation when I export it - but then the data isn't sorted correctly, so rather in ascending month (Jan-Dec) it's all over the place.

       

      Unfortunately I can't do this in my load script, as one is slightly more complex, so I have to do it in my expression.

       

      Has anyone got any ideas?

       

      Many thanks for your help!

       

      Kind Regards,

      Dayna