topic How to do this in set analysis? in QlikView https://community.qlik.com/t5/QlikView/How-to-do-this-in-set-analysis/m-p/306631#M1185003 <HTML><HEAD></HEAD><BODY><P> If I understand correctly, you want to select companies from a list box, and exclude those selections from a chart, which I assume will default to show all companies?</P><P></P><P>Could you use sum({1-$}Revenue). This will give the inverse of the current selection ie everything that the current selection excludes.</P><P></P><P>Note that if you are selecting on more than one dimension, it will exclude those selections as well.</P></BODY></HTML> Mon, 03 Oct 2011 11:31:08 GMT mazacini 2011-10-03T11:31:08Z How to do this in set analysis? https://community.qlik.com/t5/QlikView/How-to-do-this-in-set-analysis/m-p/306630#M1185002 <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:27:17 GMT https://community.qlik.com/t5/QlikView/How-to-do-this-in-set-analysis/m-p/306630#M1185002 2011-10-03T03:27:17Z How to do this in set analysis? https://community.qlik.com/t5/QlikView/How-to-do-this-in-set-analysis/m-p/306631#M1185003 <HTML><HEAD></HEAD><BODY><P> If I understand correctly, you want to select companies from a list box, and exclude those selections from a chart, which I assume will default to show all companies?</P><P></P><P>Could you use sum({1-$}Revenue). This will give the inverse of the current selection ie everything that the current selection excludes.</P><P></P><P>Note that if you are selecting on more than one dimension, it will exclude those selections as well.</P></BODY></HTML> Mon, 03 Oct 2011 11:31:08 GMT https://community.qlik.com/t5/QlikView/How-to-do-this-in-set-analysis/m-p/306631#M1185003 mazacini 2011-10-03T11:31:08Z Re: How to do this in set analysis? https://community.qlik.com/t5/QlikView/How-to-do-this-in-set-analysis/m-p/306632#M1185004 <HTML><HEAD></HEAD><BODY><P>try this </P><P></P><P>=if(getselectedCount(fieldnamein seleection)&gt;0,Sum({1-$} Revenue),sum(amountfieldname))</P><P></P><P>or see the attached file for example</P></BODY></HTML> Mon, 03 Oct 2011 12:17:43 GMT https://community.qlik.com/t5/QlikView/How-to-do-this-in-set-analysis/m-p/306632#M1185004 SunilChauhan 2011-10-03T12:17:43Z