topic Format Date as Monthname in QlikView

Format Date as Monthname

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: Format Date as Monthname

swuehl — Sat, 11 Nov 2017 12:53:03 GMT

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'

Re: Format Date as Monthname

swuehl — Sat, 11 Nov 2017 12:56:50 GMT

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.

Re: Format Date as Monthname

Anonymous — Sun, 12 Nov 2017 05:46:58 GMT

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.

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

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

Thanks for you help

Neil