Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

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

Hello ,

You can use 

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

View solution in original post

3 Replies
Highlighted
Master III
Master III

try this in your set analysis

MonthEnd(date(Today())-1)

Highlighted
Creator II
Creator II

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

Hello ,

You can use 

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

View solution in original post