Visual Cues - not working

[#1]

Hi

in the Value by engine table. I want to show green or red depending on the previous years column. I cant seem to get it to work.

I have tried integrating AGGR into the function but no joy. (you will see this in the 2013 column)

can anybody help?

Thanks

[m_woolf]

I couldn't make it work either with Visual Cues.

You can set the Text Color for the 2013 Value expression to:

if(sum( {$<year_of_sale = {2013}>} value  ) >= sum( {$<year_of_sale = {2012}>} value  ),Green(),Red())

Same method should work for the other columns as well.

[#3]

HI Michael

How do I do this? Which section? The
font tab will not allow me to change coloyur.

Regards

[#4]

HI Michael

How do I do this? Which section? The font tab will not allow me to change coloyur.

Regards

[m_woolf]

On the expressions tab, click the + in front of the expression. Then click on Background Color.

[#6]

Hi Michael

Thanks for the reply. This doesn't work either. once tested. It appears some work. and some don't. does any aggr need to be done?

Regards

[m_woolf]

can you post a qvw with one that doesn't work?