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

[Dayna]

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

[Miguel_Angel_Baeyens]

Dayna,

I'll try it. Anyway, wouldn't it be easier to create a text and number month dimension in your table instead of doing in the chart as calculated dimension? I don't know how it is performing in your computer, but it's less than 350K records and charts takes longer than 3 secs to render in my computer...

I'll do the same with the Year, and probably better, bulding a master calendar based on yoru fact table. Check this application on how to do that.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica