How to get max of count

[Anonymous]

Hi All,

I need max of count how to get.

My Expression: =max(aggr(count(Number),[Assignment group]))

Qlik out put:

Assignment group	Created	=max(aggr(count(Number),[Assignment group]))
A	7/21/2017 4:28:18 PM	5
B	7/14/2017 1:17:27 PM	2
C	7/24/2017 6:37:34 AM	5
D	7/27/2017 3:08:16 AM	11
E	7/25/2017 4:09:22 PM	3
F	6/3/2017 12:16:58 PM	203
G	7/27/2017 3:20:41 AM	60
H	7/27/2017 3:27:52 AM	14
I	7/4/2017 3:31:59 AM	80
J	7/24/2017 3:42:51 AM	1
K	7/13/2017 5:34:06 AM	24
L	7/13/2017 10:09:00 AM	7

Required out put:

Assignment group	Created	=max(aggr(count(Number),[Assignment group]))
F	6/3/2017 12:16:58 PM	203

Thanks,

Krishna

[Chanty4u]

try

firstsortedvalue(,Created,-Assignmentgroup)

[Anil_Babu_Samineni · Accepted solution]

One funny solution?

If(Max(Aggr(Count(Number), [Assignment group]))=Max(TOTAL Aggr(Count(Number), [Assignment group])), Max(Aggr(Count(Number), [Assignment group])))

[sunny_talwar]

Not sure, but may be this would be simpler

Count({<[Assignment group] = {"=Count(Number) = Max(TOTAL Aggr(Count(Number), [Assignment group]))"}>} Number)