Need help

[chinnu123]

Hi Team,

I have  a requirement to fetch unique incident Id's based on the last updated date.

First I need to find a record num based on incident id and Lastupdated date.

for example For Incident Id INC001123 we are having 5 lastupdated dates so here we need to take recent last updated date(i.e 9/1/2017) as first record and 8/1/2017 as record 2 in the same way remaining records must be stored in record num field.

here i am providing my sql expression based on this i need to write in qlik. Can anyone please help me  in this

For row_number() over (partition by Incident Id order by Lastupdated date desc)

Incident Id	Lastupdated date	Status
INC001123	5/22/2017 1:11	open
INC001123	5/19/2017 9:17	review
INC001123	7/26/2017 1:11	closed
INC001123	8/1/2017 1:11	review
INC001123	9/1/2017 1:11	Approved
INC001124	6/26/2017 1:11	open
INC001124	8/27/2017 1:11	open
INC001124	2/28/2017 1:11	open
INC001124	4/29/2017 1:11	open
INC001124	7/30/2017 1:11	open

Thanks,

Chinnu.

[vinieme12]

can you post your Script?

[vinieme12]

i'm able to get the correct output