topic Set Analysis - How to Select Max "Latest Date" in QlikView

Set Analysis - How to Select Max "Latest Date"

Fri, 21 Oct 2011 19:07:30 GMT

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)

Set Analysis - How to Select Max "Latest Date"

Fri, 21 Oct 2011 20:22:00 GMT

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

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

Re: Set Analysis - How to Select Max "Latest Date"

phcaptjim — Tue, 04 Jun 2013 11:55:24 GMT

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!