Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Batman_love_bats
Contributor
Contributor

Change date format to month and year from a date

I have a date column say - 'date_column' consists of date like  - 02/19/2022 and I just want to show X axis to be like  - Feb 2022, I can extract month like  - Month(date_column) but how to show year as well as month. Please help to get my desired result.

Labels (2)
4 Replies
Or
MVP
MVP

MonthName(date_column) should do the trick.

Batman_love_bats
Contributor
Contributor
Author

Hi for bar chart its working, but I have a combo chart and its not working there, it displays dates as it is, please help

Or
MVP
MVP

MonthName() always takes a date and churns out a month and year (with the underlying value of the first of that month). This isn't related to the chart type...

Batman_love_bats
Contributor
Contributor
Author

sir just thought to share this information - 
1 - when I am using MonthName then only bar chart works properly, but combo (line chart) is not working
2 - when I am using Month(date_column) &' '& Year(date_column) then this works perfect for both the cases, but only in combo chart the sorting order gets changes
I just wanted to know what the reason behind this, just for learning purpose