topic Re: Filtro em dimensões de tabelas diferentes in Brasil https://community.qlik.com/t5/Brasil/Filtro-em-dimens%C3%B5es-de-tabelas-diferentes/m-p/1285776#M46084 <HTML><HEAD></HEAD><BODY><P>Amigo, tente;</P><P><SPAN style="color: black; font-style: inherit; font-weight: inherit; font-size: 9pt !important;"><BR /></SPAN></P><PRE __default_attr="sql" __jive_macro_name="code" class="jive_macro_code jive_text_macro _jivemacro_uid_14894983571755811" jivemacro_uid="_14894983571755811"> <P><SPAN style="color: black; font-style: inherit; font-weight: inherit; font-size: 9pt !important;">Sum({$</SPAN><SPAN class="tag" style="font-style: inherit; font-weight: bold; color: #006699; font-size: 9pt !important;">&lt;</SPAN><SPAN style="color: black; font-style: inherit; font-weight: inherit; font-size: 9pt !important;"> [CR / CP]={'CR'}, </SPAN><SPAN class="attribute" style="font-style: inherit; font-weight: inherit; color: red; font-size: 9pt !important;">PAGO_SN</SPAN><SPAN style="color: black; font-style: inherit; font-weight: inherit; font-size: 9pt !important;">={</SPAN><SPAN class="attribute-value" style="font-style: inherit; font-weight: inherit; color: blue; font-size: 9pt !important;">'N'} </SPAN><SPAN class="tag" style="font-style: inherit; font-weight: bold; color: #006699; font-size: 9pt !important;">&gt;</SPAN><SPAN style="color: black; font-style: inherit; font-weight: inherit; font-size: 9pt !important;">} [Valor Titulo])</SPAN></P> </PRE></BODY></HTML> Tue, 14 Mar 2017 13:29:16 GMT mario_sergio_ti 2017-03-14T13:29:16Z Filtro em dimensões de tabelas diferentes https://community.qlik.com/t5/Brasil/Filtro-em-dimens%C3%B5es-de-tabelas-diferentes/m-p/1285775#M46083 <HTML><HEAD></HEAD><BODY><P>Olá pessoal tudo bem? Estou tentando realizar o filtro em duas tabelas, porém sempre aparece zerado.</P><P></P><P>Fiz a seguinte expressão set</P><P></P><PRE __default_attr="xml" __jive_macro_name="code" class="jive_macro_code _jivemacro_uid_14894969863418957 jive_text_macro" jivemacro_uid="_14894969863418957"> <P>Sum({$&lt; [CR / CP] ='CR', PAGO_SN ='N'&gt;} [Valor Titulo])</P> </PRE><P></P><P></P><P>Segue estrutura: </P><P><IMG alt="print duvida 01.png" class="jive-image image-1" src="/legacyfs/online/156246_print duvida 01.png" style="height: auto;" /></P><P></P><P>Segue print dos dados exibidos:</P><P><IMG alt="print duvida 02.png" class="jive-image image-2" src="/legacyfs/online/156247_print duvida 02.png" style="height: auto;" /></P></BODY></HTML> Tue, 14 Mar 2017 13:13:58 GMT https://community.qlik.com/t5/Brasil/Filtro-em-dimens%C3%B5es-de-tabelas-diferentes/m-p/1285775#M46083 rbarbosa 2017-03-14T13:13:58Z Re: Filtro em dimensões de tabelas diferentes https://community.qlik.com/t5/Brasil/Filtro-em-dimens%C3%B5es-de-tabelas-diferentes/m-p/1285776#M46084 <HTML><HEAD></HEAD><BODY><P>Amigo, tente;</P><P><SPAN style="color: black; font-style: inherit; font-weight: inherit; font-size: 9pt !important;"><BR /></SPAN></P><PRE __default_attr="sql" __jive_macro_name="code" class="jive_macro_code jive_text_macro _jivemacro_uid_14894983571755811" jivemacro_uid="_14894983571755811"> <P><SPAN style="color: black; font-style: inherit; font-weight: inherit; font-size: 9pt !important;">Sum({$</SPAN><SPAN class="tag" style="font-style: inherit; font-weight: bold; color: #006699; font-size: 9pt !important;">&lt;</SPAN><SPAN style="color: black; font-style: inherit; font-weight: inherit; font-size: 9pt !important;"> [CR / CP]={'CR'}, </SPAN><SPAN class="attribute" style="font-style: inherit; font-weight: inherit; color: red; font-size: 9pt !important;">PAGO_SN</SPAN><SPAN style="color: black; font-style: inherit; font-weight: inherit; font-size: 9pt !important;">={</SPAN><SPAN class="attribute-value" style="font-style: inherit; font-weight: inherit; color: blue; font-size: 9pt !important;">'N'} </SPAN><SPAN class="tag" style="font-style: inherit; font-weight: bold; color: #006699; font-size: 9pt !important;">&gt;</SPAN><SPAN style="color: black; font-style: inherit; font-weight: inherit; font-size: 9pt !important;">} [Valor Titulo])</SPAN></P> </PRE></BODY></HTML> Tue, 14 Mar 2017 13:29:16 GMT https://community.qlik.com/t5/Brasil/Filtro-em-dimens%C3%B5es-de-tabelas-diferentes/m-p/1285776#M46084 mario_sergio_ti 2017-03-14T13:29:16Z Re: Filtro em dimensões de tabelas diferentes https://community.qlik.com/t5/Brasil/Filtro-em-dimens%C3%B5es-de-tabelas-diferentes/m-p/1285777#M46085 <HTML><HEAD></HEAD><BODY><P>Muito obrigado Mario! Funcionou!</P></BODY></HTML> Tue, 14 Mar 2017 13:55:24 GMT https://community.qlik.com/t5/Brasil/Filtro-em-dimens%C3%B5es-de-tabelas-diferentes/m-p/1285777#M46085 rbarbosa 2017-03-14T13:55:24Z Re: Filtro em dimensões de tabelas diferentes https://community.qlik.com/t5/Brasil/Filtro-em-dimens%C3%B5es-de-tabelas-diferentes/m-p/1285778#M46086 <HTML><HEAD></HEAD><BODY><P>Que ótimo amigo;</P><P>Abraço.</P></BODY></HTML> Tue, 14 Mar 2017 14:09:02 GMT https://community.qlik.com/t5/Brasil/Filtro-em-dimens%C3%B5es-de-tabelas-diferentes/m-p/1285778#M46086 mario_sergio_ti 2017-03-14T14:09:02Z