5 Replies Latest reply: Jan 5, 2017 3:56 PM by Sunny Talwar RSS

    Max Value Within an Array

    Charles Esquibel

      Hello,


      I have a table with a set of unique IDs, shared IDs, and Dates.  When loading the data, I'm attempting to add a calculated column which lists the maximum date associated with the shared IDs for each unique ID.  I've been able to determine these values in excel using an array formula, but I'm at a loss as to how I should proceed with loading and modifying this data using QlikView.  There may be any number of unique IDs associated with the same Shared ID.

       

      For example, something that inputs the 3 leftmost columns and will be able to output the maximum date.

       

      Unique IDShared IDDate*Maximum Date*
      1A1/1/20171/1/2017
      2A12/12/20161/1/2017
      3B2/2/20172/2/2017
      4B11/11/20162/2/2017

       

      Thank you in advance for your help!