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: 
Shahzad_Ahsan
Creator III
Creator III

Count of Maximum no of transactions on any date

Hi

I want to calculate Max No of transactions on a any date.

Please suggest expression as KPI

Here is the sample data:

Date format is MM/DD/YYYY

LOAD * Inline [
1,  12/03/2020
2,  12/04/2020
3,  12/04/2020
4,  12/04/2020
5,  12/04/2020
6,  12/04/2020
7, 12/04/2020
8, 12/05/2020
9, 12/05/2020
10, 12/06/2020
]

Result Should be : 6

Thanks

Qlik Sense  

Labels (1)
1 Solution

Accepted Solutions
GaryGiles
Specialist
Specialist

If your field is ID and second field is Date; this expression should work.

max(aggr(count(ID),Date))

View solution in original post

2 Replies
GaryGiles
Specialist
Specialist

If your field is ID and second field is Date; this expression should work.

max(aggr(count(ID),Date))

Shahzad_Ahsan
Creator III
Creator III
Author

Thanks buddy

I was near to this but couldn't achieve.

Thanks