Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Count if within addmonth query

I cannot get this bad boy to work team.

What have I done wrong...

=

Count(if([iDesignOR Date] <= (addmonths(Today(),0)) AND [iDesignOR Date] >= (addmonths(Today(),-

2

)), ({<
[iDesignOR Status]{'Processed','Order'}>}[iDesignOR Status]) )) 

It worked (see below) until I added the last criteria to only count the Processed and Order options

=

Count(if([iDesignOR Date] <= (addmonths(Today(),0)) AND [iDesignOR Date] >= (addmonths(Today(),-

2

)),
[iDesignOR Status])) 

1 Solution

Accepted Solutions
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Try

Count({<[iDesignOR Status]={'Processed','Order'}>} if([iDesignOR Date] <= (addmonths(Today(),0)) AND [iDesignOR Date] >= (addmonths(Today(),-2)), [iDesignOR Status]))


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Try

Count({<[iDesignOR Status]={'Processed','Order'}>} if([iDesignOR Date] <= (addmonths(Today(),0)) AND [iDesignOR Date] >= (addmonths(Today(),-2)), [iDesignOR Status]))


talk is cheap, supply exceeds demand
Not applicable
Author

Top Man!