Count with multiple conditions (with rolling period)

[Maciej29]

I'm looking for answer to count Error type only for last month (from today), but only for rejected status. Is someone know how to build this qlik formula ? Thanks in advance

Date	Error type	Status
10/30/2019	typo	Approved
10/31/2019	incorrect number	Approved
9/1/2019	typo	Rejected
9/2/2019	missing docs	Rejected
10/3/2019	missing docs	Rejected
10/9/2019	missing dos	Pending

[Anil_Babu_Samineni · Accepted solution]

Perhaps this? This condition works until unless you have forecast data..

Count({<date={">=$(=Addmonths(max(date),-1)<=$(=max(date))"}, status={'rejected'}>} errortype)

[Maciej29]

It's working ! Thanks a lot for your quick reply.