Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
matheus_silva
Contributor

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
New Contributor III

Re: Backgroud Color Pivot Table

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!

3 Replies
hectorvega
New Contributor III

Re: Backgroud Color Pivot Table

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!

matheus_silva
Contributor

Re: Backgroud Color Pivot Table

Thanks...But a find the problem.

Cell Background color transparency was 100%...

Sorry!!

hectorvega
New Contributor III

Re: Backgroud Color Pivot Table

Any time, your welcome. H

Community Browser