Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
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
May be like attached sample.
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
;
May be like attached sample.