Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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)
1 Solution

Accepted Solutions
Highlighted
Partner
Partner

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

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
Highlighted
Partner
Partner

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

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