topic Re: If statement to display arrow indicator in QlikView

If statement to display arrow indicator

Mon, 24 Sep 2012 07:36:05 GMT

Hi guys,

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 ,
'qmem://<bundled>/BuiltIn/arrow_n_g.png','qmem://<bundled>/BuiltIn/arrow_s_r.png')

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?

Regards,

Justin

Re: If statement to display arrow indicator

Mon, 24 Sep 2012 07:52:09 GMT

try it like this

if((variable1-variable2)>0,...,...)

maybe the if statment just checks if variable2 > 0

regards,

Re: If statement to display arrow indicator

anlonghi2 — Mon, 24 Sep 2012 07:59:07 GMT

Also you can try using this:

if( variable1 > variable2, ...,....)

regards

Re: If statement to display arrow indicator

Mon, 24 Sep 2012 08:02:00 GMT

Well i tried it but it still shows red arrow pointing down for ALL values. Thanks though! Any further help would be appreciated.

Re: If statement to display arrow indicator

Mon, 24 Sep 2012 08:05:51 GMT

Yes! This seems to work and i just got it now. Thanks a lot AL!

Re: If statement to display arrow indicator

prasadreddy — Thu, 23 Jan 2014 09:40:32 GMT

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...

Re: If statement to display arrow indicator

Thu, 23 Jan 2014 09:43:36 GMT

+225 03386502

Le Jeudi 23 janvier 2014 10h40, Prasadreddy <qcwebmaster@qlik.com> a écrit :

QlikCommunity

If statement to display arrow indicator

reply from Prasadreddy in New to QlikView - View the full discussion

Re: If statement to display arrow indicator

anlonghi2 — Thu, 23 Jan 2014 14:19:12 GMT

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