Discussion board where members can get started with QlikView.
I have a stock values and i want to get the last value of stock, for every date,Prod and Place
i have a lot of values for each date, product and place, and i want to show only the last one(for this combination)
i want to create a table with this information
attached the excel
thanks a lot
Go to Solution.
May be this
Sum(Aggr(If(Date + Time = Max(TOTAL <Prod, Place, Date> Aggr(Date + Time, Prod, Place, Date, Time)), Sum(Stock)), Prod, Place, Date, Time))
Note : In Script LOAD
...,Time(Time) as Time,...