Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm new to QlickView.
I'm having table like:
App | Status | Ignore |
---|---|---|
1 | Error | NULL |
2 | No Error | 1 |
3 | Success | NULL |
4 | Error | NULL |
5 | Error | 1 |
I want to count all app's that have status 'Error' and Ignore NULL.
Can some one help me?
Regards,
Laurens van de Venn
Maybe something like this:
Count({<Ignore-={''}, Status={'Error'}>}App)
or
Count({<Ignore-={'-'}, Status={'Error'}>}App)
or
Count({<Ignore-={'NULL'}, Status={'Error'}>}App)
depends on how your NULL values are defined