How can I change the column of a table for an arrow sign?

[Anonymous]

Hi,

I have a table, and according to the value of a field, I will like to display an arrow, I have tried in the backgroun, text format, and text color, but didn't work. I am trying to add the following condition for the field:

=If ([Current Trend]='Improving', 'qmem://<bundled>/BuiltIn/arrow_ne_r.png',

If ([Current Trend]='Neutral', 'qmem://<bundled>/BuiltIn/arrow_e_y.png',

  If ([Current Trend]='Hot', 'qmem://<bundled>/BuiltIn/arrow_se_g.png')))

How can display an arrow in the column instead of the value itself?

[sunny_talwar]

Have you changed the representation of the expression to Image on the expressions tab?

[Anonymous]

Yes, I have changed the representation to image and set the code in the definition, it shows the path of the image.

Can you please provide me some steps on how to do it correctly?

[sunny_talwar]

Have you closed the chart properties to see if the image pops up? Usually takes few seconds before it shows up

[Anonymous]

This is what I did:

- Go to the Expressions tab

- Click on Add

- In the Edit Expression's form, add:

If ([Current Trend]='Improving', 'qmem://<bundled>/BuiltIn/arrow_ne_r.png',

If ([Current Trend]='Neutral', 'qmem://<bundled>/BuiltIn/arrow_e_y.png',

  If ([Current Trend]='Hot', 'qmem://<bundled>/BuiltIn/arrow_se_g.png')))

- Click on OK

- Change the representation to Image

- Click on OK

At this point the column won't display anything:

Can you please let me know if am I doing something wrong?

[Colin-Albert · Accepted solution]

You can use the ascii characters  9650  (up arrow) & 9660 (down arrow)

Try chr(9650)  and chr(9660) in your expression

[vishsaggi]

Is it possible for you to upload your qvw file to look into ?

[Anonymous]

how can I give a different color to each arrow? or isn't possible?

[Anonymous]

Unfortunately I cannot share my qvw. With the answer from Colin Albert, I was able to do it using this code as expression:

=If ([Current Trend]='Improving', '↗',

If ([Current Trend]='Neutral', '--',

If ([Current Trend]='Deteriorating', '↘')))

Now, I need to make it bold and use a different color for each option, do you know if that is possible?

[vishsaggi]

Ok in the expression click on + sign and in Text Color Add the color you want.