Is there a way to displaying most recent date for each item

[#1]

Hi, I'm new to using qlikview. I created a straight table with dimensions: Product, Unit Cost, and Last Sold Date. I have products (A, B, C, and so on) with condition codes (00, 01, 02) that I am selling.

Product	Unit Cost	Last Sold Date
A-00	$7.99	7/15/2015
A-00	$7.99	7/20/2015
A-01	$6.99	7/5/2015
B-02	$4.99	7/18/2015
B-02	$4.99	6/30/2015
B-02	$4.99	6/22/2015
C-00	$5.99	7/1/2015
C-00	$5.99	6/15/2015

Is there a way for me to show the most recent item that was sold for each product with each condition code. For example, I only want the following items to be displayed:

• A-00 (7/20/2015)
• A-01 (7/5/2015)
• B-02 (7/18/2015)
• C-00 (7/1/2015)

Thanks

[sunny_talwar]

Try a straight table with these:

Dimension: Product

Expression: FirstSortedValue([Last Sold Date], -[Last Sold Date])

[marcus_sommer]

You could try: firstsortedvalue([Last Sold Date], -[Last Sold Date])

- Marcus

[#4 · Accepted solution]

Thank you so much Sunny, this is just what I needed.

[#5]

Thank you so much Marcus for posting up this formula.

[sunny_talwar]

No problem. I am glad I was able to help.

If you got what you were looking for, please close this thread by marking the correct answer.

Best,

Sunny

[#7]

Okay, just marked it as the correct answer. If I want to display the total amount of sales in the last two months for each product (A-00, A-01, B-02, C-00), do I have to create a new straight table or can I display it on the same one?

[sunny_talwar]

Something like this?

[#9]

Yes, this is what I'm looking for. Unfortunately, I am getting off my internship to go to school so I will have to try this tomorrow and let you know. Also, are there any books or sites that can help me with QlikView?

[#10]

Awesome! This is perfect.Thank you so much Sunny.