topic Excluding Filter in QlikView https://community.qlik.com/t5/QlikView/Excluding-Filter/m-p/238053#M89034 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have a problem, i have this table:</P><P>Sales Own F/V</P><P>123 12 14</P><P>456 11 15</P><P>789 12 14</P><P>The columns in the table are filters, I need to sum sales ignoring the colum F/V, how can i do this??</P><P></P><P>Greetings</P><P></P><P>Carlos</P></BODY></HTML> Fri, 12 Feb 2010 20:28:01 GMT 2010-02-12T20:28:01Z Excluding Filter https://community.qlik.com/t5/QlikView/Excluding-Filter/m-p/238053#M89034 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have a problem, i have this table:</P><P>Sales Own F/V</P><P>123 12 14</P><P>456 11 15</P><P>789 12 14</P><P>The columns in the table are filters, I need to sum sales ignoring the colum F/V, how can i do this??</P><P></P><P>Greetings</P><P></P><P>Carlos</P></BODY></HTML> Fri, 12 Feb 2010 20:28:01 GMT https://community.qlik.com/t5/QlikView/Excluding-Filter/m-p/238053#M89034 2010-02-12T20:28:01Z Excluding Filter https://community.qlik.com/t5/QlikView/Excluding-Filter/m-p/238054#M89035 <HTML><HEAD></HEAD><BODY><P>hi</P><P>assuming i understood you</P><P>you can use set analsys</P><P>somthing in the lines of:</P><P>sum( {&lt;F/V = &gt;} Sales )</P><P>this way you calcuate the expression with out any selection in the field<BR /></P></BODY></HTML> Sun, 14 Feb 2010 09:04:25 GMT https://community.qlik.com/t5/QlikView/Excluding-Filter/m-p/238054#M89035 lironbaram 2010-02-14T09:04:25Z Excluding Filter https://community.qlik.com/t5/QlikView/Excluding-Filter/m-p/238055#M89036 <HTML><HEAD></HEAD><BODY><P>Thank you very much for your answer.</P><P>Greetings</P><P>Carlos</P></BODY></HTML> Mon, 15 Feb 2010 16:28:44 GMT https://community.qlik.com/t5/QlikView/Excluding-Filter/m-p/238055#M89036 2010-02-15T16:28:44Z