Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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

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

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!