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

[harithad95156]

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

[MayilVahanan · Accepted solution]

Hi 

Try like this

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

[harithad95156]

Thank you.