Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sjoshan
Contributor
Contributor

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

Hi,

I'm trying to hide a table row, based on the value of the column PairsPairs 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

sjoshan_0-1591107463738.png

 

Labels (1)
  • SaaS

1 Solution

Accepted Solutions
whiteymcaces
Partner - Creator
Partner - Creator

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)

View solution in original post

1 Reply
whiteymcaces
Partner - Creator
Partner - Creator

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)