Conditional Formatting - Pivot Table(Header Row Issue)

[Anonymous]

Hello Guys,

I want to do conditional formatting in Qlikview Pivot table but facing issue It is formatting Header Row as well .I have uploaded both Raw Data Excel/Sample output sheet and my QVW solution.

Here I am giving code in Expression's Background but It is also formatting Header Row.

Please help.

[MK_QSL]

Right Click on Header

Select Custom Format Cell

You can find settings here

[Anonymous]

Thanks for the reply but not what I want(My appologies, I think I have not stuctured correctly)

I have added conditional formatting for column 'YTD YoY %' which is working fine.

Only problem is with Header Cell  'YTD YoY %'. This cell is also getting colored automatically.

I am Using Qlikview Ver 11.

Is there any workaround to avoid this?

[marjan_it]

what do you mean getting colored automatically?

getting colored in what basis.

you can right click in header cell and select custom format cell and in background color write your epression like the image

[vinieme12 · Accepted solution]

Hi @Marjan,

This is a Bug in Qlikview Version 11, where expression formatting is also applied to the expression header.