Discussion Board for collaboration on QlikView Scripting.
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?
Go to Solution.
For background color on a column expression, click on the plus sign and choose background color, then write something like :
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!
Thanks...But a find the problem.
Cell Background color transparency was 100%...
Any time, your welcome. H