topic Re: Aggrupate Sum for multiple Rows in QlikView https://community.qlik.com/t5/QlikView/Aggrupate-Sum-for-multiple-Rows/m-p/30111#M768292 <HTML><HEAD></HEAD><BODY><P>It would use <STRONG>TOTAL &lt;Date, Type&gt; </STRONG>in the expression to get this to work</P></BODY></HTML> Thu, 14 Jun 2018 17:43:46 GMT sunny_talwar 2018-06-14T17:43:46Z Aggrupate Sum for multiple Rows https://community.qlik.com/t5/QlikView/Aggrupate-Sum-for-multiple-Rows/m-p/30109#M768290 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have the following table:</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;NaN&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}" style="width: 289px;"><TBODY><TR><TH style="color: #ffffff; background-color: #6690bc; text-align: center; padding: 2px;">Date</TH><TH style="color: #ffffff; background-color: #6690bc; text-align: center; padding: 2px;">Type</TH><TH style="color: #ffffff; background-color: #6690bc; text-align: center; padding: 2px;">Format</TH><TH style="color: #ffffff; background-color: #6690bc; text-align: center; padding: 2px;">Expression</TH></TR><TR><TD class="xl64" height="20" style="border-top: none;" width="59">28/5/2018</TD><TD class="xl65" style="border-top: none; border-left: none;" width="113">Type 1</TD><TD class="xl65" style="border-top: none; border-left: none;" width="57">North</TD><TD class="xl66" style="border-top: none; border-left: none;" width="60">0,02%</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;" width="59">28/5/2018</TD><TD class="xl65" style="border-top: none; border-left: none;" width="113">Type 1</TD><TD class="xl65" style="border-top: none; border-left: none;" width="57">South</TD><TD class="xl66" style="border-top: none; border-left: none;" width="60">0,88%</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;" width="59">28/5/2018</TD><TD class="xl65" style="border-top: none; border-left: none;" width="113">Type 2</TD><TD class="xl65" style="border-top: none; border-left: none;" width="57">West</TD><TD class="xl66" style="border-top: none; border-left: none;" width="60">0,12%</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;" width="59">28/5/2018</TD><TD class="xl65" style="border-top: none; border-left: none;" width="113">Type 2</TD><TD class="xl65" style="border-top: none; border-left: none;" width="57">East</TD><TD class="xl66" style="border-top: none; border-left: none;" width="60">3,45%</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;" width="59">28/5/2018</TD><TD class="xl65" style="border-top: none; border-left: none;" width="113">Type 3</TD><TD class="xl65" style="border-top: none; border-left: none;" width="57">East</TD><TD class="xl66" style="border-top: none; border-left: none;" width="60">1,89%</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;" width="59">28/5/2018</TD><TD class="xl65" style="border-top: none; border-left: none;" width="113">Type 4</TD><TD class="xl65" style="border-top: none; border-left: none;" width="57">West</TD><TD class="xl66" style="border-top: none; border-left: none;" width="60">0,02%</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;" width="59">28/5/2018</TD><TD class="xl65" style="border-top: none; border-left: none;" width="113">Type 4</TD><TD class="xl65" style="border-top: none; border-left: none;" width="57">Noth</TD><TD class="xl66" style="border-top: none; border-left: none;" width="60">1,36%</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;" width="59">28/5/2018</TD><TD class="xl65" style="border-top: none; border-left: none;" width="113">Type 5</TD><TD class="xl65" style="border-top: none; border-left: none;" width="57">South</TD><TD class="xl66" style="border-top: none; border-left: none;" width="60">0,25%</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;" width="59">28/5/2018</TD><TD class="xl65" style="border-top: none; border-left: none;" width="113">Type 6</TD><TD class="xl65" style="border-top: none; border-left: none;" width="57">East</TD><TD class="xl66" style="border-top: none; border-left: none;" width="60">1,06%</TD></TR></TBODY></TABLE><P></P><P>What I need is to show the <STRONG>sum</STRONG> for each <STRONG>Type</STRONG> like this as a expression:</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;NaN&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}" style="width: 320px;"><TBODY><TR><TH style="color: #ffffff; background-color: #6690bc; text-align: center; padding: 2px;">Date</TH><TH style="color: #ffffff; background-color: #6690bc; text-align: center; padding: 2px;">Type</TH><TH style="color: #ffffff; background-color: #6690bc; text-align: center; padding: 2px;">Format</TH><TH style="color: #ffffff; background-color: #6690bc; text-align: center; padding: 2px;">Expression</TH></TR><TR><TD class="xl66" height="20" style="border-top: none;" width="80">28/5/2018</TD><TD class="xl67" style="border-top: none; border-left: none;" width="80">Type 1</TD><TD class="xl67" style="border-top: none; border-left: none;" width="80">North</TD><TD class="xl68" style="border-top: none; border-left: none;" width="80">0,90%</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;" width="80">28/5/2018</TD><TD class="xl67" style="border-top: none; border-left: none;" width="80">Type 1</TD><TD class="xl67" style="border-top: none; border-left: none;" width="80">South</TD><TD class="xl68" style="border-top: none; border-left: none;" width="80">0,90%</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;" width="80">28/5/2018</TD><TD class="xl67" style="border-top: none; border-left: none;" width="80">Type 2</TD><TD class="xl67" style="border-top: none; border-left: none;" width="80">West</TD><TD class="xl68" style="border-top: none; border-left: none;" width="80">3,57%</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;" width="80">28/5/2018</TD><TD class="xl67" style="border-top: none; border-left: none;" width="80">Type 2</TD><TD class="xl67" style="border-top: none; border-left: none;" width="80">East</TD><TD class="xl68" style="border-top: none; border-left: none;" width="80">3,57%</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;" width="80">28/5/2018</TD><TD class="xl67" style="border-top: none; border-left: none;" width="80">Type 3</TD><TD class="xl67" style="border-top: none; border-left: none;" width="80">East</TD><TD class="xl68" style="border-top: none; border-left: none;" width="80">1,89%</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;" width="80">28/5/2018</TD><TD class="xl67" style="border-top: none; border-left: none;" width="80">Type 4</TD><TD class="xl67" style="border-top: none; border-left: none;" width="80">West</TD><TD class="xl68" style="border-top: none; border-left: none;" width="80">1,38%</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;" width="80">28/5/2018</TD><TD class="xl67" style="border-top: none; border-left: none;" width="80">Type 4</TD><TD class="xl67" style="border-top: none; border-left: none;" width="80">Noth</TD><TD class="xl68" style="border-top: none; border-left: none;" width="80">1,38%</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;" width="80">28/5/2018</TD><TD class="xl67" style="border-top: none; border-left: none;" width="80">Type 5</TD><TD class="xl67" style="border-top: none; border-left: none;" width="80">South</TD><TD class="xl68" style="border-top: none; border-left: none;" width="80">0,25%</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;" width="80">28/5/2018</TD><TD class="xl67" style="border-top: none; border-left: none;" width="80">Type 6</TD><TD class="xl67" style="border-top: none; border-left: none;" width="80">East</TD><TD class="xl68" style="border-top: none; border-left: none;" width="80">1,06%</TD></TR></TBODY></TABLE><P></P><P>Is there any way to do that?</P><P></P><P>Thank you!!!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Aggrupate-Sum-for-multiple-Rows/m-p/30109#M768290 microwin88x 2020-11-25T16:16:04Z Re: Aggrupate Sum for multiple Rows https://community.qlik.com/t5/QlikView/Aggrupate-Sum-for-multiple-Rows/m-p/30110#M768291 <HTML><HEAD></HEAD><BODY><P>What is the expression you are using?</P></BODY></HTML> Thu, 14 Jun 2018 17:43:10 GMT https://community.qlik.com/t5/QlikView/Aggrupate-Sum-for-multiple-Rows/m-p/30110#M768291 sunny_talwar 2018-06-14T17:43:10Z Re: Aggrupate Sum for multiple Rows https://community.qlik.com/t5/QlikView/Aggrupate-Sum-for-multiple-Rows/m-p/30111#M768292 <HTML><HEAD></HEAD><BODY><P>It would use <STRONG>TOTAL &lt;Date, Type&gt; </STRONG>in the expression to get this to work</P></BODY></HTML> Thu, 14 Jun 2018 17:43:46 GMT https://community.qlik.com/t5/QlikView/Aggrupate-Sum-for-multiple-Rows/m-p/30111#M768292 sunny_talwar 2018-06-14T17:43:46Z