Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Lakshminarayanan_J

Need to Display Date Based on Ledger Value

Hi Expert,

We need to Display Based on Ledger Value , 

For Example:

Ledger Value is Minimum Need To display Arrival Date

Ledger Value is Maximum Need to display Delivery Date

Expected Result Based on Below Table:

Need To Display Arrival date based on minimum ledger value : 28-12-2022 

Need To Display Arrival date based on Maximum ledger value : 30-12-2022 

Table: 

Ledger Value Arrival Date  Departure Date
1 28-12-2022 31-12-2022
2 26-12-2022 29-12-2022
3 27-12-2022 26-12-2022
4 29-12-2022 25-12-2022
5 30-12-2022 28-12-2022
6 31-12-2022 30-12-2022
Lakshminarayanan J
To help users find verified answers, please don't forget to use the "Accept as Solution" button
5 Replies
BrunPierre
Partner - Master
Partner - Master

Min:  =FirstSortedValue([Arrival Date],[Ledger Value])

Max: =FirstSortedValue([Arrival Date],-[Ledger Value])

Lakshminarayanan_J
Author

@BrunPierre 

Thank You For Your Response,

 I have tried implementing for Min as you mentioned above, But is it displaying all three IDs

For ID:s22023 , we have 3 ledger value , but need to display only min , which is 1 and date as 6/18/2022 not all three values

 

Ledger Value ID =date(FirstSortedValue([Transport ATA],[Transport Ledger Order]))
1 S22023 6/18/2022
2 S22023 6/22/2022
3 S22023 6/26/2022
Lakshminarayanan J
To help users find verified answers, please don't forget to use the "Accept as Solution" button
BrunPierre
Partner - Master
Partner - Master

Share the dataset with all the necessary columns.

Lakshminarayanan_J
Author

@BrunPierre 

this is the Adhoc report, primary column is ID

Lakshminarayanan J
To help users find verified answers, please don't forget to use the "Accept as Solution" button
BrunPierre
Partner - Master
Partner - Master

=FirstSortedValue(Aggr(Only([Transport ATA]),ID,[Ledger Value]), [Transport Ledger Order])