topic Re: How to color code only the difference in a pivot table? in QlikView

How to color code only the difference in a pivot table?

nenadvukovic — Wed, 14 Mar 2018 13:13:15 GMT

Hi,

Can anyone please take a look and help me get what I want?

It's about marking in different colour only cells that differ from the cell above.

Re: How to color code only the difference in a pivot table?

fvelascog72 — Wed, 14 Mar 2018 14:48:35 GMT

Hi,

Try this in Color Text in Expression:

=if(Above(TOTAL sum(Exp1), 1,1) <> Sum(Exp1) and not IsNull(Above(TOTAL sum(Exp1), 1,1)) , lightred())

Saludos

Re: How to color code only the difference in a pivot table?

nenadvukovic — Wed, 14 Mar 2018 15:18:03 GMT

Hola Federico,

That is better but still not good enough if it is applied to a more realistic data than initially provided:

Gracias

Re: How to color code only the difference in a pivot table?

fvelascog72 — Wed, 14 Mar 2018 15:24:39 GMT

Hi,

Could you share this dataset?

Saludos.

Re: How to color code only the difference in a pivot table?

nenadvukovic — Wed, 14 Mar 2018 15:30:43 GMT

Test:

load * inline [

Dim1, Dim2, Dim3, Dim4, Exp1, Exp2

A, C1, D1, E1, 30, 1459

A, C2, D1, E1, 30, 1459

A, C1, D2, E1, 40, 1953

A, C2, D2, E1, 40, 1953

A, C1, D2, E2, 43, 2094

A, C2, D2, E2, 43, 2094

A, C1, D2, E3, 50, 2444

A, C2, D2, E3, 90, 4399

A, C1, D3, E1, 20, 1005

A, C2, D3, E1, 20, 1005

];

Re: How to color code only the difference in a pivot table?

fvelascog72 — Wed, 14 Mar 2018 15:37:34 GMT

Hi,

I tried with:

=if(Above(TOTAL sum(Exp1), 1,1) <> Sum(Exp1) and not IsNull(Above(TOTAL sum(Exp1), 1,1)) and not IsNull(Above(Dimensionality())), lightred())

and seeem to work.

Saludos.

Re: How to color code only the difference in a pivot table?

nenadvukovic — Wed, 14 Mar 2018 15:42:47 GMT

Indeed.

Thank you very much

Re: How to color code only the difference in a pivot table?

fvelascog72 — Wed, 14 Mar 2018 15:49:28 GMT

You´re welcome