topic min and max dates in QlikView

min and max dates

Tue, 12 Apr 2016 14:52:36 GMT

Hi,

I have a table that looks like that:

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 — Tue, 12 Apr 2016 16:22:16 GMT

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;

Tue, 12 Apr 2016 17:32:57 GMT

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