topic Re: Stuck with a set analysis formula... in QlikView https://community.qlik.com/t5/QlikView/Stuck-with-a-set-analysis-formula/m-p/867249#M303377 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>"needed" is not a dimension but an expression I'm trying to figure out. Field C and D need to be part of the table, that's the catch...</P></BODY></HTML> Wed, 10 Jun 2015 16:17:14 GMT 2015-06-10T16:17:14Z Stuck with a set analysis formula... https://community.qlik.com/t5/QlikView/Stuck-with-a-set-analysis-formula/m-p/867246#M303374 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Could someone please help with some Set Analysis? The goal is to get the results on the "needed column" below. it sums up all deals that have Fields A and B in common. Thanks in advance!</P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="320"><TBODY><TR><TD height="20" width="64">Field A</TD><TD width="64">Field B</TD><TD width="64">Field C</TD><TD width="64">Field D</TD><TD width="64">Needed</TD></TR><TR><TD height="20">Account1</TD><TD>Type1</TD><TD>DealA</TD><TD align="right">10</TD><TD align="right">15</TD></TR><TR><TD height="20">Account2</TD><TD>Type2</TD><TD>DealB</TD><TD align="right">5</TD><TD align="right">12</TD></TR><TR><TD height="20">Account1</TD><TD>Type3</TD><TD>DealC</TD><TD align="right">8</TD><TD align="right">8</TD></TR><TR><TD height="20">Account2</TD><TD>Type2</TD><TD>DealD</TD><TD align="right">7</TD><TD align="right">12</TD></TR><TR><TD height="20">Account1</TD><TD>Type1</TD><TD>DealE</TD><TD align="right">5</TD><TD align="right">15</TD></TR><TR><TD height="20">Account2</TD><TD>Type4</TD><TD>DealF</TD><TD align="right">9</TD><TD align="right">9</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 10 Jun 2015 16:03:26 GMT https://community.qlik.com/t5/QlikView/Stuck-with-a-set-analysis-formula/m-p/867246#M303374 2015-06-10T16:03:26Z Re: Stuck with a set analysis formula... https://community.qlik.com/t5/QlikView/Stuck-with-a-set-analysis-formula/m-p/867247#M303375 <HTML><HEAD></HEAD><BODY><P>Have you tried creating a chart with <STRONG>Field A</STRONG> and <STRONG>Field B</STRONG> as dimension and Expression:&nbsp; <STRONG>Sum(Needed)</STRONG>?</P></BODY></HTML> Wed, 10 Jun 2015 16:14:09 GMT https://community.qlik.com/t5/QlikView/Stuck-with-a-set-analysis-formula/m-p/867247#M303375 sunny_talwar 2015-06-10T16:14:09Z Re: Stuck with a set analysis formula... https://community.qlik.com/t5/QlikView/Stuck-with-a-set-analysis-formula/m-p/867248#M303376 <HTML><HEAD></HEAD><BODY><P>Does this look like what you need?</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/88975_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Wed, 10 Jun 2015 16:16:03 GMT https://community.qlik.com/t5/QlikView/Stuck-with-a-set-analysis-formula/m-p/867248#M303376 sunny_talwar 2015-06-10T16:16:03Z Re: Stuck with a set analysis formula... https://community.qlik.com/t5/QlikView/Stuck-with-a-set-analysis-formula/m-p/867249#M303377 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>"needed" is not a dimension but an expression I'm trying to figure out. Field C and D need to be part of the table, that's the catch...</P></BODY></HTML> Wed, 10 Jun 2015 16:17:14 GMT https://community.qlik.com/t5/QlikView/Stuck-with-a-set-analysis-formula/m-p/867249#M303377 2015-06-10T16:17:14Z Re: Stuck with a set analysis formula... https://community.qlik.com/t5/QlikView/Stuck-with-a-set-analysis-formula/m-p/867250#M303378 <HTML><HEAD></HEAD><BODY><P>You can use an Aggregate function for that,</P><P>Aggr(NODISTINCT Sum([Field D]),[Field A],[Field B])</P><P></P><P>See also attached</P></BODY></HTML> Wed, 10 Jun 2015 16:20:27 GMT https://community.qlik.com/t5/QlikView/Stuck-with-a-set-analysis-formula/m-p/867250#M303378 stigchel 2015-06-10T16:20:27Z Re: Stuck with a set analysis formula... https://community.qlik.com/t5/QlikView/Stuck-with-a-set-analysis-formula/m-p/867251#M303379 <HTML><HEAD></HEAD><BODY><P>This?</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/88979_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Wed, 10 Jun 2015 16:20:37 GMT https://community.qlik.com/t5/QlikView/Stuck-with-a-set-analysis-formula/m-p/867251#M303379 sunny_talwar 2015-06-10T16:20:37Z Re: Stuck with a set analysis formula... https://community.qlik.com/t5/QlikView/Stuck-with-a-set-analysis-formula/m-p/867252#M303380 <HTML><HEAD></HEAD><BODY><P>Oh I see what you want now. Is this looks like what you want?</P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/88980_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Wed, 10 Jun 2015 16:23:43 GMT https://community.qlik.com/t5/QlikView/Stuck-with-a-set-analysis-formula/m-p/867252#M303380 sunny_talwar 2015-06-10T16:23:43Z Re: Stuck with a set analysis formula... https://community.qlik.com/t5/QlikView/Stuck-with-a-set-analysis-formula/m-p/867253#M303381 <HTML><HEAD></HEAD><BODY><P>Yes it does!</P></BODY></HTML> Wed, 10 Jun 2015 16:25:20 GMT https://community.qlik.com/t5/QlikView/Stuck-with-a-set-analysis-formula/m-p/867253#M303381 2015-06-10T16:25:20Z Re: Stuck with a set analysis formula... https://community.qlik.com/t5/QlikView/Stuck-with-a-set-analysis-formula/m-p/867254#M303382 <HTML><HEAD></HEAD><BODY><P>i don't think u will get ur expected output straight way,because when u try to add ur third dimension "<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Field C</SPAN>" on dimension tab,tht will split/group accordingly.</P></BODY></HTML> Wed, 10 Jun 2015 16:28:36 GMT https://community.qlik.com/t5/QlikView/Stuck-with-a-set-analysis-formula/m-p/867254#M303382 buzzy996 2015-06-10T16:28:36Z Re: Stuck with a set analysis formula... https://community.qlik.com/t5/QlikView/Stuck-with-a-set-analysis-formula/m-p/867255#M303383 <HTML><HEAD></HEAD><BODY><P>You need Dimension: <STRONG>Field A, Field B, Field C</STRONG></P><P>Expression: <STRONG>=Sum(TOTAL &lt;[Field A], [Field B]&gt;[Field D])</STRONG></P></BODY></HTML> Wed, 10 Jun 2015 16:31:33 GMT https://community.qlik.com/t5/QlikView/Stuck-with-a-set-analysis-formula/m-p/867255#M303383 sunny_talwar 2015-06-10T16:31:33Z