topic qty for max date <= end date variable in QlikView

qty for max date <= end date variable

Wed, 09 May 2012 19:15:11 GMT

help with the below set analysis. i'm looking for the qty for the max date, less than or equal to the user defined date. i'm using a end date variable as the user defined date.

the qvw doesn't seem to like the second {, its red underlined.

sum ({$<max(inv_cal_dt)={$(=$(EndDate))

Thanks,

Sara

qty for max date <= end date variable

Wed, 09 May 2012 19:22:00 GMT

SUM({<inv_cal_dt={$(=Max(EndDate))}>}VALOR)

qty for max date <= end date variable

Wed, 09 May 2012 19:29:52 GMT

tried this, did not work. it still doesnt like the second {

sum

({$<max(inv_cal_dt)={$(=$(EndDate))}>}oh_qty

Re: qty for max date <= end date variable

Wed, 09 May 2012 19:59:52 GMT

I do not think you can use max() in the first part of set analysis. I believe it needs to be a field.

You can set this as a new field in the script using a resident load with a group by function.

qty for max date <= end date variable

Thu, 10 May 2012 17:10:47 GMT

I was given this, and it works!!

FirstSortedValue({$<inv_cal_dt={"<=$(EndDate)"}>} oh_qty, -inv_cal_dt)