topic Re: Hide the column name in pivot table in QlikView

Hide the column name in pivot table

Mon, 18 Aug 2014 10:53:19 GMT

Hi QVers,

I'm development a pivot table and have the year on the columns as follows:

But we want to remove the "Year" as it creates an empty column. But in the Dimensions tab of Chart Properties, the option of "Label" check box is grey out.

Is there anyone knowing a way to hide/remove "Year"?

Or put it on top of 2011/2012/2014 like the following?

| Year |

| 2011| 2012| 2014|

Thanks very much!

Best Regards,

Crystal

Re: Hide the column name in pivot table

senpradip007 — Mon, 18 Aug 2014 10:57:01 GMT

In Dimension tab give a space in the label of the Year diemsnsions.

Hope it helps.

Re: Hide the column name in pivot table

ashfaq_haseeb — Mon, 18 Aug 2014 11:06:17 GMT

This comes by Default I thing you cannot get rid of the same while exporting to excel.

In front end follow pradeep suggestion and make sure to reduce width of that column as much as you can.

Regards

ASHFAQ

Re: Hide the column name in pivot table

Mon, 18 Aug 2014 11:13:55 GMT

Thanks for the suggestions, but we still get that little square on the header. If we cannot hide it, can we put it on the years to be another row on top?

Re: Hide the column name in pivot table

engishfaque — Mon, 18 Aug 2014 11:17:42 GMT

Dear Crystal,

Do it when you are importing data source in Edit Script.

Edit Script

Edit Script > Tab "Data" > Table Files > Select Data Source > Next > Enable Transformation Step > Garbage > Select Year Column > Click on Button "Delete Marked" > Next > Finish.

Kind regards,

Ishfaque Ahmed

Re: Hide the column name in pivot table

Wed, 20 Aug 2014 04:00:07 GMT

Hi Ishfaque,

Isn't this process removing the Year data from the begining? Then how can I put year into the pivot table it didn't exist in the data model? Thanks!

Crystal

Re: Hide the column name in pivot table

Anonymous — Wed, 20 Aug 2014 04:15:40 GMT

Hi,

hide column is not possible in Pivot table ,Column hiding is possible in Straight table,

In straight table>Properties>Presentation>select the column below we have the option Hide Column select it

and apply

Re: Hide the column name in pivot table

Anonymous — Thu, 07 Sep 2017 15:27:39 GMT

To remove the column headers:

Right click on object --> Properties... --> Presentation Tab --> check "Surpress Header Row"

You welcome.