topic Filter in QlikView https://community.qlik.com/t5/QlikView/Filter/m-p/160178#M34545 <HTML><HEAD></HEAD><BODY><P><SPAN closure_uid_ai983a="1613" style="background-color: #fff;" xc="Ola," yc="Hello,">Hello,<BR /><BR /></SPAN><SPAN closure_uid_ai983a="1614" style="background-color: #fff;" xc="Estou utilizando a seguinte função: SUM( {1&lt;YEAR=P(YEAR)&gt;} Sales )." yc="I am using the following function: SUM ((1) &lt;YEAR=P(YEAR)&gt; Sales).">I am using the following function: SUM ((1) &lt;YEAR=P(YEAR)&gt; Sales).<BR /></SPAN> <SPAN closure_uid_ai983a="1615" style="background-color: #fff;" xc="Essa função serve para mostrar o valor das vendas no ano, conforme o ano selecionado no objeto SELEÇÃO MULTIPLA eo resultado dessa venda está dentro de uma tabela que no primeiro campo é um GRUPO e no segundo é o resultado das vendas." yc="This function serves to show the value of sales in the year, according to the year selected in the Multiple Selection object and the result of this sale is within a table in the first field is a group and the second is the result of sales.">This function serves to show the value of sales in the year, according to the year selected in the Multiple Selection object and the result of this sale is within a table in the first field is a group and the second is the result of sales.<BR /></SPAN> <SPAN closure_uid_ai983a="1616" style="background-color: #fff;" xc="No GRUPO estão os campos de Empresa e Produto." yc="Group are in the fields of company and product.">Group are in the fields of company and product.<BR /><BR /></SPAN> <SPAN closure_uid_ai983a="1617" style="background-color: #fff;" xc="Quando nesse GRUPO a seleção é Empresa o resultado sai correto, mais se mudo para Produto o valor muda." yc="When that group selection is the result comes out right company, the more you change the value to product changes.">When that group selection is the result comes out right company, the more you change the value to product changes.<BR /><BR /></SPAN> <SPAN closure_uid_ai983a="1618" style="background-color: #fff;" xc="Alguém sabe uma maneira de resolver esse problema?" yc="Does anyone know a way to solve this problem?">Does anyone know a way to solve this problem?<BR /></SPAN><SPAN closure_uid_ai983a="1621" style="background-color: #fff;" xc="Preciso travar a soma das vendas do ano independente de qualquer outro filtro." yc="I need to catch the sum of sales of the year regardless of any other filter.">I need to catch the sum of sales of the year regardless of any other filter.<BR /><BR /></SPAN> Thank you.</P></BODY></HTML> Fri, 13 Aug 2010 14:09:24 GMT Anonymous 2010-08-13T14:09:24Z Filter https://community.qlik.com/t5/QlikView/Filter/m-p/160178#M34545 <HTML><HEAD></HEAD><BODY><P><SPAN closure_uid_ai983a="1613" style="background-color: #fff;" xc="Ola," yc="Hello,">Hello,<BR /><BR /></SPAN><SPAN closure_uid_ai983a="1614" style="background-color: #fff;" xc="Estou utilizando a seguinte função: SUM( {1&lt;YEAR=P(YEAR)&gt;} Sales )." yc="I am using the following function: SUM ((1) &lt;YEAR=P(YEAR)&gt; Sales).">I am using the following function: SUM ((1) &lt;YEAR=P(YEAR)&gt; Sales).<BR /></SPAN> <SPAN closure_uid_ai983a="1615" style="background-color: #fff;" xc="Essa função serve para mostrar o valor das vendas no ano, conforme o ano selecionado no objeto SELEÇÃO MULTIPLA eo resultado dessa venda está dentro de uma tabela que no primeiro campo é um GRUPO e no segundo é o resultado das vendas." yc="This function serves to show the value of sales in the year, according to the year selected in the Multiple Selection object and the result of this sale is within a table in the first field is a group and the second is the result of sales.">This function serves to show the value of sales in the year, according to the year selected in the Multiple Selection object and the result of this sale is within a table in the first field is a group and the second is the result of sales.<BR /></SPAN> <SPAN closure_uid_ai983a="1616" style="background-color: #fff;" xc="No GRUPO estão os campos de Empresa e Produto." yc="Group are in the fields of company and product.">Group are in the fields of company and product.<BR /><BR /></SPAN> <SPAN closure_uid_ai983a="1617" style="background-color: #fff;" xc="Quando nesse GRUPO a seleção é Empresa o resultado sai correto, mais se mudo para Produto o valor muda." yc="When that group selection is the result comes out right company, the more you change the value to product changes.">When that group selection is the result comes out right company, the more you change the value to product changes.<BR /><BR /></SPAN> <SPAN closure_uid_ai983a="1618" style="background-color: #fff;" xc="Alguém sabe uma maneira de resolver esse problema?" yc="Does anyone know a way to solve this problem?">Does anyone know a way to solve this problem?<BR /></SPAN><SPAN closure_uid_ai983a="1621" style="background-color: #fff;" xc="Preciso travar a soma das vendas do ano independente de qualquer outro filtro." yc="I need to catch the sum of sales of the year regardless of any other filter.">I need to catch the sum of sales of the year regardless of any other filter.<BR /><BR /></SPAN> Thank you.</P></BODY></HTML> Fri, 13 Aug 2010 14:09:24 GMT https://community.qlik.com/t5/QlikView/Filter/m-p/160178#M34545 Anonymous 2010-08-13T14:09:24Z Re. :Filter https://community.qlik.com/t5/QlikView/Filter/m-p/160179#M34546 <HTML><HEAD></HEAD><BODY><P>Your function must be :</P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">SUM ({1&lt;YEAR=P(YEAR)&gt;} Sales)</PRE></BLOCKQUOTE><BR /><BR /></BODY></HTML> Fri, 13 Aug 2010 14:30:04 GMT https://community.qlik.com/t5/QlikView/Filter/m-p/160179#M34546 martin59 2010-08-13T14:30:04Z Re. :Filter https://community.qlik.com/t5/QlikView/Filter/m-p/160180#M34547 <HTML><HEAD></HEAD><BODY><P>I am using that function.</P></BODY></HTML> Fri, 13 Aug 2010 14:55:58 GMT https://community.qlik.com/t5/QlikView/Filter/m-p/160180#M34547 Anonymous 2010-08-13T14:55:58Z Re. :Filter https://community.qlik.com/t5/QlikView/Filter/m-p/160181#M34548 <HTML><HEAD></HEAD><BODY><P>Different parens/ uses elipses...</P></BODY></HTML> Fri, 13 Aug 2010 16:48:20 GMT https://community.qlik.com/t5/QlikView/Filter/m-p/160181#M34548 2010-08-13T16:48:20Z