topic A somewhat complicated set analysis problem in QlikView https://community.qlik.com/t5/QlikView/A-somewhat-complicated-set-analysis-problem/m-p/21855#M3624 <HTML><HEAD></HEAD><BODY><P>Hi everyone!</P><P></P><P>I'd like to consider myself a intermediate to moderate set analysis user, but I have a scenario that I just can't seem to wrap my head around.</P><P></P><P>What I'm trying to do is get the total (in $) of orders, which are at a part/customer/fiscal qtr level, BUT only where the total of the part/customer/fiscal qtr level item is greater than a particular value.</P><P></P><P>For example, I have three parts (A through C), and each part is purchased by customers 1 through 3. I want to get a total of the orders for all parts and customers, but only for the big buyers, where their orders are over $1,000,000.</P><P></P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/197727_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P>I've tried using AGGR(), RANGESUM(), and different methods of using the ONLY() function, but nothing I'm trying seems to work.</P><P></P><P>Any thoughts/ideas/help?</P></BODY></HTML> Wed, 28 Mar 2018 05:07:50 GMT Anonymous 2018-03-28T05:07:50Z A somewhat complicated set analysis problem https://community.qlik.com/t5/QlikView/A-somewhat-complicated-set-analysis-problem/m-p/21855#M3624 <HTML><HEAD></HEAD><BODY><P>Hi everyone!</P><P></P><P>I'd like to consider myself a intermediate to moderate set analysis user, but I have a scenario that I just can't seem to wrap my head around.</P><P></P><P>What I'm trying to do is get the total (in $) of orders, which are at a part/customer/fiscal qtr level, BUT only where the total of the part/customer/fiscal qtr level item is greater than a particular value.</P><P></P><P>For example, I have three parts (A through C), and each part is purchased by customers 1 through 3. I want to get a total of the orders for all parts and customers, but only for the big buyers, where their orders are over $1,000,000.</P><P></P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/197727_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P>I've tried using AGGR(), RANGESUM(), and different methods of using the ONLY() function, but nothing I'm trying seems to work.</P><P></P><P>Any thoughts/ideas/help?</P></BODY></HTML> Wed, 28 Mar 2018 05:07:50 GMT https://community.qlik.com/t5/QlikView/A-somewhat-complicated-set-analysis-problem/m-p/21855#M3624 Anonymous 2018-03-28T05:07:50Z Re: A somewhat complicated set analysis problem https://community.qlik.com/t5/QlikView/A-somewhat-complicated-set-analysis-problem/m-p/21856#M3625 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>Sum(Aggr(If(Sum(Orders) &gt; 1000000, Sum(Orders)), Part, Customer))</STRONG></P></BODY></HTML> Wed, 28 Mar 2018 14:33:24 GMT https://community.qlik.com/t5/QlikView/A-somewhat-complicated-set-analysis-problem/m-p/21856#M3625 sunny_talwar 2018-03-28T14:33:24Z Re: A somewhat complicated set analysis problem https://community.qlik.com/t5/QlikView/A-somewhat-complicated-set-analysis-problem/m-p/21857#M3626 <HTML><HEAD></HEAD><BODY><P>That absolutely did the trick! Thank you so much!</P></BODY></HTML> Wed, 28 Mar 2018 21:43:41 GMT https://community.qlik.com/t5/QlikView/A-somewhat-complicated-set-analysis-problem/m-p/21857#M3626 Anonymous 2018-03-28T21:43:41Z