https://community.qlik.com/t5/Visualization-and-Usability/Soma-com-condi%C3%A7%C3%A3o/m-p/1840655#M192557 <P>Prezados, boa tarde!<BR />Preciso de uma ajuda para montar a expressão...<BR /><BR />Preciso fazer a soma coluna VALOR se a coluna RLT_PL_CNTB_ESP = contem MMK e a coluna Branch = 86<BR />SUM({[RLT_PL_CNTB_ESP ='MMK*'&nbsp;]} &nbsp;and Branch = '86',&nbsp; VALOR_BRL)</P><P>&nbsp;</P><P>Obrigado.</P> Thu, 30 Sep 2021 18:00:28 GMT David_Almeida 2021-09-30T18:00:28Z https://community.qlik.com/t5/Visualization-and-Usability/Soma-com-condi%C3%A7%C3%A3o/m-p/1840655#M192557 <P>Prezados, boa tarde!<BR />Preciso de uma ajuda para montar a expressão...<BR /><BR />Preciso fazer a soma coluna VALOR se a coluna RLT_PL_CNTB_ESP = contem MMK e a coluna Branch = 86<BR />SUM({[RLT_PL_CNTB_ESP ='MMK*'&nbsp;]} &nbsp;and Branch = '86',&nbsp; VALOR_BRL)</P><P>&nbsp;</P><P>Obrigado.</P> Thu, 30 Sep 2021 18:00:28 GMT https://community.qlik.com/t5/Visualization-and-Usability/Soma-com-condi%C3%A7%C3%A3o/m-p/1840655#M192557 David_Almeida 2021-09-30T18:00:28Z https://community.qlik.com/t5/Visualization-and-Usability/Soma-com-condi%C3%A7%C3%A3o/m-p/1840717#M192574 <P>Something like this -&nbsp;</P><P><SPAN>SUM({&lt;[RLT_PL_CNTB_ESP] ={"*MMK*"}, Branch = {86}&gt;} VALOR_BRL )</SPAN></P> Fri, 01 Oct 2021 02:18:03 GMT https://community.qlik.com/t5/Visualization-and-Usability/Soma-com-condi%C3%A7%C3%A3o/m-p/1840717#M192574 Digvijay_Singh 2021-10-01T02:18:03Z https://community.qlik.com/t5/Visualization-and-Usability/Soma-com-condi%C3%A7%C3%A3o/m-p/1840855#M192621 <P>Ok, muito obrigado.</P><P>Deu certo.</P> Fri, 01 Oct 2021 11:56:52 GMT https://community.qlik.com/t5/Visualization-and-Usability/Soma-com-condi%C3%A7%C3%A3o/m-p/1840855#M192621 David_Almeida 2021-10-01T11:56:52Z https://community.qlik.com/t5/Visualization-and-Usability/Soma-com-condi%C3%A7%C3%A3o/m-p/1840861#M192623 <P>Please click&nbsp; 'Accept as Solution' for the post having right answer if it worked. Thanks!</P> Fri, 01 Oct 2021 12:03:25 GMT https://community.qlik.com/t5/Visualization-and-Usability/Soma-com-condi%C3%A7%C3%A3o/m-p/1840861#M192623 Digvijay_Singh 2021-10-01T12:03:25Z