topic Re: How to use the IF command? in QlikView

How to use the IF command?

Thu, 18 Oct 2012 09:11:19 GMT

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

Re: How to use the IF command?

Thu, 18 Oct 2012 09:34:42 GMT

Hai,

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

Thanks,

Rathish

Re: How to use the IF command?

Thu, 18 Oct 2012 09:49:54 GMT

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

Re: How to use the IF command?

Thu, 18 Oct 2012 09:54:05 GMT

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

regards,

Re: How to use the IF command?

Thu, 18 Oct 2012 09:56:27 GMT

Hai ,

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

Re: How to use the IF command?

Thu, 18 Oct 2012 10:18:02 GMT

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

Re: How to use the IF command?

Thu, 18 Oct 2012 10:23:57 GMT

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

Re: How to use the IF command?

Thu, 18 Oct 2012 10:40:43 GMT

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

Re: How to use the IF command?

Thu, 18 Oct 2012 10:44:31 GMT

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

Re: How to use the IF command?

Thu, 18 Oct 2012 10:49:46 GMT

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

Re: How to use the IF command?

Thu, 18 Oct 2012 10:51:36 GMT

=if(F1<0,RGB(255,0,0),if(F1=0,RGB(255,255,0),RGB(0,255,0)))

open properties for the text object and apply the formula for color. Replace 'F1' with the expression used for text object

Re: How to use the IF command?

Thu, 18 Oct 2012 11:05:18 GMT

Ooooohhhh God. Thanks a lot dear Rakesh.

That was what I looked for

Here is the formula that i applied on my color :

=if(Only (TOT_AMOUNT)<0,RGB(255,0,0),if(Only (TOT_AMOUNT)=0,RGB(255,255,0),RGB(0,255,0)))

Thanks a lot to the team.

Re: How to use the IF command?

Thu, 18 Oct 2012 11:09:47 GMT

what do you mean with apply the formula for color?? cause i just get the text output rgb(....)

regards

Re: How to use the IF command?

Thu, 18 Oct 2012 11:14:40 GMT

hi kbs_tamm,

under base color, select 'calculated' and apply the formula

regards