topic Re: Calculation for Color in QlikView https://community.qlik.com/t5/QlikView/Calculation-for-Color/m-p/1337662#M412460 <HTML><HEAD></HEAD><BODY><P>perfect.....thanks</P></BODY></HTML> Thu, 08 Jun 2017 14:53:35 GMT tmumaw 2017-06-08T14:53:35Z Calculation for Color https://community.qlik.com/t5/QlikView/Calculation-for-Color/m-p/1337660#M412458 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>Having a little problem with a statement trying to set text color, but not working.&nbsp; Need a little help.</P><P>Thanks</P><P></P><P><SPAN style="color: #0000ff; font-size: 12pt;">Round</SPAN><SPAN style="font-size: 12pt;"><STRONG style=": ; color: #ff0000;">(</STRONG><SPAN style="color: #0000ff;">sum</SPAN>({&lt;<SPAN style="color: #800000;">Node3</SPAN> = {'A420000000'},<SPAN style="color: #800000;">FISYR</SPAN> = {<STRONG><EM style=": ; color: #808080;">$(=$(vFisYr) - 0)</EM></STRONG>},<SPAN style="color: #800000;">[GL Hier 1]</SPAN> = {<SPAN style="color: #800000;">[ZMR Chart of Accounts]</SPAN>}, <SPAN style="color: #800000;">YTDFlag</SPAN> = {1},<SPAN style="color: #800000;">[HighNode]</SPAN> = {'ZMR_SALESCOSTS2'}&gt;} <SPAN style="color: #800000;">[In company code currency_HSL]</SPAN>) /<BR /> <SPAN style="color: #0000ff;">sum</SPAN>({&lt;<SPAN style="color: #800000;">Node3</SPAN> = {'A420000000'},<SPAN style="color: #800000;">FISYR</SPAN> = {<STRONG><EM style=": ; color: #808080;">$(=$(vFisYr) - 0)</EM></STRONG>},<SPAN style="color: #800000;">YTDFlag</SPAN> = {1}, <SPAN style="color: #800000;">NodeIDGLAccountsName</SPAN> = {ZMR_GROSS.GLPCT}&gt;} <SPAN style="color: #800000;">[In company code currency_HSL]</SPAN> * -1),0.001 &gt;= <SPAN style="color: #800000;">[SL Top]</SPAN>,<SPAN style="color: #0000ff;">RGB</SPAN></SPAN><SPAN style="font-size: 12pt;">(255,0,0),RGB(0,204,0) </SPAN></P></BODY></HTML> Thu, 08 Jun 2017 14:47:30 GMT https://community.qlik.com/t5/QlikView/Calculation-for-Color/m-p/1337660#M412458 tmumaw 2017-06-08T14:47:30Z Re: Calculation for Color https://community.qlik.com/t5/QlikView/Calculation-for-Color/m-p/1337661#M412459 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 12pt; font-family: arial, helvetica, sans-serif;">How about this?</SPAN></P><P></P><P><SPAN style="font-family: arial, helvetica, sans-serif; font-size: 10pt;"><SPAN style="color: #000000;"><STRONG>If(Round</STRONG></SPAN><STRONG style="color: #000000;">(<SPAN style="font-style: inherit;">sum</SPAN>({&lt;<SPAN style="font-style: inherit;">Node3</SPAN> = {'A420000000'},<SPAN style="font-style: inherit;">FISYR</SPAN> = {<EM style="font-weight: inherit; font-family: inherit; color: #808080;">$(=$(vFisYr) - 0)</EM>},<SPAN style="font-style: inherit;">[GL Hier 1]</SPAN> = {<SPAN style="font-style: inherit;">[ZMR Chart of Accounts]</SPAN>}, <SPAN style="font-style: inherit;">YTDFlag</SPAN> = {1},<SPAN style="font-style: inherit;">[HighNode]</SPAN> = {'ZMR_SALESCOSTS2'}&gt;} <SPAN style="font-style: inherit;">[In company code currency_HSL]</SPAN>) /<BR /><SPAN style="font-style: inherit;">sum</SPAN>({&lt;<SPAN style="font-style: inherit;">Node3</SPAN> = {'A420000000'},<SPAN style="font-style: inherit;">FISYR</SPAN> = {<EM style="font-weight: inherit; font-family: inherit; color: #808080;">$(=$(vFisYr) - 0)</EM>},<SPAN style="font-style: inherit;">YTDFlag</SPAN> = {1},<SPAN style="font-style: inherit;">NodeIDGLAccountsName</SPAN> = {ZMR_GROSS.GLPCT}&gt;} <SPAN style="font-style: inherit;">[In company code currency_HSL]</SPAN> * -1),0.001) &gt;= <SPAN style="font-style: inherit;">[SL Top]</SPAN>,<SPAN style="font-style: inherit;">RGB</SPAN></STRONG></SPAN><SPAN style="color: #000000; font-size: 10pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><STRONG style=": ; font-size: 10pt; font-family: arial, helvetica, sans-serif;">(255,0,0),RGB(0,204,0))</STRONG></SPAN></P></BODY></HTML> Thu, 08 Jun 2017 14:51:35 GMT https://community.qlik.com/t5/QlikView/Calculation-for-Color/m-p/1337661#M412459 Anil_Babu_Samineni 2017-06-08T14:51:35Z Re: Calculation for Color https://community.qlik.com/t5/QlikView/Calculation-for-Color/m-p/1337662#M412460 <HTML><HEAD></HEAD><BODY><P>perfect.....thanks</P></BODY></HTML> Thu, 08 Jun 2017 14:53:35 GMT https://community.qlik.com/t5/QlikView/Calculation-for-Color/m-p/1337662#M412460 tmumaw 2017-06-08T14:53:35Z