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
.png "Luminary Alumni"){kind=icon}