Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
jonbmorrison
New 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

Re: Displaying month in long text

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

Re: Displaying month in long text

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