Discussion Board for collaboration related to QlikView App Development.
I have a requirement to dynamically change the individual cell color of a Pivot table
I have a Slider objects for different filters which are used as dimension in the Pivot Table. When I change the slider values the dimension values will change in the Pivot table.
Here I have three different slider objects for AA,BB,CC.
1.My requirement is when I change SliderAA the cell value of AA
should have either Blue background or font color of the cell should change from black to blue and all other cells should have black .
2.When I change SliderBB the cell value of BB
should have either Green background or font color of the cell should change from black to Green and rest should have black.
Likewise for rest of the dimension values.
Please give me your suggestions on this.
Try like this
Properties -> Expression -> Click on expression -> Expand + sign -> Background color-> and give below expession
If(Dimension = 'AA', RGB(0, 0, vAAVariable),
If(Dimension = 'BB', RGB(0, vBBVariable, 0), RGB(0, 0, 0)))
Hope this helps you.
Background option will change the color of the entire column when any one of these conditions are satisfied
but here i need to change the color of a single cell dynamically.
If you share sample file and explain your requirement clearly then it would easier to give solution. If you want to apply background color for a specific cell then you have use condition like below
=If(DimensionName = 'Some Value', RGB(0, 0, vAAVariable))