Skip to main content

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 
Search instead for 
Did you mean: 
tmumaw
Specialist II
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
Anil_Babu_Samineni

How about this?

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)

View solution in original post

2 Replies
Anil_Babu_Samineni

How about this?

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)
tmumaw
Specialist II
Specialist II
Author

perfect.....thanks