Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
tmumaw
Specialist II
Specialist II

Setting Colors in Text Box

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

10 Replies
tmumaw
Specialist II
Specialist II
Author

Sorry Sunny forgot to accept the solution.  Thanks