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: 
Anonymous
Not applicable

pivot dimension background color without expression

Dear Community,

we noticed that if we use a pivot without an expression, we can not set the background color of dimensions.

Is there any possibility how to achive that?

We need the pivot as it groups fields, but we dont have an expression. Maybe hiding an dummy expression would be a solution?

1 Solution

Accepted Solutions
Not applicable
Author

first go to settings>document properties>general and check that styling mode is set to  advanced.

now right click on pivot table > select custom format cell>click on background colour and choose colour

hope this works

View solution in original post

9 Replies
Not applicable
Author

first go to settings>document properties>general and check that styling mode is set to  advanced.

now right click on pivot table > select custom format cell>click on background colour and choose colour

hope this works

buzzy996
Master II
Master II

see this,Capture.PNG

Anonymous
Not applicable
Author

Hi Shiva, your example has a expression, thats what we dont want!

Anonymous
Not applicable
Author

Hi Sana, your answer is correct, you just forgot to mention that we have to active "Design Grid.

Thanks!

buzzy996
Master II
Master II

ur right,but the background color is applied only for dimensions objects..so u can do the same on ur pivot table whether ur have expression or even if u don't ve expression.

Anonymous
Not applicable
Author

Thats the point if you dont have an expression it will not work...

Then you have to use "custom format cell", which was mentioned by Sana.

buzzy996
Master II
Master II

ya,even tht's other option..i never tried with out expression..so i thought it'll works

Anonymous
Not applicable
Author

If we now use an expression for the background color (matching value of row) of the custom format cell, and the expression matches a value in one row, all rows get colored.

Is there any way how we can achive this, that only the row with the matched value gets colored while using custom format cell with an expression?

Not applicable
Author

Custom Format cell only used to color the Header fields only (Table Field Name BG)