Adding Colors in a Text box

tmumaw — Sat, 16 Nov 2024 21:29:36 GMT

I have a text box with this calculation in it. I want the number to appear in Red if negative and Green if positive. The statement says it's formatted okay, but colors do not change. What am I missing.

Thanks

=num(if(count({<FISYR = {$(=$(vFisYr) - 1)}, YR_SW = {1}, Acq_Sales = {1}>} Distinct([Sold To])) - count({<FISYR = {$(=$(vFisYr) - 5)}, YR_SW = {1}, Acq_Sales = {1}>} Distinct([Sold To]))) /
count({<FISYR = {$(=$(vFisYr) - 5)}, YR_SW = {1}, Acq_Sales = {1}>} Distinct([Sold To])) < 0,RGB(255,0,0),RGB(0,153,0),'###.#%')

Re: Adding Colors in a Text box

jwjackso — Thu, 31 Jan 2019 22:01:25 GMT

Is this section if(count({<FISYR = {$(=$(vFisYr) - 1)}, YR_SW = {1}, Acq_Sales = {1}>} Distinct([Sold To])) - count({<FISYR = {$(=$(vFisYr) - 5)}, YR_SW = {1}, Acq_Sales = {1}>} Distinct([Sold To]))) /
count({<FISYR = {$(=$(vFisYr) - 5)}, YR_SW = {1}, Acq_Sales = {1}>} Distinct([Sold To])) < 0,RGB(255,0,0),RGB(0,153,0))

in the textbox->font->color->calculated expression?

topic Adding Colors in a Text box in QlikView

Adding Colors in a Text box

Re: Adding Colors in a Text box