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: 
Gowtham174
Creator
Creator

Max Month end Date

Hi all,

Can you please help me to get the Max Month end date for the below set of data.

  

REPORT_DATEMonth
01/07/2018Jul

02/07/2018

-

Jul

-

24/07/2018Jul
25/07/2018Jul
26/07/2018Jul

I tried with below expression its giving me 31st Jul.

I need 26th Jul

Date(MonthEnd(Max(REPORT_DATE)),'YYYY-MM-DD')

Thanks,

Gowtham

1 Solution

Accepted Solutions
andrey_krylov
Specialist
Specialist

Hi, maybe without MonthEnd()

Date(Max(REPORT_DATE),'YYYY-MM-DD')

View solution in original post

5 Replies
andrey_krylov
Specialist
Specialist

Hi, maybe without MonthEnd()

Date(Max(REPORT_DATE),'YYYY-MM-DD')

rakeshkumar1890
Creator
Creator

use this

Date(Max(REPORT_DATE),'YYYY-MM-DD')

Gowtham174
Creator
Creator
Author

I need to show month end if other month is filter

for example: if i select month Jun i need to see 30th Jun.

Not Max date so above expression will give me max date for all the month

igdrazil
Creator III
Creator III

Hi,

as soon as you select a month, you should see the max date of the selected month.

Regards

Chris

justinphamvn
Creator II
Creator II

Hi,

Try it

***Using Chart, Table:

Date(Aggr(Max(REPORT_DATE),Month),'YYYY-MM-DD')

***Using KPI:


Date(Max(REPORT_DATE),'YYYY-MM-DD')

Hope this help,

Justin.