topic Re: Setting image on certain condition in QlikView

Setting image on certain condition

Mon, 08 Jun 2015 10:26:26 GMT

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.

Re: Setting image on certain condition

preminqlik — Mon, 08 Jun 2015 10:30:00 GMT

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

Re: Setting image on certain condition

PrashantSangle — Mon, 08 Jun 2015 10:30:04 GMT

Hi,

Your expression looks ok for me.

Can you post screen shot of it.

Regards

Re: Setting image on certain condition

sushil353 — Mon, 08 Jun 2015 10:32:29 GMT

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

Re: Setting image on certain condition

satishkurra — Mon, 08 Jun 2015 10:36:58 GMT

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

Re: Setting image on certain condition

Mon, 08 Jun 2015 10:42:20 GMT

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

Re: Setting image on certain condition

awhitfield — Mon, 08 Jun 2015 10:51:13 GMT

HI,

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

HTH

Andy

Re: Setting image on certain condition

Mon, 08 Jun 2015 11:05:16 GMT

But i want to display in text object only.

Re: Setting image on certain condition

awhitfield — Mon, 08 Jun 2015 11:54:56 GMT

Set it here instead and you get:

HTH Andy

Re: Setting image on certain condition

Mon, 08 Jun 2015 12:05:06 GMT

Thank you.. its working

Re: Setting image on certain condition

awhitfield — Mon, 08 Jun 2015 14:04:46 GMT

You're welcome, have a good day!

Andy