Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

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

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

12 Replies
MVP
MVP

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

Try a straight table with these:

Dimension: Product

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


Capture.PNG


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

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

- Marcus

Not applicable

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

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

Not applicable

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

Thank you so much Marcus for posting up this formula.

MVP
MVP

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

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

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

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?

MVP
MVP

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

Something like this?

Capture.PNG

Not applicable

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

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

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

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