Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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

Re: Couting negative values

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

MVP
MVP

Couting negative values

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

Community Browser