Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to count records

Hi,

I'm new to QlickView.

I'm having table like:

AppStatusIgnore
1ErrorNULL
2No Error1
3SuccessNULL
4ErrorNULL
5Error1

I want to count all app's that have status 'Error' and Ignore NULL.

Can some one help me?

Regards,

Laurens van de Venn

1 Reply
OmarBenSalem

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