Months not displaying correctly in bar chart

[#1]

Hi,

I have a simple chart that I'm attempting to create that will show the Total Number of Sales per month.

I have one spreadsheet that I have imported into my Qlikview application, I have the Sale Dates listed as 'Jan-09', 'Feb-09', 'Mar-09'… and so on. (see attached graphic)

When I created a bar chart, the months (listed on the x-axis of the bar chart) are listed as numbers (i.e. 39814, 39912, etc.)

Would anyone know why they are not displaying correctly?

Any insight would be highly appreciated. I have a feeling that it's a very simple fix, but for some reason I'm having an issue.

Thanks.

[#2]

It looks like it is picking up the integer date values from Excel. Try this in your LOAD statement:

date([Open Date], 'mm/dd/yyyy')

Sue

[Anonymous · Accepted solution]

Or, simply format the dimension in the Number tab in chart properties. You can use MMM-YY to get JAn-09.

[#4]

I thought the Number tab only let you modify the format of Expressions, not Dimensions?

[Anonymous]

Sue,
I think you're right. Dimesions can be formatted in the Document properties, Number tab.
Thanks

[#6]

Ooooh, I was not aware of that! (Learn something new every day and occasionally two things!)

Thank you!!!

Sue

[Anonymous]

"Learn something new every day and occasionally two things!" - so do I

[#8]

Excellent! This worked perfectly. Thank you SO much for your help.