topic Re: Background Color Chart in QlikView

Background Color Chart

Sun, 01 Dec 2013 05:36:01 GMT

Can anyone help me to solve this problem

I am trying to color the bars on values

If current year values < previous year then make it red else green. It will be applied only on year 2011,2012,2013 as 2010 will be the base year

Many thanks for the help

Sun, 01 Dec 2013 06:50:18 GMT

please check this maybe help you

israrkhan — Sun, 01 Dec 2013 07:38:36 GMT

Hi Sunny,

on your expression tab>> click on expression plus sign to expand the expression,

and put the expression like this if(sale < Previous(sale),Red(),Green()) on Background Color property.