topic Re: Pivot-table background color issues... in QlikView

Pivot-table background color issues...

Mon, 04 Feb 2013 18:42:50 GMT

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.

Thank you all,

Brian

Anonymous — Mon, 04 Feb 2013 19:02:15 GMT

Hi,

can you give test applicatio.

Regards

Mon, 04 Feb 2013 19:09:58 GMT

Sure. I attached a QVW. Thanks!

Anonymous — Mon, 04 Feb 2013 19:51:25 GMT

Hi,

Please find the attachment of applicaton.

Regards

Mon, 04 Feb 2013 20:02:45 GMT

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

srinivasa1 — Mon, 04 Feb 2013 20:27:10 GMT

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

Technical='Technical'

Gabriel — Mon, 04 Feb 2013 20:41:47 GMT

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

Mon, 04 Feb 2013 20:56:32 GMT

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...

Mon, 04 Feb 2013 20:58:33 GMT

Final Output