Discussion board where members can get started with QlikView.
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?
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'
Why don’t my dates work?
Get the Dates Right
And if you do see a Montname values in a table chart, then try creating the values in your script:
MonthName([Reporting Date]) as [Reporting Month],
and then use the new field in your chart.
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