topic Re: Pivot Table Column Format in QlikView

Pivot Table Column Format

upaliwije — Wed, 06 Aug 2014 04:56:40 GMT

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

Pls help me how to do it

avinashelite — Wed, 06 Aug 2014 05:00:37 GMT

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

Wed, 06 Aug 2014 05:02:31 GMT

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 — Wed, 06 Aug 2014 05:15:02 GMT

thanks for your reply

Pls explain me the steps clearly

aveeeeeee7en — Wed, 06 Aug 2014 05:17:42 GMT

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 — Wed, 06 Aug 2014 05:21:02 GMT

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 — Wed, 06 Aug 2014 05:24:10 GMT

Thanks Nag

It is working