Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

min and max dates

Hi,

I have a table that looks like that:

PPRINRIVR_DATE
11101/01/16
11220/01/16
11315/01/16
222130/12/15
222220/10/15
222309/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

1 Solution

Accepted Solutions

Re: min and max dates

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;


Capture.PNG

2 Replies

Re: min and max dates

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;


Capture.PNG

Not applicable

Re: min and max dates

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

Community Browser