topic Re: Bad Dynamic Color display in Pivot Table in QlikView

Bad Dynamic Color display in Pivot Table

Mon, 06 Oct 2014 11:42:52 GMT

Hi everybody, I'm facing trouble while displaying Pivot partial sum color, based on Dimension 1 value

Even if I put a formula through 'Custom format cell', it doesn't work properly.........what I expect is to

see the same color, based on DImension 1 value alla long the expressions displayed

Any idea?

qvw enclosed.

Thanks a lot,

Michaël

Anonymous — Mon, 06 Oct 2014 14:07:20 GMT

If I got the request right:
1. Remove custom format cells

2. Remove Row()=0 condition from all expressions

See attached (I tried a few expressions and all dimensions on the bottom chart)

Mon, 06 Oct 2014 14:14:26 GMT

Hi Michael, thanks a lot for your post. But this is not exactly the layout I try to implement. Target is that one:

Thanks. Michael.

Anonymous — Mon, 06 Oct 2014 14:25:04 GMT

In this case, replace Row(0)=0 with Dimensionality()=1 in all your expressions. and the 2nd and 3rd dimensions

Mon, 06 Oct 2014 14:41:50 GMT

Cool Michael! Many thanks!