topic Re: Zero Row Suppression in QlikView

Zero Row Suppression

sangland2 — Thu, 31 Mar 2016 11:15:35 GMT

Hi, Is it only possible to suppress a row in a table if all the expression values display as zero. A blank value in any expression won't achieve this. So I have text fields showing zero value that I then have to hide with conditional formatting. With a large number of expressions in a table this is tedious. What if I want to suppress rows where a value in a particular field is a certain value (variable) not just zero ? Thanks

Re: Zero Row Suppression

Chanty4u — Thu, 31 Mar 2016 11:17:46 GMT

u will hve a option Hide column

or chk dis

Suppress rows depending on the value of a particular expression

Re: Suppressing Rows

Re: Zero Row Suppression

Chanty4u — Thu, 31 Mar 2016 11:19:12 GMT

chk dis

Re: Zero Row Suppression

sangland2 — Fri, 01 Apr 2016 01:06:15 GMT

Thanks, but I don't want to hide any columns.

Re: Zero Row Suppression

sangland2 — Fri, 01 Apr 2016 01:09:15 GMT

Thanks for the Aggr tip on that link. I can see that this would work. Problem is that my Dimensions are calculations, not just a field in a table. I'll play with this.

Re: Zero Row Suppression

psankepalli — Fri, 01 Apr 2016 01:17:00 GMT

try this option from the below link, it may be helpful

Suppress Rows in Chart if Expression is zero?

Re: Zero Row Suppression

sangland2 — Fri, 01 Apr 2016 01:29:32 GMT

Thanks. I tried this option but there many expression fields to add this into. Some expressions are return text fields so forcing a zero in here is ugly. formatting can take care of this but still lots of expression fields. Functionality to suppress if zero is good but why only zero and not some other condition. Seems like basic functionality to conditionally suppress rows is missing in the GUI. Hopefully I can get the Aggr to work.