Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Partner
Partner

How to dyanamically change the individual cell color os a Pivot table

Hi All

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.

DimensionExpression
AA1
BB2
CC3

Please give me your suggestions on this.

Regards,

Sindu


Tags (1)
3 Replies
MVP & Luminary
MVP & Luminary

Re: How to dyanamically change the individual cell color os a Pivot table

HI,

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.


Regards,

Jagan.

Partner
Partner

Re: How to dyanamically change the individual cell color os a Pivot table

Jagan,

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.

Regards,

Sindu

MVP & Luminary
MVP & Luminary

Re: How to dyanamically change the individual cell color os a Pivot table

Hi,

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))

Hope this helps you.

Regards,

Jagan.