Setting image on certain condition

[#1]

Hi Experts..

I want to set the image which should be change based on certain condition..

I  have calculated growth in my application and when growth is greater than 0 then it should display upword Arrow image and

if growth is less than 0 it should display downward Arrow image.

How should i do this?

My expression is:

=If(Num(((MTDGrowth-PreviousMTDGrowth)/PreviousMTDGrowth),'#,#00%')>=0,'qmem://<bundled>/BuiltIn/arrow_n_g.png','qmem://<bundled>/BuiltIn/arrow_s_r.png')

I have tried this expression but im not able to get image it returns the string in 'if' condition that  i have wrote..

Plzz help me

Thanks in advance.

[preminqlik]

go to chart properties >> Expressions tab >>> select expression >> and in display options >> select representation as "Image"

[PrashantSangle]

Hi,

Your expression looks ok for me.

Can you post screen shot of it.

Regards

[sushil353]

Hi,

Try below code:

=If(((MTDGrowth-PreviousMTDGrowth)/PreviousMTDGrowth>=0,'qmem://<bundled>/BuiltIn/arrow_n_g.png','qmem://<bundled>/BuiltIn/arrow_s_r.png')

HTH

Sushil

[satishkurra]

Hi

Please use the below code in Expressions Tab of chart

Num(Sum(Sales)/Sum(Target)-1, '▲ 0.0%;▼ 0.0%')

Also write the below code for Back  Ground color as

If(Sum(Sales) > 0, '▲ 0.0%;▼ 0.0%')

Thanks

Satish

[#6]

Thanks satish

But instead of that arrow which you have placed in expression i want image  ..

if growth >0 it should be green upword arrow else red downward arrow image..

[awhitfield]

HI,

if the image path etc is displaying as text, then change the representation to IMAGE on the EXPRESSI)N tab:

HTH

Andy

[#8]

But i want to display in text object only.

[awhitfield · Accepted solution]

Set it here instead and you get:

HTH Andy

[#10]

Thank you.. its working