Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to show colored upward and downward arrows(Not background color) with values .
( e.g. If value < 0 red, else green)
May be this?
If(Value <0, 'qmem://<bundled>/BuiltIn/arrow_n_g.png', 'qmem://<bundled>/BuiltIn/arrow_s_r.png')
Simply upload a green arrow and red arrow with the specific condition in the 'If'
You can do this one. Create a Line/Arrow Object and select the type of arrow you want .
And after that give the Condition in the conditional field. You can create two different Line/Arrow objects for Profit or Gain and give the respective conditions in the Conditional Field. This worked out for me. Hope this helps you.
Hi Shubham,
It will work in your case:
If(Value <0, 'qmem://<bundled>/BuiltIn/arrow_n_g.png', 'qmem://<bundled>/BuiltIn/arrow_s_r.png')
Thanks,
Arvind Patil
Try like this
if(value < 0 ,'qmem://<bundled>/BuiltIn/arrow_n_g.png','qmem://<bundled>/BuiltIn/arrow_s_r.png')
You will get like below ...
In cell value, only following link is showing,
qmem://<bundled>/BuiltIn/arrow_n_g.png
You must change representation from text to image
Not working sir
=If((A-B) <= -1,'qmem://<bundled>/BuiltIn/arrow_n_g.png','qmem://<bundled>/BuiltIn/arrow_s_r.png');
This is exp.