topic Re: How to achieve this using set analysis? in QlikView https://community.qlik.com/t5/QlikView/How-to-achieve-this-using-set-analysis/m-p/306552#M113222 <HTML><HEAD></HEAD><BODY><P> hei </P><P></P><P>attach is an example of what you asked for</P><P></P><P>the expression goes like this</P><P></P><P>assume the user select values in the company field</P><P></P><P>sum({&lt;company=E(company)&gt;} Sales)</P><P></P><P></P><P>hope its helps you</P></BODY></HTML> Mon, 03 Oct 2011 06:34:52 GMT lironbaram 2011-10-03T06:34:52Z How to achieve this using set analysis? https://community.qlik.com/t5/QlikView/How-to-achieve-this-using-set-analysis/m-p/306551#M113221 <HTML><HEAD></HEAD><BODY><P>Hi, in my application, there is a list box for user to choose which companies they would like to exclude from the chart. My chart is used to display the total revenue of each company for each fiscal year. How should i write the set analysis in order to achieve the purpose of excluding those companies selected by the user? Thanks much, I really need a solution asap. Thanks in advance!</P></BODY></HTML> Mon, 03 Oct 2011 03:25:27 GMT https://community.qlik.com/t5/QlikView/How-to-achieve-this-using-set-analysis/m-p/306551#M113221 2011-10-03T03:25:27Z Re: How to achieve this using set analysis? https://community.qlik.com/t5/QlikView/How-to-achieve-this-using-set-analysis/m-p/306552#M113222 <HTML><HEAD></HEAD><BODY><P> hei </P><P></P><P>attach is an example of what you asked for</P><P></P><P>the expression goes like this</P><P></P><P>assume the user select values in the company field</P><P></P><P>sum({&lt;company=E(company)&gt;} Sales)</P><P></P><P></P><P>hope its helps you</P></BODY></HTML> Mon, 03 Oct 2011 06:34:52 GMT https://community.qlik.com/t5/QlikView/How-to-achieve-this-using-set-analysis/m-p/306552#M113222 lironbaram 2011-10-03T06:34:52Z Re: How to achieve this using set analysis? https://community.qlik.com/t5/QlikView/How-to-achieve-this-using-set-analysis/m-p/306553#M113223 <HTML><HEAD></HEAD><BODY><P>Hi Liron, thanks a lot for your help! I have another problem (Please refer to&nbsp;this <A _jive_internal="true" href="https://community.qlik.com/thread/36518">post</A>). Would you mind to help me? Thank you very much!</P></BODY></HTML> Mon, 03 Oct 2011 08:07:57 GMT https://community.qlik.com/t5/QlikView/How-to-achieve-this-using-set-analysis/m-p/306553#M113223 2011-10-03T08:07:57Z