Arrow indicator expression problem

[#1]

Hey folks, I am trying to create arrow images indicating if the last 30 days have more sales than last 60 days minus last 30.

The arrow does not always indicate correctly as per below example, 1103 is lower than 1177 but still the arrow is green. Same for 14 and 26. Perhaps this is because my expression is based on a definition? My Qlikview is in a different language so I am not 100% sure on the terminology . Any help greatly appreciated!

Here is my expression:

=if([60Dcalc]=[30Dcalc], 'qmem://<bundled>/BuiltIn/arrow_e.png', if([60Dcalc]>>[30Dcalc],

'qmem://<bundled>/BuiltIn/arrow_se_r.png', 'qmem://<bundled>/BuiltIn/arrow_ne_g.png'))

[sunny_talwar · Accepted solution]

Why do you have >>? May be its a typo?

=if([60Dcalc]=[30Dcalc], 'qmem://<bundled>/BuiltIn/arrow_e.png', if([60Dcalc]>[30Dcalc],

'qmem://<bundled>/BuiltIn/arrow_se_r.png', 'qmem://<bundled>/BuiltIn/arrow_ne_g.png'))

[#3]

You are right, whoops! - that fixed it thank you, everytime I do > or < it wants to autocomplete into >> or << I assumed it had the same function, silly me.