Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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

Conditional Formatting - Pivot Table(Header Row Issue)

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.

1 Solution

Accepted Solutions
Highlighted
Champion II
Champion II

Hi @Marjan,

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

View solution in original post

4 Replies
Highlighted
MVP
MVP

Right Click on Header

Select Custom Format Cell

You can find settings here

Highlighted
Contributor
Contributor

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?

Highlighted
Creator III
Creator III

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

Highlighted
Champion II
Champion II

Hi @Marjan,

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

View solution in original post