Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

tmumaw
Not applicable

Previous Year

This statement gives me current year, but I need previous year.  What do I need to change to get it.

Thanks

Date((monthname(Today())-1),'MMM YYYY')

1 Solution

Accepted Solutions
rajni_batra
Not applicable

Re: Previous Year

Date((monthname(AddYears(Today(),-1))),'MMM YYYY') 

or

Date((monthname(AddMonths(Today(),-12))),'MMM YYYY') 

3 Replies
rajni_batra
Not applicable

Re: Previous Year

Date((monthname(AddYears(Today(),-1))),'MMM YYYY') 

or

Date((monthname(AddMonths(Today(),-12))),'MMM YYYY') 

israrkhan
Not applicable

Re: Previous Year

Like below

=Year(Date)-1 OR

=Date(Year(Today())-1, 'YYYY')  OR


=Year(Date(Year(Today()))-1 )


tmumaw
Not applicable

Re: Previous Year

Thanks Rajni.....just what I needed.