Qlik Sense: Hide row in table based on value of an aggregated Sum column

[sjoshan]

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

[whiteymcaces · Accepted solution]

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)