topic Re: Aggr in QlikView https://community.qlik.com/t5/QlikView/Aggr/m-p/939035#M526645 <HTML><HEAD></HEAD><BODY><P>What exactly are you trying to exclude? May be something like this:</P><P></P><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Upper(Aggr(Only({&lt;Field1 -= {'ABC', 'DEF'}&gt;} Country), Country))</STRONG></P></BODY></HTML> Wed, 02 Dec 2015 15:46:50 GMT sunny_talwar 2015-12-02T15:46:50Z Aggr https://community.qlik.com/t5/QlikView/Aggr/m-p/939032#M526642 <HTML><HEAD></HEAD><BODY><P>Can you tel me how to include set in this expression <SPAN dir="ltr" style="color: #000000; font-family: 'Segoe UI'; font-size: 10pt; direction: ltr; word-wrap: break-word;"><SPAN style="color: #0000ff; font-size: 10pt;">upper</SPAN><SPAN style="font-size: 10pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 10pt;">aggr</SPAN><SPAN style="font-size: 10pt;">(</SPAN><SPAN style="color: #800000; font-size: 10pt;">Country</SPAN><SPAN style="font-size: 10pt;">,</SPAN><SPAN style="color: #800000; font-size: 10pt;">Country</SPAN><SPAN style="font-size: 10pt;">)</SPAN><SPAN style="font-size: 10pt;">) , i want to exclude three other field selection in this list box using set analysis.</SPAN></SPAN></P></BODY></HTML> Wed, 02 Dec 2015 15:33:12 GMT https://community.qlik.com/t5/QlikView/Aggr/m-p/939032#M526642 2015-12-02T15:33:12Z Re: Aggr https://community.qlik.com/t5/QlikView/Aggr/m-p/939033#M526643 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><STRONG>Upper(Aggr(Only({&lt;Set Analysis Here&gt;} Country), Country))</STRONG></P></BODY></HTML> Wed, 02 Dec 2015 15:35:39 GMT https://community.qlik.com/t5/QlikView/Aggr/m-p/939033#M526643 sunny_talwar 2015-12-02T15:35:39Z Re: Aggr https://community.qlik.com/t5/QlikView/Aggr/m-p/939034#M526644 <HTML><HEAD></HEAD><BODY><P>how to excludes field here?</P></BODY></HTML> Wed, 02 Dec 2015 15:44:17 GMT https://community.qlik.com/t5/QlikView/Aggr/m-p/939034#M526644 2015-12-02T15:44:17Z Re: Aggr https://community.qlik.com/t5/QlikView/Aggr/m-p/939035#M526645 <HTML><HEAD></HEAD><BODY><P>What exactly are you trying to exclude? May be something like this:</P><P></P><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Upper(Aggr(Only({&lt;Field1 -= {'ABC', 'DEF'}&gt;} Country), Country))</STRONG></P></BODY></HTML> Wed, 02 Dec 2015 15:46:50 GMT https://community.qlik.com/t5/QlikView/Aggr/m-p/939035#M526645 sunny_talwar 2015-12-02T15:46:50Z Re: Aggr https://community.qlik.com/t5/QlikView/Aggr/m-p/939036#M526646 <HTML><HEAD></HEAD><BODY><P>=Aggr(Only({&lt;<STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Country</STRONG> -= {'A','B'}&gt;}<STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Country</STRONG>),<STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Country</STRONG>)</P></BODY></HTML> Wed, 02 Dec 2015 15:57:44 GMT https://community.qlik.com/t5/QlikView/Aggr/m-p/939036#M526646 MK_QSL 2015-12-02T15:57:44Z Re: Aggr https://community.qlik.com/t5/QlikView/Aggr/m-p/939037#M526647 <HTML><HEAD></HEAD><BODY><P>upper(aggr(Ony({&lt;Field1=,Field2=,Field3=&gt;}Country),Country))</P><P></P><P>This will exclude the selection of Field1, Field2 &amp; Field3</P></BODY></HTML> Wed, 02 Dec 2015 16:18:18 GMT https://community.qlik.com/t5/QlikView/Aggr/m-p/939037#M526647 Kushal_Chawda 2015-12-02T16:18:18Z