topic Re: Else command in dimension expression doesnt work in QlikView https://community.qlik.com/t5/QlikView/Else-command-in-dimension-expression-doesnt-work/m-p/1238158#M866489 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Daniel,</SPAN></P><P><SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">0,7 should be 0.7<BR /></SPAN></P></BODY></HTML> Sat, 10 Dec 2016 11:19:59 GMT Clever_Anjos 2016-12-10T11:19:59Z Else command in dimension expression doesnt work https://community.qlik.com/t5/QlikView/Else-command-in-dimension-expression-doesnt-work/m-p/1238156#M866487 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I am trying to use an expression for the table dimension format. After the second comma, it says that I am having an error in the expression. Does anyone have any idea why?</P><P></P><P>The expression follows:</P><P></P><P>=IF(SOMADOR_OP+SOMADOR_OS+SOMADOR_PEDIDO+SOMADOR_RISCO&lt;=0,7*(COUNT(DISTINCT OP_OS)+COUNT(DISTINCT CONCATENADO_OP)+COUNT(DISTINCT CONCATENADO_PA)+COUNT(DISTINCT OP_RISCO))</P><P>&nbsp; ,RGB(226,0,0),RGB(0,0,0))</P><P></P><P>I appreciate any help!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Else-command-in-dimension-expression-doesnt-work/m-p/1238156#M866487 Anonymous 2020-11-25T16:16:04Z Re: Else command in dimension expression doesnt work https://community.qlik.com/t5/QlikView/Else-command-in-dimension-expression-doesnt-work/m-p/1238157#M866488 <HTML><HEAD></HEAD><BODY><P>May be try this:</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>=If(SOMADOR_OP+SOMADOR_OS+SOMADOR_PEDIDO+SOMADOR_RISCO &lt;= <SPAN style="color: #ff0000;">((7/10)</SPAN> * (COUNT(DISTINCT OP_OS)+COUNT(DISTINCT CONCATENADO_OP)+COUNT(DISTINCT CONCATENADO_PA)+COUNT(DISTINCT OP_RISCO))<SPAN style="color: #ff0000;">)</SPAN>, RGB(226,0,0), RGB(0,0,0))</STRONG></P></BODY></HTML> Fri, 09 Dec 2016 16:50:08 GMT https://community.qlik.com/t5/QlikView/Else-command-in-dimension-expression-doesnt-work/m-p/1238157#M866488 sunny_talwar 2016-12-09T16:50:08Z Re: Else command in dimension expression doesnt work https://community.qlik.com/t5/QlikView/Else-command-in-dimension-expression-doesnt-work/m-p/1238158#M866489 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Daniel,</SPAN></P><P><SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">0,7 should be 0.7<BR /></SPAN></P></BODY></HTML> Sat, 10 Dec 2016 11:19:59 GMT https://community.qlik.com/t5/QlikView/Else-command-in-dimension-expression-doesnt-work/m-p/1238158#M866489 Clever_Anjos 2016-12-10T11:19:59Z