Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
nenadvukovic
Creator III
Creator III

Color coding with Full Accumulation expressions is not as expected

Hi,

Can you please take a look into the provided example and help me fix this issue. I would expect to see the second bar colored in red, and it is colored in green because the period 2 is green, but cumulative it is red.

Here is the screenshot and the test qvw file attached.

Thanks

FullAccumulation 2017-04-06_11-24-40.jpg

1 Solution

Accepted Solutions
sunny_talwar

Try this for background color

if(RangeSum(Above(sum(Measure1) + sum(Measure2) - sum(Plan), 0, RowNo())) < 0, lightred(), lightgreen())

View solution in original post

2 Replies
sunny_talwar

Try this for background color

if(RangeSum(Above(sum(Measure1) + sum(Measure2) - sum(Plan), 0, RowNo())) < 0, lightred(), lightgreen())

nenadvukovic
Creator III
Creator III
Author

Great Sunny. Thank you