topic Showing Straight Table Fields for Max Values in QlikView

Showing Straight Table Fields for Max Values

MM — Wed, 06 Mar 2019 16:05:48 GMT

Hello Everyone,

I am working on a straight table and I have a problem :

I have many fields :
- Vehicle Name
- Issue Number
- Type of issue
- Description of issue
- Start Date
- End Date

For every vehicle, I want to show each field for the max Issue Number of the max End Date.

Can someone give me a hand ?

I have tried with AGGR and FirstSortedValue, but no success.

Thank you.

hopkinsc — Wed, 06 Mar 2019 16:49:38 GMT

have you tried (aggr(max(date(EndDate)),VehicleName,IssueNo, RESTOFDIMS))

MM — Thu, 07 Mar 2019 07:56:19 GMT

Thank you for your quick reply.

This will work to display the Max End Date for each Vehicle.

But how to show the Description of an issue of the Max End Date for each Vehicle ?

MM — Thu, 07 Mar 2019 08:40:06 GMT

It should be something like this :

= FirstSortedValue ( DESCRIPTION, -aggr(Max(END DATE), TYPE OF ISSUE, VEHICLE NAME) )

But it doesn't work.