Discussion board where members can get started with QlikView.
Im struggeling with a expression.
I have to find 2 things.
The date of the last record on three dimensions, this one a managed to get.
The second thing is the quantity of this record. If there are multiple records then it has to be the last one.
This seems simple, but I can't figure it out.
I've added a sample, with some comments. I hope you guys can find it.
Try this: firstsortedvalue(StockHis.QtyAfter,-num#(replace(StockKey,Company,'')))