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: 
Anonymous
Not applicable

Backgroud Color Pivot Table

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

1 Solution

Accepted Solutions
hectorvega
Contributor III
Contributor III

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!

View solution in original post

3 Replies
hectorvega
Contributor III
Contributor III

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
Not applicable
Author

Thanks...But a find the problem.

Cell Background color transparency was 100%...

Sorry!!

hectorvega
Contributor III
Contributor III

Any time, your welcome. H