topic Re: Arrows in Straight table with text in QlikView

Arrows in Straight table with text

Thu, 19 Mar 2015 09:55:23 GMT

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

Re: Arrows in Straight table with text

Thu, 19 Mar 2015 09:59:10 GMT

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',

Re: Arrows in Straight table with text

amit_saini — Thu, 19 Mar 2015 10:00:22 GMT

Hi,

Follow this:

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

Thanks,

Re: Arrows in Straight table with text

Thu, 19 Mar 2015 10:12:50 GMT

Hi Harshal,

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

Re: Arrows in Straight table with text

Roop — Thu, 19 Mar 2015 10:24:35 GMT

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.

Re: Arrows in Straight table with text

Thu, 19 Mar 2015 10:45:14 GMT

Thank you all.