Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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

Tags (1)
1 Solution

Accepted Solutions
shaik_basha
Contributor III

Re: Pivot-table background color issues...

Hi,

   Please find the attachment of applicaton.

Regards

8 Replies
shaik_basha
Contributor III

Re: Pivot-table background color issues...

Hi,

   can you give test applicatio.

Regards

Not applicable

Re: Pivot-table background color issues...

Sure. I attached a QVW. Thanks!

shaik_basha
Contributor III

Re: Pivot-table background color issues...

Hi,

   Please find the attachment of applicaton.

Regards

Not applicable

Re: Pivot-table background color issues...

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

srinivasa1
Contributor

Re: Pivot-table background color issues...

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

Technical='Technical'

Gabriel
Valued Contributor II

Re: Pivot-table background color issues...

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

Re: Pivot-table background color issues...

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

Re: Pivot-table background color issues...

Final Output

2013-01-31_150832.png

Community Browser