Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

ElenaDominguez
New Contributor II

No mostrar valores negativos en una grafico

Buen dia!

Tengo una tabla con diferentes expresiones, como puedo ocultar/borrar aquellos registros que en la columna de Cantidad Restante tengan un valor negativo?

Captura.PNG

1 Solution

Accepted Solutions
Sergey_Shuklin
Valued Contributor

Re: No mostrar valores negativos en una grafico

Hello!

You can use IF-condition for checking positive values.

show_positive_pic1.png

And for optimizing calculations in other columns you can use link (name) of your target column:

show_positive_pic2.png

3 Replies
Sergey_Shuklin
Valued Contributor

Re: No mostrar valores negativos en una grafico

Hello!

You can use IF-condition for checking positive values.

show_positive_pic1.png

And for optimizing calculations in other columns you can use link (name) of your target column:

show_positive_pic2.png

ElenaDominguez
New Contributor II

Re: No mostrar valores negativos en una grafico

Thank you very much!!!

Highlighted
Sergey_Shuklin
Valued Contributor

Re: No mostrar valores negativos en una grafico

Hello!
You welcome. Also for better performance of your report you may use Set Analysis:
sum({<vl_neg = {">0"}>}vl_neg)
It's get critical if your report is huge.