12 Replies Latest reply: Jul 24, 2015 3:38 PM by Ronald Trang RSS

    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