topic Backgroud Color Pivot Table in QlikView

Backgroud Color Pivot Table

Anonymous — Thu, 10 Nov 2016 13:46:26 GMT

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 — Thu, 10 Nov 2016 17:48:48 GMT

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 — Thu, 10 Nov 2016 19:41:15 GMT

Thanks...But a find the problem.

Cell Background color transparency was 100%...

Sorry!!

hectorvega — Thu, 10 Nov 2016 19:51:23 GMT

Any time, your welcome. H