topic Hiding rows that have negative values in Qlik Sense HUB in App Development

Hiding rows that have negative values in Qlik Sense HUB

jakelongnaruto — Tue, 20 Dec 2022 21:50:47 GMT

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

Re: Hiding rows that have negative values in Qlik Sense HUB

BrunPierre — Wed, 21 Dec 2022 01:06:33 GMT

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

Re: Hiding rows that have negative values in Qlik Sense Web

jakelongnaruto — Tue, 20 Dec 2022 21:50:07 GMT

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

Re: Hiding rows that have negative values in Qlik Sense HUB

BrunPierre — Wed, 21 Dec 2022 01:16:12 GMT

What's the expression for the SQMSpend?

Re: Hiding rows that have negative values in Qlik Sense HUB

jakelongnaruto — Wed, 21 Dec 2022 06:44:46 GMT

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

Re: Hiding rows that have negative values in Qlik Sense HUB

BrunPierre — Wed, 21 Dec 2022 07:03:58 GMT

Maybe using an if statement?

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

Re: Hiding rows that have negative values in Qlik Sense HUB

jakelongnaruto — Wed, 21 Dec 2022 15:13:50 GMT

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