Delivery date display in qlikview

[geam1988]

Hello,

I want to display delivery date as per last creation date  (13.07.18)  or last sequential number (2) or last confirm. catagory (Z1). we have sequential number till 9  and confirm. catagory till Z9

i want to show the report like this

i used following expressions,  it shows no result.

if i use date( max(EKES.EINDT)) i get the delivery date 12.10.2018 but i want to show 28.09.2018

[sunny_talwar · Accepted solution]

May be this

Date(FirstSortedValue(EKES.EINDT, -SequentialNumber))

[geam1988]

Hi ,

Date(FirstSortedValue(EKES.EINDT, -SequentialNumber))   this expressions is working but it is not showing the date as per position. i mean, if i have more than 1 position (00010, 00020 ) it does not show the result per position.  see the below example, for position 220 date is ok but for 280 it is worng. for position 280 date is 29.08.2018. Do you know how to solve it?

Thanks

[sunny_talwar]

Do you have Position as a dimension in your chart? Would you be able to share a sample to show where this is not working?