topic Re: Calculos Set Analise in Brasil https://community.qlik.com/t5/Brasil/Calculos-Set-Analise/m-p/398735#M11022 <HTML><HEAD></HEAD><BODY><P>sum( {$&lt;<SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">TIPOR </SPAN>= {<SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">C</SPAN>} &gt;} <SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">CNVALOR4</SPAN>)</P></BODY></HTML> Fri, 01 Mar 2013 16:24:49 GMT 2013-03-01T16:24:49Z Calculos Set Analise https://community.qlik.com/t5/Brasil/Calculos-Set-Analise/m-p/398734#M11021 <HTML><HEAD></HEAD><BODY><P>Queridos possuo um calculo ..</P><P></P><P>sum(SaldoR) + (Sum({&lt;TIPOR = {'C'}&gt;}CNVALOR4)) </P><P></P><P>onde o saldoR é de uma tabela concatenada com outra tabela que possua CNVALOR4 contudo o CNVALOR4 deve possuir um tipoR = C, que no saldoR não possui , entao ,e ele me apresenta valor nulo pra tipoR , queria saber como resolvo , esse probelema , pra o saldoR apresentar o valor correto somado com o CNVALOR4 ..</P><P></P><P></P><P>quando coloco .. </P><P>na tabela </P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Header 1</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Header 2</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>TIPOR</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Header 4</STRONG></SPAN></TH></TR><TR><TD>grupo</TD><TD>subgrupo</TD><TD>C</TD><TD>1000</TD></TR><TR><TD>grupo</TD><TD>subgrupo</TD><TD>- </TD><TD>1000</TD></TR></TBODY></TABLE><P></P><P></P><P></P><P></P><P>queria que apresentasse como abaixo sem alterar nos valores ..</P><P></P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Header 1</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Header 2</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Header 3</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Header 4</STRONG></SPAN></TH></TR><TR><TD>grupo</TD><TD>subgrupo</TD><TD>C</TD><TD>1000</TD></TR></TBODY></TABLE></BODY></HTML> Fri, 01 Mar 2013 15:29:22 GMT https://community.qlik.com/t5/Brasil/Calculos-Set-Analise/m-p/398734#M11021 2013-03-01T15:29:22Z Re: Calculos Set Analise https://community.qlik.com/t5/Brasil/Calculos-Set-Analise/m-p/398735#M11022 <HTML><HEAD></HEAD><BODY><P>sum( {$&lt;<SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">TIPOR </SPAN>= {<SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">C</SPAN>} &gt;} <SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">CNVALOR4</SPAN>)</P></BODY></HTML> Fri, 01 Mar 2013 16:24:49 GMT https://community.qlik.com/t5/Brasil/Calculos-Set-Analise/m-p/398735#M11022 2013-03-01T16:24:49Z Re: Calculos Set Analise https://community.qlik.com/t5/Brasil/Calculos-Set-Analise/m-p/398736#M11023 <HTML><HEAD></HEAD><BODY><P>Nao funcionou .. :S</P></BODY></HTML> Fri, 01 Mar 2013 17:25:33 GMT https://community.qlik.com/t5/Brasil/Calculos-Set-Analise/m-p/398736#M11023 2013-03-01T17:25:33Z Re: Calculos Set Analise https://community.qlik.com/t5/Brasil/Calculos-Set-Analise/m-p/398737#M11024 <HTML><HEAD></HEAD><BODY><P>Olá Nickolas,</P><P></P><P>Tem uma opção que oculta valores nulos, que pode ser na aba de dimensões ou de apresentação, dependo do objeto que você está usando, basta escolhe a coluna de tipos e marcar essa opção nas propriedades do objeto que terá o resuldado esperado.</P><P></P><P>Abraço.</P></BODY></HTML> Fri, 01 Mar 2013 17:32:32 GMT https://community.qlik.com/t5/Brasil/Calculos-Set-Analise/m-p/398737#M11024 aderlanrm 2013-03-01T17:32:32Z