If statement arrow

[#1]

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!

[#2]

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?

[rustyfishbones]

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

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

[#4]

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?

[rustyfishbones]

Where do you need to show the

In a Table or a Text Object?

[rustyfishbones · Accepted solution]

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

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

[#7]

brilliant - that's it! thanks as always Alan

[rustyfishbones]

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

[#9]

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

[rustyfishbones]

Where are you from?

Have you been using Qlikview long?

[#11]

work in NYC and no, just over a week