Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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.

ProductUnit CostLast Sold Date
A-00$7.997/15/2015
A-00$7.997/20/2015
A-01$6.997/5/2015
B-02$4.997/18/2015
B-02$4.996/30/2015
B-02$4.996/22/2015
C-00$5.997/1/2015
C-00$5.996/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

1 Solution

Accepted Solutions
Not applicable
Author

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

View solution in original post

12 Replies
sunny_talwar

Try a straight table with these:

Dimension: Product

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


Capture.PNG


marcus_sommer
MVP & Luminary
MVP & Luminary

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

- Marcus

Not applicable
Author

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

Not applicable
Author

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

Not applicable
Author

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?

Capture.PNG

Not applicable
Author

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?

Not applicable
Author

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