Solved: Backgroud Color Pivot Table - Qlik Community

Anonymous · ‎2016-11-10

Hi

Guys, i can't change a brackground color in my pivot table...What i did wrong?

For example, i have two dimension, NPS and Hour...in expession i count how many coupon i had for day, in the end make a %...ok.

But i want make a condicion...if % => 50%, green(), if %>=20 and %<= 49 yellow()...and so on so forth....

but when i do this in backgroud color, nothing happens...but if a do the same formula in Text Color it works...why?

Someone can help me?

Thank you!!!

hectorvega · ‎2016-11-10

Hi Mathews,

For background color on a column expression, click on the plus sign and choose background color, then write something like :

if(((Column(2)-Column(3))/column(3))>=0,rgb(90,249,32),rgb(249,35,2) )

This give you a percent from columns 2 and 3... colored by red or green using rgb values.

I hope this tip could serve.

Have a great day!

hectorvega · ‎2016-11-10

Hi Mathews,

For background color on a column expression, click on the plus sign and choose background color, then write something like :

if(((Column(2)-Column(3))/column(3))>=0,rgb(90,249,32),rgb(249,35,2) )

This give you a percent from columns 2 and 3... colored by red or green using rgb values.

I hope this tip could serve.

Have a great day!

Anonymous · ‎2016-11-10

Thanks...But a find the problem.

Cell Background color transparency was 100%...

Sorry!!

hectorvega · ‎2016-11-10

Any time, your welcome. H