Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Count with multiple conditions (with rolling period)

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

 

DateError typeStatus
10/30/2019typoApproved
10/31/2019incorrect numberApproved
9/1/2019typoRejected
9/2/2019missing docsRejected
10/3/2019missing docsRejected
10/9/2019missing dosPending
1 Solution

Accepted Solutions
Highlighted

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

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

2 Replies
Highlighted

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

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

Highlighted
Contributor III
Contributor III

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