Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

How to change colors to subtotals in pivot table

Hi Friends,

Is there any way to change the Font Color of subtotals in Pivot Tables.

Thanks

Pavan

Tags (1)
1 Solution

Accepted Solutions

Re: How to change colors to subtotals in pivot table

With the design grid on, right-click the cell and select "Custom Format Cell" and pick the colour you want.

You can add an expression to the change the text colour or background colour of the Expressions.

If you include the dimensionality() function in your colour expression, you can have different colours for different sub-total levels.

e.g.      if(dimensionality() >=2, yellow(), rgb(225,255,255) )

5 Replies

Re: How to change colors to subtotals in pivot table

With the design grid on, right-click the cell and select "Custom Format Cell" and pick the colour you want.

You can add an expression to the change the text colour or background colour of the Expressions.

If you include the dimensionality() function in your colour expression, you can have different colours for different sub-total levels.

e.g.      if(dimensionality() >=2, yellow(), rgb(225,255,255) )

Highlighted
Not applicable

Re: How to change colors to subtotals in pivot table

Use the Dimensionality() function like Albert suggested.

ecolomer
Honored Contributor II

Re: How to change colors to subtotals in pivot table

Also you can put option ON, in View Options Users on User Configuration,  (Sorry because my english isn't good)

And you can click Upper and Ctrl same time to change colors of the cells

p02.png

ecolomer
Honored Contributor II

Re: How to change colors to subtotals in pivot table

Or you can use Dimensionality() in the backgroud colour

p01.png

Re: How to change colors to subtotals in pivot table

Yes there is.

Go to Setting --> user preference --> Design Tab --> Select Always show Design menu items.

Then right click on cell you want to highlight and select Custom format cell. --> apply your required formatting here.

Hope it helps.

Regards

ASHFAQ

Community Browser