Arrows in Straight table with text

[#1]

Hi All

I have a straight table with text, i need to show arrows in same column along with the same condition,

Used and , & operator did not work.

Expression I have

=if([Percentage]>0 and [Percentage] <=0.4, rgb(255,0,0),

if([Percentage] >0.4 and [Percentage] <=0.7, rgb(255,255,0),

if([Percentage] >0.7 and [Percentage]<=1, rgb(0,255,0),

Need to show like this

Thank you

[#2]

Hi

if([Percentage]>0 and [Percentage] <=0.4,'qmem://<bundled>/BuiltIn/arrow_n_g.png','qmem://<bundled>/BuiltIn/arrow_s_r.png')

-or-

=if([Percentage]>0 and [Percentage] <=0.4,'qmem://<bundled>/BuiltIn/arrow_s.png',

if([Percentage] >0.4 and [Percentage] <=0.7,'qmem://<bundled>/BuiltIn/arrow_s_g.png',

if([Percentage] >0.7 and [Percentage]<=1,'qmem://<bundled>/BuiltIn/arrow_s_r.png',

[amit_saini]

Hi,

Follow this:

http://community.qlik.com/message/348079#348079

Thanks,

AS

[#4]

Hi Harshal,

Thank you but i should also have the cell color and arrow (to show trend) need both in same cell.

[Roop]

To do exactly what you require - I don't think that it is possible but you can get somewhere near by applying different ways of the system appearing as though they are the same column. It is not exact bu hope it helps.

[#6]

Thank you all.