Choosing the Max date record in the straight table(Urgent)

[#1]

hello All,

I am new to qlikview still learning

I really need your help urgently.My sprint is ending tomorrow.

below is my sample data.

I want to only show the number with the max order_start_date.

so here i want to show the record with order_start_date as 3.11.2016.

number	name	PRODUCT_ID	PRODUCT_NAME	TIME_ARRIVAL	ORDER_START_DATE	time_rejected
01	john	1	a	3.11.2016 14:37	16.6.2016	8.11.2016 12:32
01	john	1	a	3.11.2016 14:37	3.11.2016	8.11.2016 12:32

please let me know how i can do that in the straight table.

Appreciate your help.

Thanks & Regards,

jaya

[trdandamudi]

Please see the attached and hope this is what you are looking for:

The expression in the straight table should be as below:

=Only({<ORDER_START_DATE={"$(=Date(Max(ORDER_START_DATE),'D.MM.YYYY'))"}>}  ORDER_START_DATE)