topic Re: Conditional Image text box. in QlikView

Conditional Image text box.

MuraliPrasath — Wed, 25 Nov 2020 16:16:04 GMT

Hi QV Team,

I have a text box expression value =num(($(vIOAY) - $(vIOPY)) / $(vIOPY)*100,'#,#0') &' %' =-90,70%

which has positive and negative values.

I need to display the Green Arrow when a value is Positive otherwise Negative Arrow should display.

PrashantSangle — Wed, 08 Mar 2017 06:25:26 GMT

Hi,

Use bundle image object write expression like

if(num(($(vIOAY) - $(vIOPY)) / $(vIOPY)*100,'#,#0')>0,'qmem://<bundled>/BuiltIn/arrow_n_g.png','qmem://<bundled>/BuiltIn/arrow_s_r.png')

Regards,

Prashant

MuraliPrasath — Wed, 08 Mar 2017 09:57:01 GMT

Thanks Prashant Sangle !

hemachandran — Wed, 08 Mar 2017 09:58:13 GMT

Hi,

try this set Analysis...

=If(num(($(vIOAY) - $(vIOPY)) / $(vIOPY)*100,'#,#0')> 0, 'qmem://<bundled>/BuiltIn/arrow_s_r.png',

, 'qmem://<bundled>/BuiltIn/arrow_s_r.png'))