topic Re: Filtro Tabela Dinâmica in Brasil https://community.qlik.com/t5/Brasil/Filtro-Tabela-Din%C3%A2mica/m-p/850096#M27609 <HTML><HEAD></HEAD><BODY><P>se você tiver apenas um expresssion você pode usar esse recurso:</P><P><IMG alt="29-Apr-15 3-39-24 PM.jpg" class="jive-image image-1" src="/legacyfs/online/85359_29-Apr-15 3-39-24 PM.jpg" style="height: auto;" /></P></BODY></HTML> Wed, 29 Apr 2015 14:40:43 GMT robert_mika 2015-04-29T14:40:43Z Filtro Tabela Dinâmica https://community.qlik.com/t5/Brasil/Filtro-Tabela-Din%C3%A2mica/m-p/850095#M27608 <HTML><HEAD></HEAD><BODY><P>Olá pessoALL,</P><P>Estou precisando de ajuda para solucionar o seguinte problema. Bom, tenho uma tabela dinâmica onde promovo um calculo através de uma expression. O que preciso é aplicar um filtro no resultado gerado pela expression e esse resultado vai impactar a apresentação da tabela dinâmica. Exemplo:</P><P></P><P>&lt;Tabela Inicial&gt;</P><P></P><P>Campo&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp; Qtd</P><P>Arroz&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P>Feijão&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P>Macarrão&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P>Batata&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P>Café&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P></P><P>O campo QTD é gerado através da expression e preciso filtra-lo para apresentar o seguinte resultado:</P><P></P><P><SPAN style="font-size: 13.3333330154419px;">&lt;Tabela Resultado Final&gt;</SPAN></P><P><SPAN style="font-size: 13.3333330154419px;"><BR /></SPAN></P><P style="font-size: 13.3333330154419px;">Campo&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp; Qtd</P><P style="font-size: 13.3333330154419px;">Feijão&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P style="font-size: 13.3333330154419px;">Macarrão&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P style="font-size: 13.3333330154419px;">Café&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</P></BODY></HTML> Wed, 29 Apr 2015 12:41:21 GMT https://community.qlik.com/t5/Brasil/Filtro-Tabela-Din%C3%A2mica/m-p/850095#M27608 2015-04-29T12:41:21Z Re: Filtro Tabela Dinâmica https://community.qlik.com/t5/Brasil/Filtro-Tabela-Din%C3%A2mica/m-p/850096#M27609 <HTML><HEAD></HEAD><BODY><P>se você tiver apenas um expresssion você pode usar esse recurso:</P><P><IMG alt="29-Apr-15 3-39-24 PM.jpg" class="jive-image image-1" src="/legacyfs/online/85359_29-Apr-15 3-39-24 PM.jpg" style="height: auto;" /></P></BODY></HTML> Wed, 29 Apr 2015 14:40:43 GMT https://community.qlik.com/t5/Brasil/Filtro-Tabela-Din%C3%A2mica/m-p/850096#M27609 robert_mika 2015-04-29T14:40:43Z Re: Filtro Tabela Dinâmica https://community.qlik.com/t5/Brasil/Filtro-Tabela-Din%C3%A2mica/m-p/850097#M27610 <HTML><HEAD></HEAD><BODY><P>Obrigado pela ajuda Robert, porém, o filtro relacionado me ajudou a resolver o problema.</P><P></P><P>---------------------------------------------------------------</P><P><A href="https://community.qlik.com/message/669210">Re: Filtering on Expressions</A></P><P><SPAN style="font-size: 13.3333330154419px;">---------------------------------------------------------------</SPAN></P></BODY></HTML> Wed, 29 Apr 2015 15:07:58 GMT https://community.qlik.com/t5/Brasil/Filtro-Tabela-Din%C3%A2mica/m-p/850097#M27610 2015-04-29T15:07:58Z