topic Re: Using Built-In Arrow Graphics in QlikView

Using Built-In Arrow Graphics

jmonroe918 — Thu, 26 Oct 2017 03:23:27 GMT

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

Re: Using Built-In Arrow Graphics

Anil_Babu_Samineni — Thu, 26 Oct 2017 03:32:35 GMT

This should work, Not sure where you made mistake.

Re: Using Built-In Arrow Graphics

vvira1316 — Thu, 26 Oct 2017 03:42:15 GMT

Sample app and data may help to identify the issue.

Re: Using Built-In Arrow Graphics

jmonroe918 — Fri, 27 Oct 2017 02:24:04 GMT

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

Re: Using Built-In Arrow Graphics

Anil_Babu_Samineni — Fri, 27 Oct 2017 02:43:25 GMT

Why not?

Re: Using Built-In Arrow Graphics

vvira1316 — Fri, 27 Oct 2017 05:01:01 GMT

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

Re: Using Built-In Arrow Graphics

jonathandienst — Fri, 27 Oct 2017 05:25:00 GMT

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')

Re: Using Built-In Arrow Graphics

jmonroe918 — Fri, 27 Oct 2017 14:11:33 GMT

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')))))