topic Re: Ignoring dimension with set clause in QlikView https://community.qlik.com/t5/QlikView/Ignoring-dimension-with-set-clause/m-p/454654#M486777 <HTML><HEAD></HEAD><BODY><P>You can use the TOTAL keyword as follows:</P><P></P><P> sum(TOTAL &lt;Product&gt; Sales)</P><P></P><P>Jonathan</P></BODY></HTML> Wed, 20 Feb 2013 12:38:18 GMT Anonymous 2013-02-20T12:38:18Z Ignoring dimension with set clause https://community.qlik.com/t5/QlikView/Ignoring-dimension-with-set-clause/m-p/454653#M486776 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I'm trying to create a table that looks something like this</P><P><IMG __jive_id="33712" class="jive-image-thumbnail jive-image" onclick="" alt="table-example.jpg" src="https://community.qlik.com/legacyfs/online/33712_table-example.jpg" width="450" /></P><P></P><P>I'm having trouble on creating the "Year total" expression. This should be the sum of "Sales" with only "Product" as filtering variable. When I try to do this with set clause it also uses "Quarter", giving the sum for the "Quarter", not the whole dataset. Here's my set clause</P><P></P><P>= Sum({$&lt;Year={Year(Quarter)},Quarter=&gt;})</P><P></P><P>Any help on how to achieve something like this?</P></BODY></HTML> Wed, 20 Feb 2013 12:32:28 GMT https://community.qlik.com/t5/QlikView/Ignoring-dimension-with-set-clause/m-p/454653#M486776 2013-02-20T12:32:28Z Re: Ignoring dimension with set clause https://community.qlik.com/t5/QlikView/Ignoring-dimension-with-set-clause/m-p/454654#M486777 <HTML><HEAD></HEAD><BODY><P>You can use the TOTAL keyword as follows:</P><P></P><P> sum(TOTAL &lt;Product&gt; Sales)</P><P></P><P>Jonathan</P></BODY></HTML> Wed, 20 Feb 2013 12:38:18 GMT https://community.qlik.com/t5/QlikView/Ignoring-dimension-with-set-clause/m-p/454654#M486777 Anonymous 2013-02-20T12:38:18Z