topic Re: Setting Colors in Text Box in QlikView

Setting Colors in Text Box

tmumaw — Fri, 14 Dec 2018 11:59:40 GMT

Hi all,

I'm trying to set some colors based on a value in a text box. Does anyone see anything wrong with this statement? Colors not working. Thanks

=Num(if(Sum({<FISYR = {$(=$(vFisYr) - 0)},YTDFlag = {1}>} [Inv Gross]) - Num(Sum({<FISYR = {$(=$(vFisYr) - 1)},YTDFlag = {1}>} [Inv Gross]) < 0),RGB(255,0,0),RGB(0,102,0)))

Re: Setting Colors in Text Box

sunny_talwar — Fri, 14 Dec 2018 12:26:18 GMT

Try this

=If((Sum({<FISYR = {$(=$(vFisYr) - 0)}, YTDFlag = {1}>} [Inv Gross]) - Sum({<FISYR = {$(=$(vFisYr) - 1)}, YTDFlag = {1}>} [Inv Gross])) < 0),
  RGB(255,0,0),
  RGB(0,102,0)
)

Re: Setting Colors in Text Box

tmumaw — Fri, 14 Dec 2018 13:00:18 GMT

Nope

Re: Setting Colors in Text Box

sunny_talwar — Fri, 14 Dec 2018 13:01:37 GMT

You are using this for coloring the text box object?

Re: Setting Colors in Text Box

tmumaw — Fri, 14 Dec 2018 13:04:20 GMT

=If((Sum({<FISYR = {$(=$(vFisYr) - 0)}, YTDFlag = {1}>} [Inv Gross]) - Sum({<FISYR = {$(=$(vFisYr) - 1)}, YTDFlag = {1}>} [Inv Gross])) < 0),RGB(255,0,0),RGB(0,102,0),'$###,###,##0')

It does not like RGB on.....

Re: Setting Colors in Text Box

tmumaw — Fri, 14 Dec 2018 13:06:09 GMT

I am using it in a text box to show either a positive or negative variance. If the calculation returns 0 or less it's red otherwise green.

Re: Setting Colors in Text Box

sunny_talwar — Fri, 14 Dec 2018 13:06:22 GMT

I am not sure I understand the use of ,'$###,###,##0') at the end? Are you looking to format color? I don't think that is possible :).... but may be I am missing something here?

Re: Setting Colors in Text Box

tmumaw — Fri, 14 Dec 2018 13:11:46 GMT

I'm using it to format the value in the text box....

Re: Setting Colors in Text Box

sunny_talwar — Fri, 14 Dec 2018 13:16:20 GMT

But this is a color expression, isn't it?

=If((Sum({<FISYR = {$(=$(vFisYr) - 0)}, YTDFlag = {1}>} [Inv Gross]) - Sum({<FISYR = {$(=$(vFisYr) - 1)}, YTDFlag = {1}>} [Inv Gross])) < 0),RGB(255,0,0),RGB(0,102,0),'$###,###,##0')

There are two different location... one is the general tab where you have your expression and then you have font tab where you use color expression. What is confusing me is that why do you need to format the expression which goes on the font tab?

Re: Setting Colors in Text Box

swapniltaz — Fri, 28 Dec 2018 06:24:27 GMT

Can you Try this

=Num(if(Sum({<FISYR = {$($(=vFisYr) - 0)},YTDFlag = {1}>} [Inv Gross]) - Num(Sum({<FISYR = {$($(=vFisYr) - 1)},YTDFlag = {1}>} [Inv Gross]) < 0),RGB(255,0,0),RGB(0,102,0)))

I have changed the Postion of equal to(=) in Double dollar sign expansion

Re: Setting Colors in Text Box

tmumaw — Tue, 21 Apr 2020 13:58:12 GMT

Sorry Sunny forgot to accept the solution. Thanks