Discussion board where members can learn more about Qlik Sense App Development and Usage.
I have the following table
From the above table i have to load only those records which has max date for each ID
the output should be as follows
can anyone help me in this ?
Thanks in advance
Try this script:
(html, codepage is 1252, embedded labels, table is @1);
Right Join (Table)
Max(Date) as Date
Group by ID;
You can also try this:
Where ID <> Previous(ID)
Order By ID, Date desc;
Thanks Sunny. This helped me out. -Tim