Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pivot-table background color issues...

I have a pivot table with Background expressions. I would like to prevent the color 'bleeding' into the Dimension columns below

I tried the right click 'Custom Format Cell' option but no luck. It simply is overidden by the expression!

Option 1

If(Technical='G',LightGreen(),If(Technical='R',LightRed(),If(Technical='Y',Yellow(255),White() )))

I changed the order of the white color fucntion but no change.

Option 2

If(Costs='Costs',White(),If(Costs='G',LightGreen(),If(Costs='R',LightRed(),If(Costs='Y',Yellow(255) ))))

The area highlighted in red is the area of concern.

2013-02-04_133314.png

Thank you all,

Brian

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Hi,

   Please find the attachment of applicaton.

Regards

View solution in original post

8 Replies
Anonymous
Not applicable
Author

Hi,

   can you give test applicatio.

Regards

Not applicable
Author

Sure. I attached a QVW. Thanks!

Anonymous
Not applicable
Author

Hi,

   Please find the attachment of applicaton.

Regards

Not applicable
Author

Very Nice. What was done to fix it?  It looks like you swithced it to a Straight table?

srinivasa1
Creator II
Creator II

Nice.he has checked each experssion value background and defined color condtion eg.

Technical='Technical'

Gabriel
Partner - Specialist III
Partner - Specialist III

Hi Shaik,

This is my thinking, apologies if it offend you.

I think it is good practise to write out the expression for all of us to learn from. Not everyone will be able to open the attachement.

Regards,

Gabriel

Not applicable
Author

What he also did is was change it to Straight table and used Horizontal presentation.

This allowed more flexibility or prevented the labels from being colored over.

Now I look back the Pivot table was the wrong way to set this up in hindsight...

2013-02-04_155449.png

Not applicable
Author

Final Output

2013-01-31_150832.png