how to create conditional color of pivot background

[#1]

hi

i create a pivot table - see photo .

now i want to color the ACTUAL background  in one color and the PLAN background in another color

both (ACTUAL and PLAN) are value of the same field

how can do it  ?

thank you

[jagan]

Hi,

I just downloaded your file and didn't done any changes, it is working as expected, the expression in your file is

=if(type='Actual',Red(), Green())

Which version of Qlikview are you using?

Regards,

Jagan.

[ashfaq_haseeb]

Hi,

What version of Qlik you use?

may be you need to upgrade.

No changes done in  your app.

Regards

ASHFAQ

[#4]

11.00.11282.0 SR1

[ashfaq_haseeb · Accepted solution]

This is very old version of qlik

Consider upgrading to latest version. Which is 11.2 sr9 for timebeing.

Hope it helps

Regards

ASHFAQ

[jagan]

Hi,

Try to close the app and create the same chart again, may be sometimes this will fix.

Regards,

Jagan.

[#7]

so this is why it doesn't work ?

it should not work in my version ? it is a new thing ?

[#8]

i update the version and it is solved