topic Re: Set Analysis: use field selection to define set in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-use-field-selection-to-define-set/m-p/818111#M288444 <HTML><HEAD></HEAD><BODY><P>Assuming that you have a unique identifier for each claim / quote (in this instance I assumed it is called ClaimID)</P><P>=sum(aggr(if(CLAIMYEAR = QUOTEYEAR,QUOTEV,0),ClaimID))</P></BODY></HTML> Wed, 12 Nov 2014 12:29:55 GMT 2014-11-12T12:29:55Z Set Analysis: use field selection to define set https://community.qlik.com/t5/QlikView/Set-Analysis-use-field-selection-to-define-set/m-p/818109#M288442 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Can anyone help, or point me to a discussion on using one field to subset another field.</P><P></P><P>I have a list CLAIMYEAR, and I want to select QUOTEYEAR and sum a value QUOTEV</P><P></P><P>Something like Sum({$&lt;QUOTEYEAR={CLAIMYEAR} &gt;} QUOTEV) ?</P><P></P><P>I.E. if CLAIMYEAR 2 and 3 are selected, I want the sum of QUOTEV for QUOTEYEAR's 2 &amp; 3...</P><P></P><P>Best regards,</P><P>M.</P></BODY></HTML> Wed, 12 Nov 2014 11:27:48 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-use-field-selection-to-define-set/m-p/818109#M288442 martynlloyd 2014-11-12T11:27:48Z Re: Set Analysis: use field selection to define set https://community.qlik.com/t5/QlikView/Set-Analysis-use-field-selection-to-define-set/m-p/818110#M288443 <HTML><HEAD></HEAD><BODY><P>sum(if (claimyear = quoteyear,quotev))</P></BODY></HTML> Wed, 12 Nov 2014 11:29:23 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-use-field-selection-to-define-set/m-p/818110#M288443 ali_hijazi 2014-11-12T11:29:23Z Re: Set Analysis: use field selection to define set https://community.qlik.com/t5/QlikView/Set-Analysis-use-field-selection-to-define-set/m-p/818111#M288444 <HTML><HEAD></HEAD><BODY><P>Assuming that you have a unique identifier for each claim / quote (in this instance I assumed it is called ClaimID)</P><P>=sum(aggr(if(CLAIMYEAR = QUOTEYEAR,QUOTEV,0),ClaimID))</P></BODY></HTML> Wed, 12 Nov 2014 12:29:55 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-use-field-selection-to-define-set/m-p/818111#M288444 2014-11-12T12:29:55Z