4 Replies Latest reply: May 22, 2012 9:02 AM by Syed Khaled Shahbaaz RSS

If Condition in A Chart or Text Object!

Syed Khaled Shahbaaz

Hi,

 

I am trying to use if condition in a straight table / text object to display images as follows:

 

(value<40%), display green color

(value>40%) and (value<70%), display yellow color

(value > 70%), display red color

 

The only problem is that it does not display red color, instead display only green and yellow color.

 

I have used the following expression. Probably it needs some modification. Can somebody please suggest?

 

=if((value<40),'qmem://<bundled>/BuiltIn/led_g.png',

         if((value>41)&(marks1<70),'qmem://<bundled>/BuiltIn/led_y.png',

              'qmem://<bundled>/BuiltIn/led_r.png')

)

 

 

Regards & Thanks,

 

- Khaled