Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Couting negative values

Hello,

I need to develop a bar chart in which I will count only the amount of negative values in one of the selected dimensions in my database project.

Could anyone help me about the expression I should use for that?

Thanks,

Andre.

2 Replies
its_anandrjs

Hi,

You need to count some thing like in your expression for negative values

=Count ( If(YourField < 0, YourField ))

As i understand or not please confirm me.

Anand

swuehl
MVP
MVP

I believe you need an if() in there:

= count(if(YourField <0,YourField))

to count the amount of values (use sum() to sum them up)

Stefan