How to get max of count

[Anonymous]

Hi All,

I need max of count Group by Assignment group and Created date 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]))
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
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
I	7/4/2017 3:31:59 AM	80
K	7/13/2017 5:34:06 AM	24

Thanks,

Krishna

[Anil_Babu_Samineni]

For me it looks like this? Not sure the logic behind

=max(aggr(count({<[Assignment Group] -= {'D','H','J','L'}}>} Number),[Assignment group]))

[stabben23]

Hi,

it looks that you want to exclude som Assignment group? In that case add set analysis into you Expression like this.

=max(aggr(count({<[Assignment group]-={'D','H','J','L'}>}Number),[Assignment group]))

[sunny_talwar]

Try this

Script

Table:

LOAD Number,

    Created,

    Date(Floor(Created)) as CreatedDate,

    [Assignment group]

FROM

Sample_Data.xls

(biff, embedded labels, table is [Page 1$]);

Expression

=Sum(Aggr(If(Max(TOTAL <CreatedDate> Aggr(Count(Number), CreatedDate, [Assignment group])) = Count(Number), Count(Number)), CreatedDate, [Assignment group]))