I was just wondering if you could help me with this.
I have two variables: 1. Variable1 (current month score)
2. Variable2 (previous month score) , (both in % value)
I wanted to make a monthly comparison trend indicator using green and red arrows (from bundled images) in a text box. If score increases, green arrow pointing up. If score decreases, red arrow pointing down.
This is my text box code:
=if(Variable1-Variable2> 0 ,
BuiltIn/arrow_n_g.png - Green Up arrow
BuiltIn/arrow_s_r.png - Red down arrow
However, I always get a red arrow pointing down no matter what the trend is, even if i interchange values Can you tell me what i am doing wrong?
Hi all, it is working,
But I need to know how to resize the arrow indicator size in cell,
Because it is looking big,
Can any one help on this to reduce the indicator size...
Le Jeudi 23 janvier 2014 10h40, Prasadreddy <email@example.com> a écrit :
If statement to display arrow indicator
reply from Prasadreddy in New to QlikView - View the full discussion
Hi Prasadreddy, you have to open the properties panel, go to the expession panel, select the expression and, finally, select "Keep Aspect" from the "Image formatting" combobox. Best regards AL