Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
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
Creator III
Creator III

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

View solution in original post

ngulliver
Partner
Partner

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

prakash743
Contributor III
Contributor III

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
Partner

this solution doesn't work in webview and accesspoint

jim_chan
Creator III
Creator III

did you manage to create the column header?