min and max dates

[#1]

Hi,

I have a table that looks like that:

PPR	INR	IVR_DATE
1	11	01/01/16
1	12	20/01/16
1	13	15/01/16
2	221	30/12/15
2	222	20/10/15
2	223	09/08/15

I need to add 2 columns to the table with the min and max IVR_DATE of the PPR.

How can i do it in the script when i'm loading the table?

Thx for help and sry for bad english

[sunny_talwar · Accepted solution]

Try this:

Table:

LOAD PPR,

     INR,

     IVR_DATE

FROM

[https://community.qlik.com/thread/212990]

(html, codepage is 1252, embedded labels, table is @1);

Left Join (Table)

LOAD PPR,

  Date(Min(IVR_DATE)) as MinDate,

  Date(Max(IVR_DATE)) as MaxDate

Resident Table

Group By PPR;

[#3]

Use the same table and use Resident option calculate the Min & Max dates.  Finally Join back to your main table.