topic Set Analyis: Complete set restricting 1 field on Current Selection in QlikView https://community.qlik.com/t5/QlikView/Set-Analyis-Complete-set-restricting-1-field-on-Current/m-p/161941#M35646 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Try:</P><P>SUM( {1&lt;month = {$(=Concat(month,','))}&gt;} Sales)</P><P></P><P>Stephen</P></BODY></HTML> Thu, 20 Aug 2009 16:57:37 GMT stephencredmond 2009-08-20T16:57:37Z Set Analyis: Complete set restricting 1 field on Current Selection https://community.qlik.com/t5/QlikView/Set-Analyis-Complete-set-restricting-1-field-on-Current/m-p/161940#M35645 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I'm trying to figure out if it is possible to create a measure for the total sales in the selected month, disregarding all other selection.</P><P>I have tried te following: SUM( {1&lt;month = {$}&gt;} Sales)</P><P>But this doesn't work. Any ideas?</P><P></P><P>Kind regards,</P><P><BR />Daniel</P></BODY></HTML> Thu, 20 Aug 2009 16:42:54 GMT https://community.qlik.com/t5/QlikView/Set-Analyis-Complete-set-restricting-1-field-on-Current/m-p/161940#M35645 2009-08-20T16:42:54Z Set Analyis: Complete set restricting 1 field on Current Selection https://community.qlik.com/t5/QlikView/Set-Analyis-Complete-set-restricting-1-field-on-Current/m-p/161941#M35646 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Try:</P><P>SUM( {1&lt;month = {$(=Concat(month,','))}&gt;} Sales)</P><P></P><P>Stephen</P></BODY></HTML> Thu, 20 Aug 2009 16:57:37 GMT https://community.qlik.com/t5/QlikView/Set-Analyis-Complete-set-restricting-1-field-on-Current/m-p/161941#M35646 stephencredmond 2009-08-20T16:57:37Z Set Analyis: Complete set restricting 1 field on Current Selection https://community.qlik.com/t5/QlikView/Set-Analyis-Complete-set-restricting-1-field-on-Current/m-p/161942#M35647 <HTML><HEAD></HEAD><BODY><P>Thanks!</P></BODY></HTML> Thu, 20 Aug 2009 18:28:19 GMT https://community.qlik.com/t5/QlikView/Set-Analyis-Complete-set-restricting-1-field-on-Current/m-p/161942#M35647 2009-08-20T18:28:19Z