Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Visual Cues - not working

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

6 Replies
m_woolf
Master II
Master II

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.

Not applicable
Author

HI Michael

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

  

Regards

Not applicable
Author

HI Michael

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

Regards

m_woolf
Master II
Master II

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

Not applicable
Author

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
Master II
Master II

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