Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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?
If you are using a text object you can go to font color and say
=if(sum(Budget) > sum(Actual),Red(),Green())
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?
Where do you need to show the
In a Table or a Text Object?
I have updated the previous Expression, as I had written it wrong sorry
=if(sum(Budget) > sum(Actual),Red(),Green())
brilliant - that's it! thanks as always Alan
Great Stuff, I have done lots of video tutorials on YouTube, all simple stuff
Check them out you may pick up lots of tips
i've been trying to watch! i learned the character map from that video.
Where are you from?
Have you been using Qlikview long?
work in NYC and no, just over a week