topic Re: AGGR with dimensions in QlikView https://community.qlik.com/t5/QlikView/AGGR-with-dimensions/m-p/1248229#M856111 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><STRONG>Sum(TOTAL &lt;year&gt; sales)</STRONG></P><P></P><P>or</P><P></P><P><STRONG>Aggr(NODISTINCT Sum(sales), year)</STRONG></P></BODY></HTML> Fri, 10 Feb 2017 08:00:13 GMT sunny_talwar 2017-02-10T08:00:13Z AGGR with dimensions https://community.qlik.com/t5/QlikView/AGGR-with-dimensions/m-p/1248228#M856108 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>Here is my situation:</P><P></P><P>Pivot table:</P><P>Dimension 1: customer_num</P><P>Dimension 2: year</P><P>Expression 1: Individual sales</P><P>Expression 2: total sales for that particular year</P><P></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 384px;"><TBODY><TR><TD height="20" style="border: 0.5pt solid windowtext; border-image: none;" width="108"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> </SPAN></TD><TD colspan="2" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black;" width="138"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">2015</SPAN></TD><TD colspan="2" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black;" width="138"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">2016</SPAN></TD></TR><TR><TD height="40" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext;" width="108"><P><SPAN style="color: #000000; font-size: 12pt; font-family: Calibri;">year</SPAN></P><P><SPAN style="color: #000000; font-size: 12pt; font-family: Calibri;">customer_num</SPAN></P></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;" width="69"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">individual yr sales</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;" width="69"><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">total y</SPAN><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">r sales</SPAN></P></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;" width="69"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">individual yr sales</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;" width="69"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">total yr sales</SPAN></TD></TR><TR><TD height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">1</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">20</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">100</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">60</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">150</SPAN></TD></TR><TR><TD height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">2</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">40</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">100</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">30</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">150</SPAN></TD></TR><TR><TD height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">3</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">10</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">100</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">50</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">150</SPAN></TD></TR><TR><TD height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">4</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">20</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">100</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">10</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">150</SPAN></TD></TR></TBODY></TABLE><P></P><P></P><P>The column I'm having trouble populating is the "total yr sales". Currently I have:</P><P><SPAN style="font-size: 10pt;"><SPAN style="color: #0000ff;">Aggr</SPAN>(<SPAN style="color: #0000ff;">sum</SPAN>(<SPAN style="color: #800000;">sales</SPAN>),<SPAN style="color: #800000;">year</SPAN></SPAN><SPAN style="font-size: 10pt;">) </SPAN></P><P></P><P>However, this produces an odd outcome with only 1 row per column populated, so I'm unable to utilize this value for other expressions.</P><TABLE border="0" cellpadding="0" cellspacing="0"><TBODY><TR><TD height="20" style="border: 0.5pt solid windowtext; border-image: none;" width="108"></TD><TD colspan="2" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black;" width="138"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">2015</SPAN></TD><TD colspan="2" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black;" width="138"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">2016</SPAN></TD></TR><TR><TD height="40" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext;" width="108"><P><SPAN style="color: #000000; font-size: 12pt; font-family: Calibri;">year</SPAN></P><P><SPAN style="color: #000000; font-size: 12pt; font-family: Calibri;">customer_num</SPAN></P></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;" width="69"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">individual yr sales</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;" width="69"><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">total y</SPAN><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">r sales</SPAN></P></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;" width="69"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">individual yr sales</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;" width="69"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">total yr sales</SPAN></TD></TR><TR><TD height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">1</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">20</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">-</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">60</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">-</SPAN></TD></TR><TR><TD height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">2</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">40</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">-</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">30</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">150</SPAN></TD></TR><TR><TD height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">3</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">10</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">-</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">50</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">-</SPAN></TD></TR><TR><TD height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">4</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">20</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">100</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">10</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">-</SPAN></TD></TR></TBODY></TABLE><P></P><P></P><P></P><P>Any help is much appreciated!</P><P></P><P>Thanks</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/AGGR-with-dimensions/m-p/1248228#M856108 ahudache 2020-11-25T16:16:04Z Re: AGGR with dimensions https://community.qlik.com/t5/QlikView/AGGR-with-dimensions/m-p/1248229#M856111 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><STRONG>Sum(TOTAL &lt;year&gt; sales)</STRONG></P><P></P><P>or</P><P></P><P><STRONG>Aggr(NODISTINCT Sum(sales), year)</STRONG></P></BODY></HTML> Fri, 10 Feb 2017 08:00:13 GMT https://community.qlik.com/t5/QlikView/AGGR-with-dimensions/m-p/1248229#M856111 sunny_talwar 2017-02-10T08:00:13Z Re: AGGR with dimensions https://community.qlik.com/t5/QlikView/AGGR-with-dimensions/m-p/1248230#M856113 <HTML><HEAD></HEAD><BODY><P>The bottom one worked! Thanks!</P></BODY></HTML> Fri, 10 Feb 2017 13:04:21 GMT https://community.qlik.com/t5/QlikView/AGGR-with-dimensions/m-p/1248230#M856113 ahudache 2017-02-10T13:04:21Z