Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
May 18th 10AM ET, Live Chat, bring your QlikView questions. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
harithad95156
Contributor
Contributor

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

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

1 Solution

Accepted Solutions
MayilVahanan

Hi 

Try like this

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

Thanks & Regards,
Mayil Vahanan R

View solution in original post

2 Replies
MayilVahanan

Hi 

Try like this

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

Thanks & Regards,
Mayil Vahanan R

View solution in original post

harithad95156
Contributor
Contributor
Author

Thank you.