Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)