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

[ashfaq_haseeb]

Hi

You want to color Header only or entire content?

Can you post sample app?

Regards

ASHFAQ

[jyothish8807]

Hi,

Try like this:

if both Actual and plan are different expression then:

On the expression tab.. click on the + sign-- go to background color--> red()

same for second expression--> blue

Regards

KC

[#4]

hi only the header

[ashfaq_haseeb]

HI,

Then you need to look at custom format cell.

have a look at below link

http://community.qlik.com/message/622078#622078

Let me know if that worked.

Regards

ASHFAQ

[#6]

hi

no there not an expressions .

they value of the same dimension

[#7]

hi

i try to do it i go to "costume format cell' -- background -- calculate -- and if(type='Actual',Red())

nothing happen. and after i click 'ok' and went back to costume format cell , it did't save the formula

[jyothish8807]

hi Try:

in background color:

pick(match(machine,'Actual','Plan'),Red(),Blue())

Regards

KC

[#9]

hi

no there not an expressions  !!

they value of the same dimension

if i do it both will be in the same color

[jagan]

Hi,

Try like this

Properties -> Dimension -> Click on the Dimension -> Expand + -> Click on Background color and edit and give the expression below

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

Hope this helps you.

Regards,

jagan.