topic Re: Conditional Formatting - Pivot Table(Header Row Issue) in QlikView

Conditional Formatting - Pivot Table(Header Row Issue)

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Conditional Formatting - Pivot Table(Header Row Issue)

MK_QSL — Fri, 01 Jul 2016 08:28:13 GMT

Right Click on Header

Select Custom Format Cell

You can find settings here

Re: Conditional Formatting - Pivot Table(Header Row Issue)

Anonymous — Fri, 01 Jul 2016 08:50:56 GMT

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?

Re: Conditional Formatting - Pivot Table(Header Row Issue)

marjan_it — Sat, 02 Jul 2016 09:44:11 GMT

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

Re: Conditional Formatting - Pivot Table(Header Row Issue)

vinieme12 — Sat, 02 Jul 2016 10:28:27 GMT

Hi @Marjan,

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