Calculated Dimension - Why isn't in working?

[Anonymous]

I have a simple chart where the X-axis is a date, the first day of a month. As long as I just let the date field appear as 2/1/2010 everything is fine. But I want it to display as "Feb 2010" using =date#(Change.Implementation Month,'MMM YYYY'). But all I get is Error in Calculated Dimension.

[disqr_rm]

Hi Brian, try putting square brackets around your field. Rest depends on what content you have in that field.

date#([Change.Implementation Month],'MMM YYYY')

Hope this helps.

[#3]

Hi Brian,

if QlikView recognised your field as a date you can also use:

MonthName(YourDateField)

Good luck!

Rainer