Pivot Table Column Format

[upaliwije]

I have Pivot table and I want show the Column Label in Bold

Pls help me how to do it

[avinashelite]

Hi Upail,

To achieve this go for custom formatting.

Steps:1.select Design grid

          2.Click on chart properties and you will see custom formating.

          3.Use this on each column

[#3]

Go to chart properties->dimension tab->under used dimension click on + icon and it will expand option

click on text format and type '<B>' this makes column bold

see the snapshot

hope this solve your query

Bhawna

[upaliwije]

thanks for your reply

Pls explain me the steps clearly

[aveeeeeee7en · Accepted solution]

Hi

You can achieve this using Custom Format Cell.

First Activate Custom Format Cell on your Qlikview Desktop. Following are the steps:

1) Go to Settings>User Preferences or just Press Cntrl+Alt+U and go to Design Tab and check the option Always Show Design Menu Items. See Below:

2) Right Click on Label Headers of your Pivot Table and select Custom Format Cell Option. See below:

3) After Selecting Custom Format Cell you'll see the below Image. Select Bold and see the Result. You can also play with Colors using this.

Hope that helps.

Regards

Aviral Nag

[avinashelite]

Hi Upali,

To achieve this go for custom formatting.

Steps:

          *Go to View > toolbar> Select design you will the design the toolbar now.

          * from Design toolbar select Design grid option it will be somthing like # this.

          *Click on chart column and  properties ,you will see custom formatting option.

          *Then select the particular column and format it according to your need.

[upaliwije]

Thanks Nag

It is working