Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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.