topic table operation in qlik in QlikView https://community.qlik.com/t5/QlikView/table-operation-in-qlik/m-p/78111#M781541 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have this table:</P><TABLE bgcolor="#ffffff" border="1" cellpadding="2" cellspacing="0" style="font-size: 9pt;"><TBODY><TR bgcolor="#f5f5f5"><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>date</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap">X</TH></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">12/2016</SPAN></TD><TD bgcolor="#ffffff">100</TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01/2017</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">200</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">02/2017</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">300</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">03/2017</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">400</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">04/2017</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">500</SPAN></TD></TR></TBODY></TABLE><P></P><P>And the objective is : </P><P></P><TABLE bgcolor="#ffffff" border="1" cellpadding="2" cellspacing="0" style="font-size: 9pt;"><TBODY><TR bgcolor="#f5f5f5"><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>date</STRONG></SPAN></TH><TH nowrap="nowrap">X</TH></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">12/2016</SPAN></TD><TD bgcolor="#ffffff">100</TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01/2017</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">100</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">02/2017</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">200</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">03/2017</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">300</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">04/2017</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">400</SPAN></TD></TR></TBODY></TABLE><P>exemple: X= 200 - 100 ( 12/2016)&nbsp; = 100</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; X= 300 - 1<SPAN style="font-size: 13.3333px;">00 ( 12/2016)&nbsp; = 200</SPAN></P><P><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; X= 400 - 1</SPAN><SPAN style="font-size: 13.3333px;">00 ( 12/2016)&nbsp; = 300</SPAN></P><P>Any suggestions please?</P><P></P><P>Regards,</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT aminehaddar 2020-11-25T16:16:04Z table operation in qlik https://community.qlik.com/t5/QlikView/table-operation-in-qlik/m-p/78111#M781541 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have this table:</P><TABLE bgcolor="#ffffff" border="1" cellpadding="2" cellspacing="0" style="font-size: 9pt;"><TBODY><TR bgcolor="#f5f5f5"><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>date</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap">X</TH></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">12/2016</SPAN></TD><TD bgcolor="#ffffff">100</TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01/2017</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">200</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">02/2017</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">300</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">03/2017</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">400</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">04/2017</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">500</SPAN></TD></TR></TBODY></TABLE><P></P><P>And the objective is : </P><P></P><TABLE bgcolor="#ffffff" border="1" cellpadding="2" cellspacing="0" style="font-size: 9pt;"><TBODY><TR bgcolor="#f5f5f5"><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>date</STRONG></SPAN></TH><TH nowrap="nowrap">X</TH></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">12/2016</SPAN></TD><TD bgcolor="#ffffff">100</TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01/2017</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">100</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">02/2017</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">200</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">03/2017</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">300</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">04/2017</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">400</SPAN></TD></TR></TBODY></TABLE><P>exemple: X= 200 - 100 ( 12/2016)&nbsp; = 100</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; X= 300 - 1<SPAN style="font-size: 13.3333px;">00 ( 12/2016)&nbsp; = 200</SPAN></P><P><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; X= 400 - 1</SPAN><SPAN style="font-size: 13.3333px;">00 ( 12/2016)&nbsp; = 300</SPAN></P><P>Any suggestions please?</P><P></P><P>Regards,</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/table-operation-in-qlik/m-p/78111#M781541 aminehaddar 2020-11-25T16:16:04Z Re: table operation in qlik https://community.qlik.com/t5/QlikView/table-operation-in-qlik/m-p/78112#M781542 <HTML><HEAD></HEAD><BODY><P>Create a Straight Table</P><P>Dimension</P><P>date</P><P></P><P>expression</P><P>SUM(X)</P><P>IF(RowNo()=1,SUM(X),SUM(X)-top(SUM(X)))</P><P></P><P>make sure that you sort your table by date</P></BODY></HTML> Fri, 23 Mar 2018 11:23:23 GMT https://community.qlik.com/t5/QlikView/table-operation-in-qlik/m-p/78112#M781542 MK_QSL 2018-03-23T11:23:23Z