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|
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:
Solved! Go to Solution.
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.
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?
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?