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: 
ElenaDominguez
Contributor II
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

Labels (4)
1 Solution

Accepted Solutions
Sergey_Shuklin
Specialist
Specialist

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

View solution in original post

3 Replies
Sergey_Shuklin
Specialist
Specialist

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
Contributor II
Contributor II
Author

Thank you very much!!!

Sergey_Shuklin
Specialist
Specialist

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.