Table Box Aggregation (Max) Single Line of Data

[#1]

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.

Script:

[PrashantSangle]

Hi,

Can You tell us,

What is your dimension?

and

What is your expressions?

Regards,

[#3]

I was able to get it to work, can i remove the grand totals row now?

[PrashantSangle · Accepted solution]

Hi,

Yes,

Just Select No Total Instead of Expression Totals

In Expression Tab

Regards,

[#5]

Dear,

I make an example and it work fine!

I send you my files and printscreen. I hope this helps you

Regards