Hiding rows that have negative values in Qlik Sense HUB

[jakelongnaruto]

Hi,
How to remove/hide ROWS that have negative value in Qliksense Web.
From this example, I would like to hide rows B and C because Spend is negative.

Been searching old topics but nothing works.
Thank you in advance

[BrunPierre]

Sum({$<Supplier={"=Sum(Spend)>0"}>} Spend)

[jakelongnaruto]

That looks all strange to me.
I'm using Qliksense HUB. All I can edit is from here.

[BrunPierre]

What's the expression for the SQMSpend?

[jakelongnaruto]

Nothing actually. 
SQMSpend is just spend. The "//if(sum.....)" is just a comment out

[BrunPierre]

Maybe using an if statement?

If(SQMSpend < 0, Null(), SQMSpend)

[jakelongnaruto · Accepted solution]

It works finally.

If(SQMSpend < 0, Null(), Expression-related-to-XYZ-measure)

There are many more measures columns. So I applied the expression above to all of them. Using If(SQMSpend < 0, Null(),  as the base + Expression-related-to-XYZ-measure