Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
jonbmorrison
Contributor III
Contributor III

Displaying month in long text

In a chart title I have been able to display the max date of data loaded

for example 7/31/2019

I have also been able to display Jul 2019 and Jul.

I want July - the full month name.   (so when September rolls around the title would show September not Sep)

variations of the following in my title expression

Month(MonthName(max([MonthEnd Date])))  - gives me Jul

MonthName(max([MonthEnd Date])) - give Jul 2019

and max([MonthEnd Date])  returns 7/31/2019.

I've tried some others without success - any thoughts welcomed.

 

Labels (4)
1 Solution

Accepted Solutions
sunny_talwar

May be try this

Date(MonthName(Max([MonthEnd Date])), 'MMMM') will display July

Date(MonthName(Max([MonthEnd Date])), 'MMMM YYYY') will display July 2019

View solution in original post

1 Reply
sunny_talwar

May be try this

Date(MonthName(Max([MonthEnd Date])), 'MMMM') will display July

Date(MonthName(Max([MonthEnd Date])), 'MMMM YYYY') will display July 2019

View solution in original post