topic Re: Table : Row Specifc Sum in QlikView https://community.qlik.com/t5/QlikView/Table-Row-Specifc-Sum/m-p/777814#M275702 <HTML><HEAD></HEAD><BODY><P>Here it is my example</P></BODY></HTML> Tue, 10 Feb 2015 12:54:48 GMT alexandros17 2015-02-10T12:54:48Z Table : Row Specifc Sum https://community.qlik.com/t5/QlikView/Table-Row-Specifc-Sum/m-p/777812#M275700 <HTML><HEAD></HEAD><BODY><P><BR />Hi,</P><P>I have a scenario where a calculation expression 'Summation'&nbsp; depends on the 'Duration' figure;</P><P>&nbsp;&nbsp; <STRONG>Raw data</STRONG> is something like :</P><P>&nbsp;&nbsp; </P><TABLE border="1" class="jiveBorder" style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; WIDTH: 100%; BORDER-TOP: #000000 1px solid; BORDER-RIGHT: #000000 1px solid;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;"><STRONG>Duration</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;"><STRONG>Summation</STRONG></TH></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">20</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">30</TD></TR><TR><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">10</TD></TR><TR><TD style="padding: 2px;">4</TD><TD style="padding: 2px;">20</TD></TR><TR><TD style="padding: 2px;">5</TD><TD style="padding: 2px;">10</TD></TR></TBODY></TABLE><P></P><P>&nbsp; <STRONG>Requirement :</STRONG></P><TABLE border="1" class="jiveBorder" style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; WIDTH: 100%; BORDER-TOP: #000000 1px solid; BORDER-RIGHT: #000000 1px solid;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;"><STRONG>Duration</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;"><STRONG>Summation</STRONG></TH></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">80</TD></TR><TR><TD style="padding: 2px;">5</TD><TD style="padding: 2px;">10</TD></TR></TBODY></TABLE><P>So that 'Summation' for&nbsp; Duration <SPAN style="text-decoration: underline;">'1'</SPAN> corrsponds to <SPAN style="text-decoration: underline;">sum of 1 to 4 Duration</SPAN> , whereas <SPAN style="text-decoration: underline;">5,10,15</SPAN>,... should get its <SPAN style="text-decoration: underline;">respective</SPAN> Summation Value.</P><P></P><P>I could get thru the 5,10,15,.. Summation by using <SPAN style="text-decoration: underline;">Mod()</SPAN> function.</P><P>Would apprectiate any help on the above !</P><P>Cheers !</P></BODY></HTML> Tue, 10 Feb 2015 12:33:02 GMT https://community.qlik.com/t5/QlikView/Table-Row-Specifc-Sum/m-p/777812#M275700 2015-02-10T12:33:02Z Re: Table : Row Specifc Sum https://community.qlik.com/t5/QlikView/Table-Row-Specifc-Sum/m-p/777813#M275701 <HTML><HEAD></HEAD><BODY><P>See attached qvw.</P></BODY></HTML> Tue, 10 Feb 2015 12:49:55 GMT https://community.qlik.com/t5/QlikView/Table-Row-Specifc-Sum/m-p/777813#M275701 Gysbert_Wassenaar 2015-02-10T12:49:55Z Re: Table : Row Specifc Sum https://community.qlik.com/t5/QlikView/Table-Row-Specifc-Sum/m-p/777814#M275702 <HTML><HEAD></HEAD><BODY><P>Here it is my example</P></BODY></HTML> Tue, 10 Feb 2015 12:54:48 GMT https://community.qlik.com/t5/QlikView/Table-Row-Specifc-Sum/m-p/777814#M275702 alexandros17 2015-02-10T12:54:48Z