Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Don't miss the upcoming Q&A with Qlik session on Qlik Application Automation on November 16th! REGISTER 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))

View solution in original post

Shahzad_Ahsan
Creator III
Creator III
Author

Thanks buddy

I was near to this but couldn't achieve.

Thanks