Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.


Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Quantity of the last date in different dimensions


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.


1 Reply
Honored Contributor II

Re: Quantity of the last date in different dimensions

Try this: firstsortedvalue(StockHis.QtyAfter,-num#(replace(StockKey,Company,'')))



Community Browser