Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
atlantis_shahri
Contributor III
Contributor III

Max Purchase Order Date Material Price

I want to find out the last purchase date material price. I can easily find out the max purchase date but I need the material price of that date too.

1. Max Purchase Date=Max(Order_Date_po)

2. Max date Price=Only({$<Order_Date_po={"=Max(Order_Date_po)"}>}Price_Unit)

Untitled.jpg

If I add Po No then all the entries are shown. But that doesn't serve my purpose.

Untitled1.jpgUntitled1.jpg

Please help. Thanks in advance.

1 Solution

Accepted Solutions
sunny_talwar

May be this

FirstSortedValue(Price_Unit, -Order_Date_po)

View solution in original post

1 Reply
sunny_talwar

May be this

FirstSortedValue(Price_Unit, -Order_Date_po)

View solution in original post