topic Re: pivot dimension background color without expression in QlikView

pivot dimension background color without expression

Anonymous — Fri, 24 Apr 2015 10:13:21 GMT

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?

Re: pivot dimension background color without expression

Fri, 24 Apr 2015 10:46:57 GMT

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

Re: pivot dimension background color without expression

buzzy996 — Fri, 24 Apr 2015 10:55:35 GMT

see this,

Re: pivot dimension background color without expression

Anonymous — Fri, 24 Apr 2015 11:06:19 GMT

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

Re: pivot dimension background color without expression

Anonymous — Fri, 24 Apr 2015 11:07:33 GMT

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

Thanks!

Re: pivot dimension background color without expression

buzzy996 — Fri, 24 Apr 2015 11:09:40 GMT

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.

Re: pivot dimension background color without expression

Anonymous — Fri, 24 Apr 2015 11:12:59 GMT

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.

Re: pivot dimension background color without expression

buzzy996 — Fri, 24 Apr 2015 11:14:23 GMT

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

Re: pivot dimension background color without expression

Anonymous — Fri, 24 Apr 2015 12:37:15 GMT

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?

Re: pivot dimension background color without expression

Tue, 28 Apr 2015 13:33:10 GMT

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