Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

james
Contributor III

Full Accumulation and Background Color in a chart

All -  I have a bar and a line chart created where the line has full accum on it. I created an expression for the background color to be 

if(column(3)-column(2) < 0,RED(),Green()).

The issue is even thought the line is full accum, the expression for colors is only looked at for each month.

Any ideas?

1 Solution

Accepted Solutions
james
Contributor III

Full Accumulation and Background Color in a chart

=if(rangesum(Above(column(4),0,Month))<0.RED(),GREEN())

1 Reply
james
Contributor III

Full Accumulation and Background Color in a chart

=if(rangesum(Above(column(4),0,Month))<0.RED(),GREEN())

Community Browser