Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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