This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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
View solution in original post
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,...