topic Re: MAX DATE - NEW in QlikView

MAX DATE - NEW

Mon, 05 May 2014 12:26:50 GMT

I am new to qlikview and had adopted the below table through resident load from by performing some task ,now i need Name,Date(actual Date),Data and MAX DATE(ie 04/06/2013') throughout the table ,

Name	Data	DATE	MAX DATE
A	10	01/06/2013	04/06/2013
B	10	01/06/2013	04/06/2014
C	10	01/06/2013	04/06/2015
D	10	01/06/2013	04/06/2016
F	10	01/06/2013	04/06/2017
A	20	02/06/2013	04/06/2018
B	20	02/06/2013	04/06/2019
C	20	02/06/2013	04/06/2020
D	20	02/06/2013	04/06/2021
F	20	02/06/2013	04/06/2022
A	30	03/06/2013	04/06/2023
B	30	03/06/2013	04/06/2024
C	30	03/06/2013	04/06/2025
D	30	03/06/2013	04/06/2026
F	30	03/06/2013	04/06/2027
A	100	04/06/2013	04/06/2028
B	100	04/06/2013	04/06/2029

Thanking You

Vinayagam

Re: MAX DATE - NEW

maxgro — Mon, 05 May 2014 12:57:24 GMT

do you want to add to the above table a new field with (for all rows) the max of DATE field?

source:
LOAD Name, 
     Data, 
     DATE
    // [MAX DATE]
FROM
[http://community.qlik.com/thread/117210]
(html, codepage is 1252, embedded labels, table is @1);

left join (source)
load
// Name, 
//  DATE,
    max(DATE) as NewField
Resident source    
//group by      
//     Name, 
//     DATE
;

Re: MAX DATE - NEW

tresB — Mon, 05 May 2014 13:00:50 GMT

May be like attached sample.