topic Color coding with Full Accumulation expressions is not as expected in QlikView

Color coding with Full Accumulation expressions is not as expected

nenadvukovic — Thu, 06 Apr 2017 09:34:33 GMT

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

Re: Color coding with Full Accumulation expressions is not as expected

sunny_talwar — Thu, 06 Apr 2017 09:37:09 GMT

Try this for background color

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

Re: Color coding with Full Accumulation expressions is not as expected

nenadvukovic — Thu, 06 Apr 2017 09:41:38 GMT

Great Sunny. Thank you