topic Re: Hide Certain Rows in Pivot in QlikView

Hide Certain Rows in Pivot

Anonymous — Tue, 09 Dec 2014 00:03:15 GMT

Need to "hide" Other and Unassigned rows in below pivot table without affecting either of Total rows. Please, note Industry column below is a second dimension but dragged to make it look like a column.

Is such a scenario possible ?

Thanks.

Region	Industry	Total	Corporation	Unassigned	Public	Banking
Total		88%	61%	93%	63%	69%
Americas		13%	9%	3%	58%	49%
Europe		0%	27%	94%	86%	48%
Asia		15%	44%	55%	31%	18%
Other		24%	54%	31%	19%	41%

Re: Hide Certain Rows in Pivot

Tue, 09 Dec 2014 08:48:20 GMT

Hi,

I think you should try to hide it by using an if statement. For example: if(Region<>'' or Region<>'Other',Region) . This way the unassigned and other regions won't be displayed in your table. Let me know whether it worked or not!

Best,

Tibor

Re: Hide Certain Rows in Pivot

Anonymous — Tue, 09 Dec 2014 23:24:22 GMT

Hi Tibor,

It hides those values but also changes the Total values as well, need to keep them the same.

Re: Hide Certain Rows in Pivot

Wed, 10 Dec 2014 00:06:45 GMT

Look at this thread. That should solve your problem.

Hiding rows based on condition

Re: Hide Certain Rows in Pivot

Anonymous — Wed, 10 Dec 2014 20:10:23 GMT

Ramkumar,

As mentioned, I have a pivot table (not Straight) ... and the post mentions hiding a row based on an expression value, my condition is to hide a row based on a Dim value and still not affect the Total.

Thanks.