13 Replies Latest reply: Jun 12, 2014 11:41 AM by Nancy Briceño Aguilar RSS

    Table Box Aggregation (Max) Single Line of Data

      I have coded my LOAD script to pull a date when a task name is matched and I want to present each task date per project on a single row within a table (see below).  I have done this in a report, outside of QlikView using the max aggregation, but I cannot get to this work in QV.

       

      I would like the table to have one row for the project name and each date value listed in the same row.

       

      table.png

      Script:

       

      code.png