Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

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

Hi all please help any one in this issue.

7 Replies
MVP
MVP

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

May be this:

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

Not applicable

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

thanks for responding sunny.

Not applicable

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

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

MVP
MVP

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

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)

MVP
MVP

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

Look at the attached image and the qvw:

Capture.PNG

Not applicable

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

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

MVP
MVP

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

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

Community Browser