Count of Max Value for Latest Month

[cloud]

Hi Experts,

I have data as below:

Month	Name	Type	Months Overdue
Feb-19	Jane	A	2
Feb-19	Jane	B	2
Feb-19	Jane	C	2
Feb-19	Tim	D	1
Feb-19	Tim	E	1
Feb-19	Sally	F	1
Jan-19	Sally	G	4
Jan-19	John	H	3

I want to display in a text box the count of the max value of Months Overdue for the latest month:

"3 types with 2 months overdue"

How do I go about doing this? Been stuck on this forever. Please type in example as I can't open Qlikview files. Thank you.

[Claudiu_Anghelescu]

Types = Count( {<[Months Overdue]= {"$(=Max([Months Overdue]))"}>} Type )

Months Overdue =max([Months Overdue])

=Count( {<[Months Overdue]= {"$(=Max([Months Overdue]))"}>} Type ) & ' types with ' & max([Months Overdue]) & ' months overdue'

or you can use Aggr() function.

[cloud]

Hi Claudiu,
Your solution does not work for me. I do have data for different months. I've updated my post for better understanding. thanks.

Also, I can't open Qlikview files as I'm on Personal Edition. 

[cloud · Accepted solution]

I fixed it:

I created a variable vMaxNumMonths, which holds the set expression for latest month and max(Months overdue), and just place it in the set expression.

Thanks all.