Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Date format in Header of Table

I am trying to get the header in the table to say Mar 2013, but when I use the following formula I get the date number.

$(=max(MonthName(CalendarWrittenDate))) Sales

See attachment

1 Solution

Accepted Solutions

Re: Date format in Header of Table

You have to use in reverse

$(=MonthName(max(CalendarWrittenDate))) Sales

Max() return numbers only.

Hope it helps

Celambarasan

2 Replies

Re: Date format in Header of Table

You have to use in reverse

$(=MonthName(max(CalendarWrittenDate))) Sales

Max() return numbers only.

Hope it helps

Celambarasan

Not applicable

Re: Date format in Header of Table

Worked Great, THANKS