topic Re: formatting in pivot table....urgent in QlikView

formatting in pivot table....urgent

Tue, 08 May 2012 06:13:20 GMT

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

Re: formatting in pivot table....urgent

vincent_ardiet — Tue, 08 May 2012 06:21:16 GMT

Hi,

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

Regards,

Vincent

Re: formatting in pivot table....urgent

Sokkorn — Tue, 08 May 2012 09:49:15 GMT

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

Re: formatting in pivot table....urgent

ngulliver — Wed, 09 May 2012 13:47:57 GMT

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

Re: formatting in pivot table....urgent

Sokkorn — Thu, 10 May 2012 00:43:41 GMT

Hi Neil,

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

Regards,

Sokkorn

Re: formatting in pivot table....urgent

Sun, 06 Jul 2014 05:02:25 GMT

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

Re: formatting in pivot table....urgent

Anonymous — Wed, 27 Aug 2014 06:51:33 GMT

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

Re: formatting in pivot table....urgent

jafari_ervin — Wed, 31 Dec 2014 21:48:37 GMT

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

Re: formatting in pivot table....urgent

rendiyan — Fri, 27 May 2016 04:09:02 GMT

this solution doesn't work in webview and accesspoint

Re: formatting in pivot table....urgent

jim_chan — Fri, 14 Oct 2016 03:04:55 GMT

did you manage to create the column header?