Nested aggregation

[Anonymous]

Hello qlikers 🙂 ,

for Example I have this:

Time               ID
12.12.2012   1
12.12.2012   2
15.12.2012   3
16.12.2018   4

I want to find the date who has the max IDs, I tried it with:

Calculat:
Load
Time
Max(Count(Time))
Resident Issue;

 But unfortunately Qlik said to me "nested aggregation" are not allowed.

The solution should be 12.12.2012, 3 .

Thank you in advance! 🙂 Looking forward to reading some answers!

[Taoufiq_Zarra · Accepted solution]

I think you need just in UI not in LOad

In UI maye be  :

=FirstSortedValue(Time,-aggr(count(ID),Time))