pivot chart options

[krishnagutha1294]

Hi all i have a requirement like below

if goal is Greater than Actual then it should be green and if goal is less than actual then it red color how we should change the settings to appear like this.

Thanks in Advance

[krishnagutha1294]

pls can any one reply it

Thanks

[EricDraven]

if(goal > Actual,RGB(19, 214, 71),RGB(214, 19, 19)

paste into the background color field. Remember though, with Qlik Sense you can only change the BG color of the measures side of a pivot table.

Here is an example of nesting them together.