Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Format Date as Monthname

Hi there

Its so frustrating being a newbie sometimes. This seems so simple and yet...

I want to show these 2 dates as months (July and October) but when I use the function =Monthname([Reporting Date]) I get what is in the second image.

I'm loading the data from Excel and in Excel the date columns are formatted as dates

I must be missing something really simple?

2017-11-11_203925.jpg

2017-11-11_204011.jpg

Tags (1)
3 Replies
Highlighted
MVP
MVP

Re: Format Date as Monthname

What do you see if you convert this chart to a table chart?

Do you see a Monthname?

If not, check that your default date format at the top of your script is set to 'DD/MM/YYYY'

see also

Why don’t my dates work?

Get the Dates Right

Highlighted
MVP
MVP

Re: Format Date as Monthname

And if you do see a Montname values in a table chart, then try creating the values in your script:

LOAD

     [Reporting Date],

     MonthName([Reporting Date]) as [Reporting Month],

     ...

and then use the new field in your chart.

Highlighted
Contributor III
Contributor III

Re: Format Date as Monthname

Hi Stefan

Unfortunately that load script didn't work for me. The date format setting was correct and the text box you suggested, ended up being blank.

I think I found the solution... I had to create a simple calendar table and join that in to the main table.

2017-11-12_164507.jpg

I then use this expression in the chart and this worked for me.

=[Reporting Date-Last Day.autoCalendar.YearMonth]

Thanks for you help

Neil