Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Sum({$<Supplier={"=Sum(Spend)>0"}>} Spend)
That looks all strange to me.
I'm using Qliksense HUB. All I can edit is from here.
What's the expression for the SQMSpend?
Nothing actually.
SQMSpend is just spend. The "//if(sum.....)" is just a comment out
Maybe using an if statement?
If(SQMSpend < 0, Null(), SQMSpend)
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