topic Re: Delivery date display in qlikview in QlikView

Delivery date display in qlikview

geam1988 — Mon, 06 Aug 2018 15:35:58 GMT

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

Re: Delivery date display in qlikview

sunny_talwar — Mon, 06 Aug 2018 15:41:43 GMT

May be this

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

Re: Delivery date display in qlikview

geam1988 — Tue, 14 Aug 2018 07:33:18 GMT

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

Re: Delivery date display in qlikview

sunny_talwar — Tue, 14 Aug 2018 19:38:34 GMT

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?