Discussion board where members can get started with QlikView.
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.
This is a Bug in Qlikview Version 11, where expression formatting is also applied to the expression header.
View solution in original post
Right Click on Header
Select Custom Format Cell
You can find settings here
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?
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