load only the max dates

0li5a3a — Sat, 16 Nov 2024 05:11:20 GMT

Hi all,

can someone help me how to load only the max dates from the below tables:

tab1:

id , parentid, date, newteam

1, 11, 20/11/2018 11:30, go

1, 11, 20/11/2018 11:31, go

1, 11, 20/11/2018 11:38, go

2, 12, 21/11/2018 12:00,new

3, 13, 22/11/2018 12:21, new

tab2:

id, orderdate, team

1, 20/11/2018 11:30,

2, 20/11/2018 12:00,

3, 21/11/2018 12:00,new

FinalTable:

id,parentid,date,newteam

1, 11, 20/11/2018 11:38, go

2, 20/11/2018 12:00, new

3, 21/11/2018 12:00,new

What I need to write the logic to be able to display the FianlTable?

Thanks for help

Re: load only the max dates

Frank_Hartmann — Tue, 20 Nov 2018 17:04:42 GMT

I dont understand the logic.
Can u give more details?
You want to show only max date per id?
then i would expect this as final table:

id parentid newteam date
1 11 go 20/11/2018 11:38
2 12 new 21/11/2018 12:00
3 13 new 22/11/2018 12:21

topic Re: load only the max dates in QlikView

load only the max dates

Re: load only the max dates