Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

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
Highlighted

Re: How to get max of count

One funny solution?

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

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
Highlighted
Champion III
Champion III

Re: How to get max of  count

try

firstsortedvalue(,Created,-Assignmentgroup)

Highlighted

Re: How to get max of count

One funny solution?

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

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

Highlighted

Re: How to get max of count

Not sure, but may be this would be simpler

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