topic Re: Question regarding hiding column header in pivot table. in QlikView

Question regarding hiding column header in pivot table.

Mon, 25 Aug 2014 11:59:53 GMT

I'm fairly new to Qlikview, but was wondering if anyone can help me with how to remove the "header column" from a pivot. That probably doesn't make sense so attached is the screen shot of the app. I want the column that says "Qtr-Year" removed - I know how to remove the actual label but I want to hide the column that displays the label. Thanks, Kris

Re: Question regarding hiding column header in pivot table.

senpradip007 — Mon, 25 Aug 2014 12:14:33 GMT

Go through this thread http://community.qlik.com/thread/129740

Re: Question regarding hiding column header in pivot table.

ashfaq_haseeb — Mon, 25 Aug 2014 12:16:58 GMT

Hi,

Go to char properties --> Presentation tab --> Select your dimension that you want to remove partial sum and uncheck show partial sum.

Regards

ASHFAQ

Re: Question regarding hiding column header in pivot table.

qlikoqlik — Mon, 25 Aug 2014 12:25:26 GMT

HI Kris

Select the dimension and write the below in the box for Enable conditional

Thanks and regards

Padma

Re: Question regarding hiding column header in pivot table.

Mon, 25 Aug 2014 12:29:42 GMT

Thanks qlikoqlik, but that didn't work in my case - it removed all my QtrYear columns except for one and I need the breakdown by qtryear.

Re: Question regarding hiding column header in pivot table.

Mon, 25 Aug 2014 12:31:04 GMT

thanks Ashfaq - my show partial sums was unchecked already. I'm thinking it's not possible in a pivot.

Re: Question regarding hiding column header in pivot table.

qv_jagan — Mon, 25 Aug 2014 13:00:52 GMT

Hi Kris,

You should have to either write separate expression for each quarter else nothing can be done.

But if you want to hide the column header, then select the dimension, write the below in the label, you header name will vanish.

Write it in the Label:

=''

Hope this helps.

Thanks,

Jagan. V

Re: Question regarding hiding column header in pivot table.

nigel987 — Tue, 11 Aug 2015 09:24:30 GMT

Thanks, that's a good hint. Nevertheless, the border line will be visible and it seems as if you cannot make it smaller.