topic Pivot table coloring in QlikView

Pivot table coloring

Wed, 10 Nov 2010 12:13:29 GMT

Hi,

IN a pivot table I would like to have a red color if my values is not the same. In the enclosed example:

-A works fine because I have the same values

-B works fine because i have different sums

- C does not work because the sum over Dim1 is the same. How can i write an expression that color this red when im looking at Dim1? I tried aggr but t did not get it to work.

Pivot table coloring

renjithpl — Wed, 10 Nov 2010 12:21:14 GMT

Try

if(sum(Value1)<>sum(Value2), RGB(255,0,0), RGB(125, 0,0))

regards

Pivot table coloring

renjithpl — Wed, 10 Nov 2010 12:25:25 GMT

sorry dude, i miss understood your question.

Pivot table coloring

Wed, 10 Nov 2010 12:58:09 GMT

I tried:

if(aggr(sum(Value1),Dim2)<>aggr(sum(Value2),Dim2), RGB(255,0,0))

But that did not help..

Pivot table coloring

johnw — Thu, 11 Nov 2010 01:43:19 GMT

So you want the value in red if ANY of the values at the Dim2 level differ, even when rolled up to just Dim1? If so, I believe this does the trick:

if(min(aggr(sum(Value1)<>sum(Value2),Dim1,Dim2)),lightred())

The min() uses the fact that true() is -1 and false() is 0. So when rolled up, the min() says that if ANY of the values at the Dim2 level differ, then the condition is true.