Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm trying to hide a table row, based on the value of the column Pairs. Pairs is an aggregated value; Pairs = Sum(Qty)
I need to hide all rows where Pairs = 0. Tried many expressions and if statements for the column Party but to no success.
Please help!
Thanks
By design, Qlik Sense will omit rows where all the expressions = 0 (or null) and "Show Zeros" is un-ticked.
You need to add an If condition to all expressions to check the result of the Pairs expression, and if Pairs = 0 then the expression should = 0.
i.e for the Sales (USD) expression I would use:
If(Sum(Qty) <> 0, Sum(Sales), 0)
By design, Qlik Sense will omit rows where all the expressions = 0 (or null) and "Show Zeros" is un-ticked.
You need to add an If condition to all expressions to check the result of the Pairs expression, and if Pairs = 0 then the expression should = 0.
i.e for the Sales (USD) expression I would use:
If(Sum(Qty) <> 0, Sum(Sales), 0)