topic Re: Suppressing Header row in Pivot table in QlikView

Suppressing Header row in Pivot table

raghavsurya — Fri, 02 Jul 2010 14:54:40 GMT

Hi All,

I need to hide the header row in a Pivot table. Is there a way to do it. Please let me know.

Regards,

Raghav

Mon, 05 Jul 2010 06:49:26 GMT

In the Chart Properties, go to the Presentation tab, near the bottom on the left hand side, there is a check box for "Suppress Header Row".

Hope this helps.

raghavsurya — Mon, 05 Jul 2010 14:16:53 GMT

Hi Greame,

The option which you are suggesting is possible only in Straight table box. This option is not available for Pivot table.

Thanks and Regards,

Raghav

brenner_martina — Mon, 05 Jul 2010 14:35:57 GMT

Hi,

the easiest way is to change in custom cell format the text color!

Mon, 05 Jul 2010 14:40:56 GMT

In custom format cell you can change background and text color to white.

Then you get a white header row.

Anders

raghavsurya — Tue, 06 Jul 2010 06:04:14 GMT

Hi,

Thanks all for your suggestions..... I have done it now 🙂

Regards,

Raghav

nathanfurby — Tue, 06 Jul 2010 11:58:28 GMT

...and how did you do it?

Tue, 06 Jul 2010 12:39:50 GMT

Settings - User Preferences - Design

Mark "Always Show Design Menu Item"

Right click at the heading line and "Custom Format Cell"

There you can change the color.

Good luck

Anders

nathanfurby — Tue, 06 Jul 2010 12:52:27 GMT

Thanks Anders - I'm guessing that's how raghavsurya also did it

Tue, 21 Jun 2016 09:48:45 GMT

how?