Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

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

Hello,

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.

Thx!!

1 Reply
vgutkovsky
Honored Contributor II

Re: Quantity of the last date in different dimensions

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

Regards,

Vlad

Community Browser