topic Re: nth Value from the list box in QlikView

nth Value from the list box

miranrai — Wed, 16 May 2018 06:32:58 GMT

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.

Re: nth Value from the list box

tresB — Wed, 16 May 2018 06:56:08 GMT

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)

Re: nth Value from the list box

miranrai — Wed, 16 May 2018 08:44:52 GMT

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