topic Re: I have to make a straight table with 1 column showing Cumulative Difference. in Visualization and Usability https://community.qlik.com/t5/Visualization-and-Usability/I-have-to-make-a-straight-table-with-1-column-showing-Cumulative/m-p/1241576#M80440 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P><STRONG>If(RowNo(TOTAL) = 1, 0, RangeSum([Qoe Subscriber], -Above(TOTAL [</STRONG><SPAN style="font-size: 13.3333px;"><STRONG>Qoe Subscriber])))</STRONG></SPAN></P></BODY></HTML> Thu, 09 Feb 2017 11:40:40 GMT sunny_talwar 2017-02-09T11:40:40Z I have to make a straight table with 1 column showing Cumulative Difference. https://community.qlik.com/t5/Visualization-and-Usability/I-have-to-make-a-straight-table-with-1-column-showing-Cumulative/m-p/1241575#M80439 <HTML><HEAD></HEAD><BODY><P>In my table, I have week, month, No of QOE Subscribers.</P><P></P><P>I have to create a new column, and place cumulative difference of the QoE Subscribers in that column. Also, the first row should be null (0) and the <SPAN style="font-size: 13.3333px;">cumulative difference</SPAN> should start from the 2nd column.</P><P></P><P>Ex -</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Week</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Month</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Qoe Subscribers</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Cumulative Difference</TH></TR><TR><TD style="padding: 2px;">Week1</TD><TD style="padding: 2px;">Jan</TD><TD style="padding: 2px;">23</TD><TD style="padding: 2px;">0</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">Week1</SPAN></TD><TD style="padding: 2px;">Feb</TD><TD style="padding: 2px;">25</TD><TD style="padding: 2px;">2</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">Week1</SPAN></TD><TD style="padding: 2px;">Mar</TD><TD style="padding: 2px;">22</TD><TD style="padding: 2px;">-3</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">Week1</SPAN></TD><TD style="padding: 2px;">Apr</TD><TD style="padding: 2px;">30</TD><TD style="padding: 2px;">8</TD></TR></TBODY></TABLE><P></P><P>Any help is appreciated. Thanks.</P><P></P><P>Deepali</P></BODY></HTML> Thu, 09 Feb 2017 09:38:17 GMT https://community.qlik.com/t5/Visualization-and-Usability/I-have-to-make-a-straight-table-with-1-column-showing-Cumulative/m-p/1241575#M80439 2017-02-09T09:38:17Z Re: I have to make a straight table with 1 column showing Cumulative Difference. https://community.qlik.com/t5/Visualization-and-Usability/I-have-to-make-a-straight-table-with-1-column-showing-Cumulative/m-p/1241576#M80440 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P><STRONG>If(RowNo(TOTAL) = 1, 0, RangeSum([Qoe Subscriber], -Above(TOTAL [</STRONG><SPAN style="font-size: 13.3333px;"><STRONG>Qoe Subscriber])))</STRONG></SPAN></P></BODY></HTML> Thu, 09 Feb 2017 11:40:40 GMT https://community.qlik.com/t5/Visualization-and-Usability/I-have-to-make-a-straight-table-with-1-column-showing-Cumulative/m-p/1241576#M80440 sunny_talwar 2017-02-09T11:40:40Z Re: I have to make a straight table with 1 column showing Cumulative Difference. https://community.qlik.com/t5/Visualization-and-Usability/I-have-to-make-a-straight-table-with-1-column-showing-Cumulative/m-p/1241577#M80441 <HTML><HEAD></HEAD><BODY><P>This may be help you,</P><P></P><P>If(RowNo(TOTAL) = 1, 0, RangeSum([Qoe Subscribers] - Above(TOTAL [Qoe Subscribers])))</P></BODY></HTML> Thu, 09 Feb 2017 11:51:55 GMT https://community.qlik.com/t5/Visualization-and-Usability/I-have-to-make-a-straight-table-with-1-column-showing-Cumulative/m-p/1241577#M80441 Silambarasan1306 2017-02-09T11:51:55Z