topic Re: Hide pivot table row in QlikView

Hide pivot table row

Wed, 25 Nov 2020 16:16:04 GMT

Hello everyone, I need to know if it is possible in a pivoting table to hide the rows that result in "0".

As you see in the picture the total column, hide the results that are in "0"

Anonymous — Wed, 30 Nov 2016 20:02:17 GMT

Try this:

Wed, 30 Nov 2016 21:02:39 GMT

Good friend

Make that option that you mention but same follows the "0".

rupamjyotidas — Wed, 30 Nov 2016 21:10:05 GMT

In calculated dimension

=If(aggr(Sum(YourEqaution),Art)>0,Art)

Wed, 30 Nov 2016 21:34:29 GMT

Good friend

I attached the file so I can receive help from you, thank you.

Wed, 30 Nov 2016 21:37:18 GMT

Good friend

Please send me your emails to attach the file since I do not know how to do it by this means.

Anil_Babu_Samineni — Thu, 01 Dec 2016 02:20:45 GMT

Upload Community by guide from below link so that every one can understand

OR You may use this

Anonymous — Thu, 01 Dec 2016 04:05:24 GMT

Properties--> Presentation tab--> select suppress zero-values

Anonymous — Thu, 01 Dec 2016 13:14:58 GMT

Try this:

Thu, 01 Dec 2016 13:19:03 GMT

In calculated dimension use below

If(Count(ID)>0,your dimension)

use your expression and dimension