topic Filters in QlikView https://community.qlik.com/t5/QlikView/Filters/m-p/159153#M33917 <HTML><HEAD></HEAD><BODY><P>Try</P><P>Sum({1&lt;Year=P(Year)&gt;}Sales)</P></BODY></HTML> Thu, 12 Aug 2010 19:24:39 GMT danielrozental 2010-08-12T19:24:39Z Filters https://community.qlik.com/t5/QlikView/Filters/m-p/159152#M33916 <HTML><HEAD></HEAD><BODY><P>Hello ..<BR /><BR />I created several fields that are within the Multiple Selection object where are the fields of Day, Month and Year also a table that brings the total sales.<BR /><BR />What I need is that when you filter by year, the table will bring the total sales that year. I am using the expression Sum (Sales). Also if I select another filter more accurate than the sum of sales continue trazenda just the sum of sales of the year.<BR /><BR />I managed to make it to work.<BR /><BR />Can anyone help?</P></BODY></HTML> Thu, 12 Aug 2010 19:10:31 GMT https://community.qlik.com/t5/QlikView/Filters/m-p/159152#M33916 Anonymous 2010-08-12T19:10:31Z Filters https://community.qlik.com/t5/QlikView/Filters/m-p/159153#M33917 <HTML><HEAD></HEAD><BODY><P>Try</P><P>Sum({1&lt;Year=P(Year)&gt;}Sales)</P></BODY></HTML> Thu, 12 Aug 2010 19:24:39 GMT https://community.qlik.com/t5/QlikView/Filters/m-p/159153#M33917 danielrozental 2010-08-12T19:24:39Z Filters https://community.qlik.com/t5/QlikView/Filters/m-p/159154#M33918 <HTML><HEAD></HEAD><BODY><P>You need use set analisys....</P><P></P><P>something like <B>Sum({1&lt;Year={$(=Only(Ano))}&gt;} Sales)</B></P><P></P><P style="font-weight: bold">Em troca....tira esse simbolo dai....rs</P><P></P><DIV class="O" style="font-weight: bold"><BR /></DIV><BR /><BR /></BODY></HTML> Thu, 12 Aug 2010 19:27:04 GMT https://community.qlik.com/t5/QlikView/Filters/m-p/159154#M33918 2010-08-12T19:27:04Z Filters https://community.qlik.com/t5/QlikView/Filters/m-p/159155#M33919 <HTML><HEAD></HEAD><BODY><P>Obrigado...Deu certo...</P><P>Ainda tem pouca estrela nesse símbolo.</P><P>Deixa juntar mais que eu tiro..rsrsrs</P></BODY></HTML> Thu, 12 Aug 2010 19:33:18 GMT https://community.qlik.com/t5/QlikView/Filters/m-p/159155#M33919 Anonymous 2010-08-12T19:33:18Z