topic Re: Set Analysis max date in QlikView

Set Analysis max date

Thu, 06 Dec 2012 12:50:49 GMT

Good day

There is a need to calculate the stock at the end of the month

Table_stock:

Calendar table:

Pivot Table

Goods	Month	Stock qty
1	november	2
1	December	3

I tried a set analysis and if

Sum({<Date={'$(=Max(Date))'}>} Stock)

Aggr(Sum({<Date={'$(=Max(Date))'}>} Stock),Goods,Month)

Sum({<Date={'$(=Aggr(Max(Date),Month))'}>} Stock)

Sum(if(Date=Max(Total Date),Stock))

CELAMBARASAN — Thu, 06 Dec 2012 12:57:01 GMT

Try with FirstSortedValue functionality

=FirstSortedValue(Stock, -num(Date))

Hope it helps

Thu, 06 Dec 2012 12:58:11 GMT

Thanks for the answer, but it does not work for me

marcelo_7 — Mon, 01 Jul 2013 14:45:54 GMT

This solved my similar problem! Thanks!