Discussion Board for collaboration on QlikView Layout & Visualizations.
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?
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.
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)