Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
Thanks
Thank you so much Sunny, this is just what I needed.
Try a straight table with these:
Dimension: Product
Expression: FirstSortedValue([Last Sold Date], -[Last Sold Date])
You could try: firstsortedvalue([Last Sold Date], -[Last Sold Date])
- Marcus
Thank you so much Sunny, this is just what I needed.
Thank you so much Marcus for posting up this formula.
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
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?
Something like this?
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?
Awesome! This is perfect.Thank you so much Sunny.