topic How to code background color expression in Qlik view for a pie chart in which the values are in relative mode (%)? in QlikView

How to code background color expression in Qlik view for a pie chart in which the values are in relative mode (%)?

harithad95156 — Sun, 14 Mar 2021 13:48:21 GMT

=if(sum({$<Year={'$(=max(Year))'}>}Sales_amount)>12.00,green(),red())=====while evaluating this expression showing only first color for all the values.

Re: How to code background color expression in Qlik view for a pie chart in which the values are in relative mode (%)?

MayilVahanan — Mon, 15 Mar 2021 07:06:00 GMT

Try like this

=if(sum({$<Year={'$(=max(Year))'}>}Sales_amount) / sum({$<Year={'$(=max(Year))'}>}Total Sales_amount) >0.12,green(),red())

Re: How to code background color expression in Qlik view for a pie chart in which the values are in relative mode (%)?

harithad95156 — Mon, 15 Mar 2021 08:45:19 GMT

Thank you.