Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to write expression for max date of previous fiscal month ?

Hi all please help any one in this issue.

7 Replies
sunny_talwar

May be this:

=Date(MonthEnd(AddMonths(Max(DateField), -1)))

Not applicable
Author

thanks for responding sunny.

Not applicable
Author

sunny, could u please attach any example for regarding this.

sunny_talwar

Try this in a text box object:

=Date(MonthEnd(AddMonths(Today(), -1))) -> this expression should give you 07/31/2015 (Last day of previous month)

sunny_talwar

Look at the attached image and the qvw:

Capture.PNG

Not applicable
Author

good but i need expression for max date of previous fiscal week in set analysis sunny.

sunny_talwar

Can you share some sample data which is representative of your actual data.