topic Re: formula not working in text box in QlikView

formula not working in text box

felcar2013 — Fri, 01 Mar 2013 15:15:17 GMT

i don't really understand why this formula does not work in a text box:

=if($(%Change)>0,LightGreen(),LightRed())

%Change is a variable in percentage, that can be positve or negative

thanks for any help

felipe

Re: formula not working in text box

Fri, 01 Mar 2013 15:21:12 GMT

Try:

=if(%Change>0,LightGreen(),LightRed())

Re: formula not working in text box

felcar2013 — Fri, 01 Mar 2013 17:23:13 GMT

thanks

i get as result

RGB(255,0,0)

Re: formula not working in text box

Fri, 01 Mar 2013 19:16:58 GMT

That means you are entering it in the wrong place. Under General > Background > Color > Base Color > Calculated enter your expression. See attached.

Re: formula not working in text box

felcar2013 — Fri, 01 Mar 2013 19:57:40 GMT

thanks Rebecca, i forgot to say, i want that the variable value font changes the color accordingly, not the background. there is also an option under "font", but i get my result " RGB(255,0,0)" in the color i indicated, but what i need is to get the variable value in that color

is this possible?

Re: formula not working in text box

Fri, 01 Mar 2013 20:04:52 GMT

See attached.

Re: formula not working in text box

felcar2013 — Fri, 01 Mar 2013 20:22:01 GMT

excellent, thanks, it work however with the $(var)

Re: formula not working in text box

Fri, 01 Mar 2013 20:31:22 GMT

Ok good deal. Glad it worked for ya.