Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Shubham_Deshmukh
Specialist
Specialist

How to indicate column with Color codes?

I want to show colored upward and downward arrows(Not background color)  with values .

( e.g. If value < 0  red, else  green)

11 Replies
Anil_Babu_Samineni

May be this?

If(Value <0, 'qmem://<bundled>/BuiltIn/arrow_n_g.png', 'qmem://<bundled>/BuiltIn/arrow_s_r.png')

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Not applicable

Simply upload a green arrow and red arrow with the specific condition in the 'If'

Not applicable

You can do this one. Create a Line/Arrow Object and select the type of arrow you want .

main001.PNGmain002.PNG

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.

arvind_patil
Partner - Specialist III
Partner - Specialist III

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

prma7799
Master III
Master III

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 ...

Bullet.png

Shubham_Deshmukh
Specialist
Specialist
Author

In cell value, only following link is showing,

qmem://<bundled>/BuiltIn/arrow_n_g.png

Anil_Babu_Samineni

You must change representation from text to image

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Shubham_Deshmukh
Specialist
Specialist
Author

Not working sir

Shubham_Deshmukh
Specialist
Specialist
Author

=If((A-B) <= -1,'qmem://<bundled>/BuiltIn/arrow_n_g.png','qmem://<bundled>/BuiltIn/arrow_s_r.png');

This is exp.