Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
If your field is ID and second field is Date; this expression should work.
max(aggr(count(ID),Date))
If your field is ID and second field is Date; this expression should work.
max(aggr(count(ID),Date))
Thanks buddy
I was near to this but couldn't achieve.
Thanks