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: 
helen_pip
Creator III
Creator III

Set analysis with Max(Month)

Hello

I am using a master calender with my entire dataset, but want to show just the max(MonthYear) for just one particulare data set

I have tried a variation using set analysis, but have not quite got the code right yet, could someone kindly help me with the correct code

  {<data_source={'18_Wks_Admitted'}>}Max(MonthYear),'MMM YYYY')

Kind Regards

Helen

1 Solution

Accepted Solutions
helen_pip
Creator III
Creator III
Author

Hello

Problem solved

 

=

Max({<data_source={'18_Weeks_Admitted'}>}MonthYear)

View solution in original post

2 Replies
helen_pip
Creator III
Creator III
Author

Hello

Problem solved

 

=

Max({<data_source={'18_Weeks_Admitted'}>}MonthYear)

Not applicable

Like this

=Sum({<MonthYear={$(=Max(MonthYear))}>}Sales)

Hope it helps you..!