Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

formatting in pivot table....urgent

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???

1 Solution

Accepted Solutions
Sokkorn
Master
Master

Hi vitulgaur,

Let do this:

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

1.png

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

2.png

3. Play around what you want to achieve

3.png

Hope this help.

Regards,

Sokkorn

View solution in original post

9 Replies
vincent_ardiet
Specialist
Specialist

Hi,

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

Regards,

Vincent

Sokkorn
Master
Master

Hi vitulgaur,

Let do this:

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

1.png

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

2.png

3. Play around what you want to achieve

3.png

Hope this help.

Regards,

Sokkorn

ngulliver
Partner - Specialist III
Partner - Specialist III

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
Master
Master

Hi Neil,

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

Regards,

Sokkorn

Not applicable
Author

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

Anonymous
Not applicable
Author

Hi,

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

Defect DetailsTest Execution
TesterDefect CountAssigned ToPassedFailed
         

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

thanks,

Prakash

jafari_ervin
Creator III
Creator III

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
Partner - Creator
Partner - Creator

this solution doesn't work in webview and accesspoint

jim_chan
Specialist
Specialist

did you manage to create the column header?