Count of Maximum no of transactions on any date

[Shahzad_Ahsan]

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  

[GaryGiles · Accepted solution]

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

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

[Shahzad_Ahsan]

Thanks buddy

I was near to this but couldn't achieve.

Thanks