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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
mahitham
Creator II
Creator II

Max(MonthYear)-2 help

Hi Experts,

Can any one please help me to apply  jan 2019 as default selection in the below extension.

I have tried like Max(MonthYear)-2 but its not showing Jan 2019 as default month. Please help me on this.

Thanks in advance

monthyear-2.png

1 Solution

Accepted Solutions
sunny_talwar

How did you create the Month field in the script? May be one of these

=Date(MonthStart(Max(MonthYear), -2), 'MMM YYYY')

or

=MonthName(MonthStart(Max(MonthYear), -2))

View solution in original post

1 Reply
sunny_talwar

How did you create the Month field in the script? May be one of these

=Date(MonthStart(Max(MonthYear), -2), 'MMM YYYY')

or

=MonthName(MonthStart(Max(MonthYear), -2))