How to use the IF command?

[#1]

Hello Dear All.

I have a problem using the command IF to color the background of a label object.

I would like to change the color of the background of a label when his values is changing.

Thansk is advance for your help

Regards

[#2]

Hai,

Do you have any particular range in the values ,if so you can use visual cues in tha charts.

Thanks,

Rathish

[#3]

Hai Ratish.

Here is the formula behind that object : =Only (TOT_AMOUNT)

I wld lik that when this value is strictly less than 0 the background be RED, when is equal to zero the background color be YELLOW and when the value is strictly greater than 0 the background color be GREEN.

Thank in advance for your help

[#4]

like ratish already said you can do this in the chart setting -> visualitazion

regards,

MT

[#5]

Hai ,

If so you can use visual cues in the chart option see the attachment. That range you have to set in the expression .

[#6]

Hai Ratish.

I'm unable to open the document bcoz i'm using the Qlikview Personal Edition.

Please Help to let me open that document or  type the formula here.

Thank in advance

[#7]

You find this in chart properties so left click on you chart. Formeln means expressions you select the one where you want to have the above 0 green and so on. oberhalb means above so you just put a zero in the textbox and then everything above will be green and unterhalb is underneath you also put a zero and then everything underneath zero will be red and for normal you change the backgroundcolor to yellow or whatever color you want to have. I hope it helps even though the screenshot is in german put im using qv in german. does that help you??

[#8]

Dear kbs

Thanks for that. But the object is TEXT OBJECT see the screenshot, there is no that tab to change color.

I wld like to change the background colour of that text object according to the value of =Only(TOT_AMOUNT)

Thanks in advance for your help

[#9]

hi

kindly check the attached file if you are looking at changing the background color of a label based on the value that is displayed

Regards

[#10]

Hai Rakesh

Please i'm unable to open the file since I'm using a Qlikview Personal edition.

If there is a formula, please could you paste it here.

Regards