formatting in pivot table....urgent

[#1]

hi

i am usig a pivot table in my qlikview report and i am using only 1 dimension as a row and i have used 12 different expressions to create 12 columns.

now i want to change the color of the column header cells and their font size....

also i need to change the colour of the expression total row as well as its font size???

how cn i achieve that???

[vincent_ardiet]

Hi,

Have a look to this post and my answer : http://community.qlik.com/message/216813#216813

Regards,

Vincent

[Sokkorn · Accepted solution]

Hi vitulgaur,

Let do this:

1. Goto Settings ==> User Preferences ==> Design

2. Right click on any cell in pivot object ==> Custom Format Cell

3. Play around what you want to achieve

Hope this help.

Regards,

Sokkorn

[ngulliver]

Hi, Sokkorn.

This is an excellent piece of advice. I did not know about this.

Vitulgaur - if this meets your requirements, please make sure you mark this question as answered so that other people can find this more easily.

Thanks,

Neil

[Sokkorn]

Hi Neil,

No one know all in QlikView. If we are explore then we can get more idea .

Regards,

Sokkorn

[#6]

Hi , is it possible to resize one column in pivot table or cross table

[Anonymous]

Hi,

Is there a way to group a column headers like this in PIVOT TABLE?

Defect Details		Test Execution
Tester	Defect Count	Assigned To	Passed	Failed

I'm tried with text object(for Defect Details & Test Execution ) but not suitable for dynamic values & tree structures.

thanks,

Prakash

[jafari_ervin]

If you have defect detail and test execution in the field then put this field in the dimension and drag it up. then your pivot table will be look like this

[rendiyan]

this solution doesn't work in webview and accesspoint

[jim_chan]

did you manage to create the column header?