topic Re: Erro em soma condicional in Brasil https://community.qlik.com/t5/Brasil/Erro-em-soma-condicional/m-p/1290534#M46323 <HTML><HEAD></HEAD><BODY><P>Amigo, está faltando definir os campos a serem somados</P><P></P><PRE __default_attr="sql" __jive_macro_name="code" class="jive_macro_code jive_text_macro _jivemacro_uid_14872578707906707" jivemacro_uid="_14872578707906707" modifiedtitle="true"> <P>(</P> <P>&nbsp;&nbsp; SUM({$&lt;Tabela_DB_CR={'Tab DB'},[SZ2_Cod. Diretor]={'135'},[CTH_Tp ClasseVal]={02,10,17},SZ3_Descricao=,CHAVE_CT1010_DESC=CHAVE_CT1010_DESC-{'8230602'},SZ8_Descricao=&gt;} [CadeCampo1])</P> <P>&nbsp;&nbsp; +</P> <P>&nbsp;&nbsp; SUM({$&lt;Tabela_DB_CR={'Tab CR'},[SZ2_Cod. Diretor]={'135'},[CTH_Tp ClasseVal]={02,10,17},SZ3_Descricao=,CHAVE_CT1010_DESC=CHAVE_CT1010_DESC-{'8230602'},SZ8_Descricao=&gt;} [CadeCampo2])</P> <P>)/1000</P> </PRE><P></P><P>Substituí [CadeCampo1] e [CadeCampo2] pelos campos apropriados para a finalidade</P></BODY></HTML> Thu, 16 Feb 2017 15:09:04 GMT mario_sergio_ti 2017-02-16T15:09:04Z Erro em soma condicional https://community.qlik.com/t5/Brasil/Erro-em-soma-condicional/m-p/1290533#M46322 <HTML><HEAD></HEAD><BODY><P>Prezados, estou tentando fazer uma soma condicional porém algo está falhando. Notem que o segundo SUM já não está funcionando.</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" height="201" style="width: 805px; height: 201px;"><TBODY><TR><TD nowrap="nowrap" style="padding: 0 3.5pt 0 3.5pt;" width="567"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">=</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 3.5pt 0 3.5pt;" width="567"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">(</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 3.5pt 0 3.5pt;" width="567"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">SUM</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">({$&lt;</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">Tabela_DB_CR</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">={'Tab DB'},</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">[SZ2_Cod. Diretor]</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">={'135'},</SPAN><STRONG style=": ; color: maroon; font-size: 9.0pt; font-family: 'Courier New'; text-decoration: underline;">[CTH_Tp </STRONG><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">ClasseVal]</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">={02,10,17}</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">,</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">SZ3_Descricao</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">=,</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">CHAVE_CT1010_DESC</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">=</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">CHAVE_CT1010_DESC</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">-{'8230602'},SZ8_Descricao=&gt;}</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 3.5pt 0 3.5pt;" width="567"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">+</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 3.5pt 0 3.5pt;" width="567"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">SUM({$&lt;Tabela_DB_CR={'Tab CR'},</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">[SZ2_Cod. Diretor]</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">={'135'},</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">[CTH_Tp ClasseVal]</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">={02,10,17},SZ3_Descricao=,CHAVE_CT1010_DESC=CHAVE_CT1010_DESC-{'8230602'},SZ8_Descricao=&gt;}</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 3.5pt 0 3.5pt;" width="567"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">)/1000 </SPAN></P></TD></TR></TBODY></TABLE><P></P><P></P><P>Muito obrigado a todos.</P><P></P><P>Abs,</P></BODY></HTML> Thu, 16 Feb 2017 13:55:26 GMT https://community.qlik.com/t5/Brasil/Erro-em-soma-condicional/m-p/1290533#M46322 Anonymous 2017-02-16T13:55:26Z Re: Erro em soma condicional https://community.qlik.com/t5/Brasil/Erro-em-soma-condicional/m-p/1290534#M46323 <HTML><HEAD></HEAD><BODY><P>Amigo, está faltando definir os campos a serem somados</P><P></P><PRE __default_attr="sql" __jive_macro_name="code" class="jive_macro_code jive_text_macro _jivemacro_uid_14872578707906707" jivemacro_uid="_14872578707906707" modifiedtitle="true"> <P>(</P> <P>&nbsp;&nbsp; SUM({$&lt;Tabela_DB_CR={'Tab DB'},[SZ2_Cod. Diretor]={'135'},[CTH_Tp ClasseVal]={02,10,17},SZ3_Descricao=,CHAVE_CT1010_DESC=CHAVE_CT1010_DESC-{'8230602'},SZ8_Descricao=&gt;} [CadeCampo1])</P> <P>&nbsp;&nbsp; +</P> <P>&nbsp;&nbsp; SUM({$&lt;Tabela_DB_CR={'Tab CR'},[SZ2_Cod. Diretor]={'135'},[CTH_Tp ClasseVal]={02,10,17},SZ3_Descricao=,CHAVE_CT1010_DESC=CHAVE_CT1010_DESC-{'8230602'},SZ8_Descricao=&gt;} [CadeCampo2])</P> <P>)/1000</P> </PRE><P></P><P>Substituí [CadeCampo1] e [CadeCampo2] pelos campos apropriados para a finalidade</P></BODY></HTML> Thu, 16 Feb 2017 15:09:04 GMT https://community.qlik.com/t5/Brasil/Erro-em-soma-condicional/m-p/1290534#M46323 mario_sergio_ti 2017-02-16T15:09:04Z