Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
One funny solution?
If(Max(Aggr(Count(Number), [Assignment group]))=Max(TOTAL Aggr(Count(Number), [Assignment group])), Max(Aggr(Count(Number), [Assignment group])))
try
firstsortedvalue(,Created,-Assignmentgroup)
One funny solution?
If(Max(Aggr(Count(Number), [Assignment group]))=Max(TOTAL Aggr(Count(Number), [Assignment group])), Max(Aggr(Count(Number), [Assignment group])))
Not sure, but may be this would be simpler
Count({<[Assignment group] = {"=Count(Number) = Max(TOTAL Aggr(Count(Number), [Assignment group]))"}>} Number)