Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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

script;How can I get only the last transaction

Dear QV-Users,

I have 2 tabels. One with the transactions in a period and the ohter table is a MASTER FILE with the StockNo. I would like to write a script that will show me only the last transaction date for each StockNo. My tabels are:

Transactions:

  • StockNo
  • ReceivingDate  (format is YYYYMMDD; for today it will be "20110919")
  • Account
  • AccountCr

MasterFileStock:

  • StockNo
  • UnitCost
  • QuantityOnHand

Could someone tell me what the best approach will be for this case?

Regards,

Aissam

1 Solution

Accepted Solutions
Not applicable

script;How can I get only the last transaction

Hi,

u can calculate the max reciving date from the first table then filter the second tabel with a left join with the first..

I hope to be clear.

C u,

Stefano.

2 Replies
Not applicable

script;How can I get only the last transaction

Hi,

u can calculate the max reciving date from the first table then filter the second tabel with a left join with the first..

I hope to be clear.

C u,

Stefano.

Not applicable

Re: script;How can I get only the last transaction

Try if u like this.

C u,

Stefano.