topic Arrow indicator expression problem in QlikView

Arrow indicator expression problem

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Arrow indicator expression problem

sunny_talwar — Wed, 04 Jan 2017 17:14:00 GMT

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

Re: Arrow indicator expression problem

Thu, 05 Jan 2017 08:54:15 GMT

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.