topic Re: Couting negative values in QlikView

Couting negative values

Wed, 31 Aug 2011 05:38:25 GMT

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.

its_anandrjs — Wed, 31 Aug 2011 05:47:16 GMT

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 — Wed, 31 Aug 2011 07:08:37 GMT

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