Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

mahitham
Contributor

how to get last date of most recent completed month

Hi Experts,

Can any please help me to obtain last date of most recent completed month dynamically.

For example we are in April last date of most recent completed month Is 31/03/2019. How to get this value in field.

Thanks in advance.

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Re: how to get last date of most recent completed month

Hello ,

You can use 

Addmonths(Monthend(max(your fielddate)),-1)

3 Replies
arulsettu
Honored Contributor III

Re: how to get last date of most recent completed month

try this in your set analysis

MonthEnd(date(Today())-1)

mahitham
Contributor

Re: how to get last date of most recent completed month

hi @arulsettu 

Getting 30/04/2019 as output. But expected output is always need to show the  last date of last completed month I,e, 31/03/2019

Highlighted
Partner
Partner

Re: how to get last date of most recent completed month

Hello ,

You can use 

Addmonths(Monthend(max(your fielddate)),-1)