2 Replies Latest reply: Mar 21, 2012 1:12 PM by gardenia RSS

    Using the latest date from a list of dates

      I have a bar chart that looks at serial number movements. The Dimension is Date Shipped.

       

      The expression I have currently returns mutiple dates for a single serial number. I need to only select the latest date, and count this (ie the count on each serial number should always be one).

       

      A further complication is that I am using a variable (vDate) for Date Selected. The date to be counted must always be less than vDate

       

      This is my expression: Count(If(TYPE='S',Date Shipped))

       

      I'm new to QlikView - any assistance would be really appreciated.