Solved: Count with multiple conditions (with rolling perio... - Qlik Community

Maciej29 · ‎2019-10-30

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 · ‎2019-10-30

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

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

View solution in original post

Anil_Babu_Samineni · ‎2019-10-30

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

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

Maciej29 · ‎2019-10-30

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

Count with multiple conditions (with rolling period)