9 Replies Latest reply: Oct 4, 2012 11:35 AM by jack15501 RSS

    Finding the Minimum date from a group of records.

      Hi All,

       

      I'm new to QlikView and I have a task I need to complete, which I’m sure is
      an easy one for you guys.  I need to pull out the minimum dates of a group
      of records where Col2=S2.

       

      Example:

       

      Col1                      Col2       Col3

       

      RO_0001             S1           4/15/2010

      RO_0001             S2           3/19/2012

      RO_0001             S2           1/10/2011

      RO_0002             S2           3/25/2010

      RO_0002             S2           8/8/2012

      RO_0002             S1           10/10/2019

      RO_0003             S1           12/12/2009

      RO_0003             S2           10/01/2012

      RO_0003             S2           06/05/2011

      RO_0003             S2           05/05/2009

         

      The result table should look like:

       

      RO_0001             S2           1/10/2011

      RO_0002             S2           3/25/2010

      RO_0003             S2           05/05/2009

       

      I would need the result table to be shown when the application is started on the dashboard by default not after a selection is made.