topic max date in QlikView

max date

Thu, 06 Jun 2013 11:15:00 GMT

hello,

I have a table Doc which contains the history of stock

Doc:

nameProduct,

movementDate,

quantity,

unitPrice,

I want to get the quantity of the last movement of each product in a table

I tried this expression : sum({$<Doc.movementDate={$(=Max(Doc.movementDate))}>}Doc.quantity)

but it affects the same date for all product :s

help plz

sushil353 — Thu, 06 Jun 2013 11:20:28 GMT

try this:

firstsortedvalue(Doc.quantity,-Doc.movementDate)

Thu, 06 Jun 2013 11:38:03 GMT

thank u so much

Thu, 06 Jun 2013 11:46:06 GMT

but I don't know if it gives the the quantity of the max(mouvementDate), I mean the recent one.

Anonymous — Thu, 06 Jun 2013 14:12:08 GMT

hello,

Try this

sum({$<Doc.movementDate={'<=$(=Max(Doc.movementDate))'}>}Doc.quantity)