topic Re: color pivot cells in QlikView

color pivot cells

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

i need help with colouring cell as below ('Sales' and 'Margin' for every region). What i can do is only color the expression, but the name needs to have the same.

Can someone help me please? File is attached.

Thanks a lot

Tommy

Re: color pivot cells

el_aprendiz111 — Fri, 28 Oct 2016 21:39:45 GMT

Hi,

1-Example

Re: color pivot cells

Fri, 28 Oct 2016 22:04:17 GMT

Hi this is not what i need,

I need to color cell with text 'Sales' and 'Margin'.

Not the values and not the header.

Thanks

Tommy

Re: color pivot cells

el_aprendiz111 — Fri, 28 Oct 2016 22:28:56 GMT

Hi,

Re: color pivot cells

johnw — Fri, 28 Oct 2016 22:34:42 GMT

In case someone can learn something from my failure, I tried it like this:

Expressions:
LOAD
dual(Expression,recno()) as Expression
,rgb(R,G,B) as Color
INLINE [
Expression,R,G,B
Volume,255,255,255
Sales,255,255,153
Margin,205,205,153
];

Chart expression = pick(Expression,sum(Volume),sum(Sales),1)

Background color expression = Color

But it fails because there isn't data in all the cells, so Color is often undefined, so cells that should be colored are white, and it looks worse then where we started.

Re: color pivot cells

johnw — Fri, 28 Oct 2016 22:35:11 GMT

Unfortunately, Volume isn't a category - it's the label for an expression.