Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
Perhaps this? This condition works until unless you have forecast data..
Count({<date={">=$(=Addmonths(max(date),-1)<=$(=max(date))"}, status={'rejected'}>} errortype)
Perhaps this? This condition works until unless you have forecast data..
Count({<date={">=$(=Addmonths(max(date),-1)<=$(=max(date))"}, status={'rejected'}>} errortype)
It's working ! Thanks a lot for your quick reply.