# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for
Did you mean:
Specialist II

## Calculation for Color

Hi All,

Having a little problem with a statement trying to set text color, but not working.  Need a little help.

Thanks

Round(sum({<Node3 = {'A420000000'},FISYR = {\$(=\$(vFisYr) - 0)},[GL Hier 1] = {[ZMR Chart of Accounts]}, YTDFlag = {1},[HighNode] = {'ZMR_SALESCOSTS2'}>} [In company code currency_HSL]) /
sum({<Node3 = {'A420000000'},FISYR = {\$(=\$(vFisYr) - 0)},YTDFlag = {1}, NodeIDGLAccountsName = {ZMR_GROSS.GLPCT}>} [In company code currency_HSL] * -1),0.001 >= [SL Top],RGB
(255,0,0),RGB(0,204,0)

1 Solution

Accepted Solutions

If(Round(sum({<Node3 = {'A420000000'},FISYR = {\$(=\$(vFisYr) - 0)},[GL Hier 1] = {[ZMR Chart of Accounts]}, YTDFlag = {1},[HighNode] = {'ZMR_SALESCOSTS2'}>} [In company code currency_HSL]) /
sum({<Node3 = {'A420000000'},FISYR = {\$(=\$(vFisYr) - 0)},YTDFlag = {1},NodeIDGLAccountsName = {ZMR_GROSS.GLPCT}>} [In company code currency_HSL] * -1),0.001) >= [SL Top],RGB
(255,0,0),RGB(0,204,0))

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
2 Replies