topic Re: Calculation to set text color in QlikView https://community.qlik.com/t5/QlikView/Calculation-to-set-text-color/m-p/1346851#M414390 <HTML><HEAD></HEAD><BODY><P>what error it's showing, have you tried set analysis builder</P><P><A href="http://tools.qlikblog.at/SetAnalysisWizard/QlikView-SetAnalysis_Wizard_and_Generator.aspx?sa=" title="http://tools.qlikblog.at/SetAnalysisWizard/QlikView-SetAnalysis_Wizard_and_Generator.aspx?sa=">Set Analysis Wizard for QlikView | qlikblog.at</A></P></BODY></HTML> Fri, 09 Jun 2017 20:34:01 GMT tajmohamed30 2017-06-09T20:34:01Z Calculation to set text color https://community.qlik.com/t5/QlikView/Calculation-to-set-text-color/m-p/1346850#M414389 <HTML><HEAD></HEAD><BODY><P>Hi everyone,</P><P>It's late Friday afternoon and eyes aren't working too good.&nbsp; Does anyone see anything wrong with my statement:</P><P>Thanks</P><P></P><P><SPAN style="color: #0000ff; font-size: 12pt;">If</SPAN><SPAN style="font-size: 12pt;">(<SPAN style="color: #800000;">Node4</SPAN> = 'A43A000000',<SPAN style="color: #0000ff;">Round</SPAN>(<SPAN style="color: #0000ff;">sum</SPAN>({&lt;<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;">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: #0000ff;">Sum</SPAN>({&lt;<SPAN style="color: #800000;">[DIV Tops Category]</SPAN> = {'Sales Deductions'}&gt;}<SPAN style="color: #800000;">[DIV Top]</SPAN>),<SPAN style="color: #0000ff;">RGB</SPAN>(255,0,0),RGB(0,102,0)),<BR /> If(Node4 = 'A42A000000',Round(sum({&lt;FISYR = {<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>}, YTDFlag = {1},<SPAN style="color: #800000;">[HighNode]</SPAN> = {'ZMR_SALESCOSTS2'}&gt;} <SPAN style="color: #800000;">[In company code currency_HSL]</SPAN>) /<BR /> sum({&lt;FISYR = {<STRONG><EM style=": ; color: #808080;">$(=$(vFisYr) - 0)</EM></STRONG>},YTDFlag = {1}, NodeIDGLAccountsName = {ZMR_GROSS.GLPCT}&gt;} <SPAN style="color: #800000;">[In company code currency_HSL]</SPAN> * -1),0.001)&gt; Sum({&lt;<SPAN style="color: #800000;">[DIV Tops Category]</SPAN> = {'Sales Deductions'}&gt;}<SPAN style="color: #800000;">[DIV Top]</SPAN></SPAN><SPAN><SPAN style="font-size: 12pt;">),RGB(255,0,0),RGB(0,102,0))&nbsp; </SPAN><BR /> </SPAN></P></BODY></HTML> Fri, 09 Jun 2017 18:44:13 GMT https://community.qlik.com/t5/QlikView/Calculation-to-set-text-color/m-p/1346850#M414389 tmumaw 2017-06-09T18:44:13Z Re: Calculation to set text color https://community.qlik.com/t5/QlikView/Calculation-to-set-text-color/m-p/1346851#M414390 <HTML><HEAD></HEAD><BODY><P>what error it's showing, have you tried set analysis builder</P><P><A href="http://tools.qlikblog.at/SetAnalysisWizard/QlikView-SetAnalysis_Wizard_and_Generator.aspx?sa=" title="http://tools.qlikblog.at/SetAnalysisWizard/QlikView-SetAnalysis_Wizard_and_Generator.aspx?sa=">Set Analysis Wizard for QlikView | qlikblog.at</A></P></BODY></HTML> Fri, 09 Jun 2017 20:34:01 GMT https://community.qlik.com/t5/QlikView/Calculation-to-set-text-color/m-p/1346851#M414390 tajmohamed30 2017-06-09T20:34:01Z