topic How To Hide Negative Values in QlikView

How To Hide Negative Values

Sat, 20 Apr 2013 08:59:23 GMT

Dear All,

I have used 2 tables for the calculation ( suppose table A & table B) & used the expression A-B, and make a chart (pivot table)

i just want to supress negative values in the output chart.

Thanks in advance

Re: How To Hide Negative Values

Gysbert_Wassenaar — Sat, 20 Apr 2013 09:49:24 GMT

You can try adding an if statement around your expression: if(A-B>=0, A-B). If that doesn't do what you need, please post example data and an example of what the result should look like.

Re: How To Hide Negative Values

Mon, 22 Apr 2013 11:28:03 GMT

Thanks Gysbert...

Re: How To Hide Negative Values

wiz_nerd — Mon, 11 Mar 2019 12:23:24 GMT

Thanks for the solution 🙂 It works perfectly.