Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
geam1988
New Contributor III

Delivery date display in qlikview

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



1 Solution

Accepted Solutions
Highlighted

Re: Delivery date display in qlikview

May be this

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

View solution in original post

3 Replies
Highlighted

Re: Delivery date display in qlikview

May be this

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

View solution in original post

Highlighted
geam1988
New Contributor III

Re: Delivery date display in qlikview

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

 

Highlighted

Re: Delivery date display in qlikview

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?