Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis - How to Select Max "Latest Date"

I have a set analysis where I am trying to include the latest date from the date dimension.  How would I include to select the max date?

Sum({$<Division = {WAS}=>} DeclinedCount)

1 Solution

Accepted Solutions
Not applicable
Author

Date={'$(=Max(Date))'}

Sum({$<Division = {WAS}, Date={'$(=Max(Date))'}>} DeclinedCount)

View solution in original post

2 Replies
Not applicable
Author

Date={'$(=Max(Date))'}

Sum({$<Division = {WAS}, Date={'$(=Max(Date))'}>} DeclinedCount)

phcaptjim
Creator
Creator

This logic works until you select a month, for example May 2013.  I'm guessing QVW does not know which day in May to match to and therefore does not display anything.  How can we tweak this so it will work whether the user has selected a month, quarter, or day?

Thanks!