topic Set Analysis Not Working in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-Not-Working/m-p/1253810#M872257 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I'm trying to use set analysis to ignore&nbsp; the "GrupoCalibre" dimension, but it is not working. </P><P>I'm using the following expression: </P><P></P><P>=Sum({$&lt;GrupoCalibre=&gt;} KilosPronCalib)/1000</P><P></P><P>What is wrong with this?</P><P></P><P>Thanks!</P><P></P><P><IMG alt="qlik1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/143951_qlik1.png" style="height: auto;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT cristian_av 2020-11-25T16:16:04Z Set Analysis Not Working https://community.qlik.com/t5/QlikView/Set-Analysis-Not-Working/m-p/1253810#M872257 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I'm trying to use set analysis to ignore&nbsp; the "GrupoCalibre" dimension, but it is not working. </P><P>I'm using the following expression: </P><P></P><P>=Sum({$&lt;GrupoCalibre=&gt;} KilosPronCalib)/1000</P><P></P><P>What is wrong with this?</P><P></P><P>Thanks!</P><P></P><P><IMG alt="qlik1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/143951_qlik1.png" style="height: auto;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Not-Working/m-p/1253810#M872257 cristian_av 2020-11-25T16:16:04Z Re: Set Analysis Not Working https://community.qlik.com/t5/QlikView/Set-Analysis-Not-Working/m-p/1253811#M872258 <HTML><HEAD></HEAD><BODY><P>To ignore dimensions, use the TOTAL qualifier:</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">=Sum( TOTAL&lt;Especie,Variedad&gt; KilosPronCalib)/1000</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><A href="https://community.qlik.com/qlik-blogpost/3285">The Aggregation Scope</A></SPAN></P></BODY></HTML> Tue, 15 Nov 2016 18:06:55 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Not-Working/m-p/1253811#M872258 swuehl 2016-11-15T18:06:55Z