Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

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

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.2018-03-14_14-08-34.png

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

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.

View solution in original post

7 Replies
Highlighted
Partner
Partner

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

Highlighted
Creator III
Creator III

Hola Federico,

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

Gracias2018-03-14_16-15-28.png

Highlighted
Partner
Partner

Hi,

Could you share this dataset?

Saludos.

Highlighted
Creator III
Creator III

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

];

Highlighted
Partner
Partner

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.

View solution in original post

Highlighted
Creator III
Creator III

Indeed.

Thank you very much

Highlighted
Partner
Partner

You´re welcome