topic Re: How to colour the diagonal values in Pivot table? in QlikView

How to colour the diagonal values in Pivot table?

Thu, 24 Apr 2014 15:12:19 GMT

Hi,

I have the Pivot chart with data which is in attached. I would need to colour the diagonal values which is in Pivot table. Please can anyone suggest me is it possible?

Thanks.

Re: How to colour the diagonal values in Pivot table?

Thu, 24 Apr 2014 15:12:49 GMT

Please see attached.

Re: How to colour the diagonal values in Pivot table?

eduardo_sommer — Thu, 24 Apr 2014 17:35:18 GMT

Try using this in the background color property of the expression:

if (RowNo() = ColumnNo(), LightRed())

Re: How to colour the diagonal values in Pivot table?

Fri, 25 Apr 2014 08:44:00 GMT

Thanks. How can I change for all diagonal values. Please suggest me.

EDIT: I tried using the below it is changing the colour. But I need exact change in the diagonals. Please help me. please see attached.

if (RowNo() = ColumnNo(), LightRed(),

If(RowNo() <ColumnNo(), Green()))

Re: How to colour the diagonal values in Pivot table?

Fri, 25 Apr 2014 09:36:51 GMT

Found the answer.

If (RowNo() = ColumnNo(), White(),

If(RowNo() < ColumnNo(), LightRed(100),

If(RowNo() > ColumnNo(), LightGreen(120))))