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
Great
I am glad I was able to help.
Best,
Sunny
Where are you going back to school? Does the university have the Qlik Academic Program? If not, you can ask a professor to apply to get Qlik. Business Intelligence Training, Qlik Academic Program | Qlik
Here's my favorite book: http://www.amazon.com/QlikView-11-Developers-Barry-Harmsen/dp/1849686068/
As far as websites? You're on it. The Qlik Community. Also, I like the Qlik Blog aggregator site: http://www.askqv.com/
I go to school at California State University, Fullerton. I will keep this in mind. Thank you for all the information.