nth Value from the list box

[miranrai]

Hi,

I have requirement to create a straight table based on date range dependent on value selected from the DATE listbox & the nth previous date from selected date in listbox. I have attached sample qvw. Thank you for help.

[tresB · Accepted solution]

Define a variable like:

vNthDate =Date(Max({<DATE={"<=$(=Date(Max(DATE)))"}>}DATE,vNthRow))

Then expression like:

SUM({<DATE={">=$(vNthDate) <=$(=Date(Max(DATE)))"},STATUS={'F'}>}VALUE)

[miranrai]

When we look too hard we miss out whats most easy way.! I racked all rank, aggregate & it was most simple max function. Thank you so much Tresco