Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
MuraliPrasath
Creator III
Creator III

Conditional Image text box.

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.

qc.PNG

1 Solution

Accepted Solutions
PrashantSangle

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

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

View solution in original post

3 Replies
PrashantSangle

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

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
MuraliPrasath
Creator III
Creator III
Author

Thanks Prashant Sangle !

hemachandran
Partner - Creator
Partner - Creator

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