Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
This is very old version of qlik
Consider upgrading to latest version. Which is 11.2 sr9 for timebeing.
Hope it helps
Regards
ASHFAQ
Hi
You want to color Header only or entire content?
Can you post sample app?
Regards
ASHFAQ
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
hi only the header
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
hi
no there not an expressions .
they value of the same dimension
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
hi Try:
in background color:
pick(match(machine,'Actual','Plan'),Red(),Blue())
Regards
KC
hi
no there not an expressions !!
they value of the same dimension
if i do it both will be in the same color
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.