topic pivot chart options in App Development

pivot chart options

krishnagutha1294 — Fri, 31 Jul 2020 04:38:18 GMT

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

Re: pivot chart options

krishnagutha1294 — Fri, 31 Jul 2020 05:51:58 GMT

pls can any one reply it

Thanks

Re: pivot chart options

EricDraven — Fri, 31 Jul 2020 12:18:43 GMT

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.