topic Re: If statement arrow in QlikView

If statement arrow

Tue, 21 May 2013 04:56:53 GMT

hi,

I'm trying to write a statement that says =if(sum(Budget) > sum(Actual), 'qmem://Arrow/GreenUp',if(sum(Budget)<sum(Actual),'qmem://Arrow/RedDown'). It is not working and I'm not sure what is wrong with the syntax. Does anyone know?

Thank you!

Re: If statement arrow

kumarnatarajan — Tue, 21 May 2013 05:03:24 GMT

Hi ,

I think your syntex is right check your compared values.

Else

Try this

EX: =if(sum(Budget) > sum(Actual),'qmem://Arrow/GreenUp','qmem://Arrow/RedDown')

Re: If statement arrow

Tue, 21 May 2013 12:08:31 GMT

This does not work. I get a text box with the formula in it. Any other ideas would be very helpful!

Re: If statement arrow

kumarnatarajan — Tue, 21 May 2013 12:13:52 GMT

Hi,

I think your load qmem file error so check the below syntex.

Ex: if(sum(Budget) > sum(Actual),'Yes','No')

Re: If statement arrow

Tue, 21 May 2013 12:48:40 GMT

But that would not get me to an up or a down arrow as the output, correct? How would I address the qmem file error?

Re: If statement arrow

rustyfishbones — Tue, 21 May 2013 12:55:36 GMT

I think the following will work better

if(sum(Budget) > sum(Actual),'qmem://<bundled>/BuiltIn/arrow_s_r.png','qmem://<bundled>/BuiltIn/arrow_n_g.png'))

and make sure the representation is Image

Re: If statement arrow

er_mohit — Tue, 21 May 2013 13:10:53 GMT

Try this:

=RangeOnly(if(GetCurrentSelections() & Budget > Actual, 'qmem://Arrow/GreenUp','qmem://Arrow/RedDown')).

Re: If statement arrow

Tue, 21 May 2013 14:01:37 GMT

this works in that I get a green arrow but I want the arrow that looks like just a triangle (without a stem).. is there a way to use this code to get that kind of arrow? Thanks! (and sorry for being picky...)

Re: If statement arrow

Tue, 21 May 2013 14:02:12 GMT

This gives me a "-" ... no arrow for now!

Re: If statement arrow

rustyfishbones — Tue, 21 May 2013 14:51:19 GMT

Try this video I created on YouTube.

Have you used Character Map before?

check this out

http://youtu.be/RdDFHhNAOKI

Re: If statement arrow

Tue, 21 May 2013 16:41:50 GMT

wait, I take that back I can't get the arrow colors to be different...

=if(sum(Budget) > sum(Actual),'▼','▲').. the down arrow should be red and the up arrow should be green. is there a way to do this?

Re: If statement arrow

rustyfishbones — Tue, 21 May 2013 19:15:26 GMT

If you are using a text object you can go to font color and say

=if(sum(Budget) > sum(Actual),Red(),Green())

Re: If statement arrow

Tue, 21 May 2013 21:52:16 GMT

I'm a bit confused - when I add that second expression in under the "general" text format it turns my arrow into a 0. I don't see a way to create an expression under the font color tab of a text box. Am I missing something?

Re: If statement arrow

rustyfishbones — Tue, 21 May 2013 22:01:21 GMT

Where do you need to show the

In a Table or a Text Object?

Re: If statement arrow

rustyfishbones — Tue, 21 May 2013 22:03:48 GMT

I have updated the previous Expression, as I had written it wrong sorry

=if(sum(Budget) > sum(Actual),Red(),Green())

Re: If statement arrow

Tue, 21 May 2013 22:16:58 GMT

brilliant - that's it! thanks as always Alan

Re: If statement arrow

rustyfishbones — Tue, 21 May 2013 22:19:47 GMT

Great Stuff, I have done lots of video tutorials on YouTube, all simple stuff

Check them out you may pick up lots of tips

https://www.youtube.com/user/RustyFishBones

Re: If statement arrow

Tue, 21 May 2013 22:21:17 GMT

i've been trying to watch! i learned the character map from that video.

Re: If statement arrow

rustyfishbones — Tue, 21 May 2013 22:29:31 GMT

Where are you from?

Have you been using Qlikview long?

Re: If statement arrow

Tue, 21 May 2013 22:30:34 GMT

work in NYC and no, just over a week