Using Built-In Arrow Graphics

[jmonroe918]

I have a text box where I want to use the built in graphics to indicate a trend direction (up or down, green or red), The formula I'm using is: =if(CPM_Delta='DownRed', 'qmem://<bundled>/BuiltIn/arrow_s_r.png', 'qmem://<bundled>/BuiltIn/arrow_s_g.png')

So this should show the down red arrow (arrow_s_r.png). But when I change the CPM_Delta to 'DownGreen' (or anything else) it doesn't change.

I've changed Representation to 'Image (in the Text Box)

What am I missing here?

Thanks

[Anil_Babu_Samineni]

This should work, Not sure where you made mistake.

[vvira1316]

Sample app and data may help to identify the issue.

[jmonroe918]

Vijay:

Here's a sample file of what I am trying to do.

I'd like the arrow to respond per the active CPM_Trend (up_green, down_green, etc). I'd like to use it in a text object and in a column in the table.

Thanks

Jeff

[Anil_Babu_Samineni]

Why not?

[vvira1316]

Hi Jeff,

I'm sorry but I'm unable to open your QVW file due to personal edition limitation on my side. I hope others can help you. If you want to provide script and data then I can try it out.

BR,

Vijay

[jonathandienst · Accepted solution]

Your sample app responds as expected, but the text box expression has the colours the wrong way round, and you have not set the image type for the expression in the table.

I think the text box should be:

=if(CPM_Delta='DownRed', 'qmem://<bundled>/BuiltIn/arrow_s_r.png', 'qmem://<bundled>/BuiltIn/arrow_s_g.png')

[jmonroe918]

Jonathan:

I actually discovered that on my own last night and fixed it (and added more nested "if,then" statements (below) and it's working like a charm now. Thanks.

Jeff

=if(CPM_Delta='DownRed', 'qmem://<bundled>/BuiltIn/arrow_s_r.png',

(if(CPM_Delta='UpRed', 'qmem://<bundled>/BuiltIn/arrow_n_r.png',

(if(CPM_Delta='DownGreen', 'qmem://<bundled>/BuiltIn/arrow_s_g.png',

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