Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

MonthYear Displayed as YYYY-MM-DD 00:00:00

Hello All,

I have a graph like so:

Screenshot (50).png

As you can see, MonthYear is displayed as YYYY-MM-DD 00:00:00. Ideally, I'd like it to be displayed as MM-YYYY. How would I do that?


Best,

Alison 

1 Solution

Accepted Solutions
Not applicable
Author

Hi Sunny,

I have gotten it to work, thank you for mentioning about the continuous axis.


Appearance -> And I unchecked 'Use Continuous Scale'

View solution in original post

9 Replies
sunny_talwar

May be use a calculated dimension

Date(MonthYear, 'MM-YYYY')

Not applicable
Author

Hi Sunny,

Thank you for your suggestion but sadly in remains the same.

Anonymous
Not applicable
Author

Do that in the data load editor Date(MonthYear, 'MM-YYYY')

Not applicable
Author

Hello Kelly,

I have a Master Calendar that looks like so:

Screenshot (51).png

Please tell me where I should put the code

sunny_talwar

Are you using Continuous axis?

Not applicable
Author

Hi Sunny,

Yes, I am

sunny_talwar

I know you can handle this in QlikView, but since I have very limited knowledge of Qlik Sense, I don't really know if this is possible or not.... If you can share the sample, then I can give it a shot.... But if you want to try on your end, look for a way to format the continuous dimension (if at all it is possible)

Anonymous
Not applicable
Author

What is the table that is pictured in the chart above? That table would need to be configured and looking at your calendar you want 'MMM-YYYY' not 'MM-YYYY'.

Not applicable
Author

Hi Sunny,

I have gotten it to work, thank you for mentioning about the continuous axis.


Appearance -> And I unchecked 'Use Continuous Scale'