Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to get max of count

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

1 Solution

Accepted Solutions
Anil_Babu_Samineni

One funny solution?

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

3 Replies
Chanty4u
MVP
MVP

try

firstsortedvalue(,Created,-Assignmentgroup)

Anil_Babu_Samineni

One funny solution?

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
sunny_talwar

Not sure, but may be this would be simpler

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