topic Re: Visual Cues - not working in QlikView

Visual Cues - not working

Fri, 06 Sep 2013 13:57:16 GMT

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 — Fri, 06 Sep 2013 14:45:10 GMT

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.

Mon, 09 Sep 2013 08:13:36 GMT

HI Michael

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

Regards

Mon, 09 Sep 2013 08:15:43 GMT

HI Michael

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

Regards

m_woolf — Mon, 09 Sep 2013 11:12:26 GMT

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

Mon, 09 Sep 2013 11:47:06 GMT

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 — Mon, 09 Sep 2013 11:52:06 GMT

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