Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
geam1988
Creator
Creator

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
sunny_talwar

May be this

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

View solution in original post

3 Replies
sunny_talwar

May be this

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

View solution in original post

geam1988
Creator
Creator
Author

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?