Firstsorted value with

brunolelli87 — Wed, 31 Mar 2021 14:06:32 GMT

Hello guys

With the following expression I'm able to count the number of aircraft flying for a specific airline.

=count({<DASI ={'$(vData1)'},NCIA={$(vAirline)},ONGR={'0'}>} DISTINCT TAIL)

Where:

- DASI is a date, (DD/MM/YY)
- NCIA is the airline Name
- ONGR is 0 or 1
- TAIL is the aircraft's registration mark (each aircraft has his own and individual tail)

I'm using this expression to count how many aircraft is flying each minute, thoughout the days... and now I would like to get the DATE where the maximum value was reached. Something like this: "The max valus is 55 on 27/03/21"

So, I was trying to use the following expression, which was working fine for some airlines, but it's not working for some others... (I'm just getting - as the output)

=Date(FirstSortedValue(TIMS, -Aggr(count({<NCIA={$(vAirline)},ONGR={'0'}>} DISTINCT TAIL), TIMS)), 'DD/MM/YY')

- TIMS is the date in timestamp format,

Do you guys have any idea about what's going on and how to solve this issue?

Thank you!

Re: Firstsorted value with

rwunderlich — Wed, 31 Mar 2021 17:32:49 GMT

It could be that you have multiple dates with the same value. Try adding DISTINCT keyword to FirstSortedValue().

-Rob

Re: Firstsorted value with

brunolelli87 — Wed, 31 Mar 2021 17:37:42 GMT

WOW!!!

You are the best...
Thanks

topic Firstsorted value with in QlikView

Firstsorted value with

Re: Firstsorted value with

Re: Firstsorted value with