topic Re: Above Function in chart in QlikView https://community.qlik.com/t5/QlikView/Above-Function-in-chart/m-p/801357#M282831 <HTML><HEAD></HEAD><BODY><P></P><P>sum</P><P></P><P><SPAN style="font-size: 12pt;">( </SPAN><SPAN style="color: #800000; font-size: 12pt;">Value</SPAN><SPAN style="font-size: 12pt;">) - </SPAN><SPAN style="color: #0000ff; font-size: 12pt;">above</SPAN><SPAN style="font-size: 12pt;">( </SPAN><SPAN style="color: #0000ff; font-size: 12pt;">sum</SPAN><SPAN style="font-size: 12pt;">( </SPAN><SPAN style="color: #800000; font-size: 12pt;">Value</SPAN><SPAN style="font-size: 12pt;"> ))<BR /> <BR /> </SPAN></P><P>worked!</P></BODY></HTML> Wed, 10 Dec 2014 06:23:16 GMT brijesh1991 2014-12-10T06:23:16Z Above Function in chart https://community.qlik.com/t5/QlikView/Above-Function-in-chart/m-p/801356#M282830 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I want to create a column&nbsp; as shown below:</P><P></P><P>I want to do (Current Row -&nbsp; Above Row)</P><P>Example: For Date 3rd: Value is 36.5797364796</P><P>For Date 4th: 65.4757850231-365797364796</P><P>And so on.</P><P>Above function is not working in my straight table expression. Can you flash your help, please?</P><P></P><P></P><TABLE border="0" cellspacing="0" frame="VOID" rules="NONE"><TBODY><TR><TD height="48" width="86"><STRONG style="color: #363636; font-family: Times New Roman;">Date </STRONG></TD><TD width="86"><STRONG style="color: #363636; font-family: Times New Roman;">Value</STRONG></TD><TD width="86"><STRONG style="color: #363636; font-family: Times New Roman;">Want to create this column</STRONG></TD></TR><TR><TD bgcolor="#ffffff" height="18"><SPAN style="color: #363636; font-family: Times New Roman;">11/03/14</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636; font-family: Times New Roman;">36.5797364796</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636; font-family: Times New Roman;">36.5797364796</SPAN></TD></TR><TR><TD bgcolor="#ffffff" height="18"><SPAN style="color: #363636; font-family: Times New Roman;">11/04/14</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636; font-family: Times New Roman;">65.4757850231</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636; font-family: Times New Roman;">28.8960485435</SPAN></TD></TR><TR><TD bgcolor="#ffffff" height="18"><SPAN style="color: #363636; font-family: Times New Roman;">11/05/14</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636; font-family: Times New Roman;">101.4748550767</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636; font-family: Times New Roman;">35.9990700536</SPAN></TD></TR><TR><TD bgcolor="#ffffff" height="18"><SPAN style="color: #363636; font-family: Times New Roman;">11/06/14</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636; font-family: Times New Roman;">122.1616684673</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636; font-family: Times New Roman;">20.6868133906</SPAN></TD></TR><TR><TD bgcolor="#ffffff" height="18"><SPAN style="color: #363636; font-family: Times New Roman;">11/07/14</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636; font-family: Times New Roman;">144.5671988313</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636; font-family: Times New Roman;">22.405530364</SPAN></TD></TR><TR><TD bgcolor="#ffffff" height="18"><SPAN style="color: #363636; font-family: Times New Roman;">11/09/14</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636; font-family: Times New Roman;">153.3039131106</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636; font-family: Times New Roman;">8.7367142793</SPAN></TD></TR><TR><TD bgcolor="#ffffff" height="18"><SPAN style="color: #363636; font-family: Times New Roman;">11/10/14</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636; font-family: Times New Roman;">218.3902162795</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636; font-family: Times New Roman;">65.0863031689</SPAN></TD></TR><TR><TD bgcolor="#ffffff" height="18"><SPAN style="color: #363636; font-family: Times New Roman;">11/11/14</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636; font-family: Times New Roman;">249.7548325125</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636; font-family: Times New Roman;">31.364616233</SPAN></TD></TR></TBODY></TABLE></BODY></HTML> Wed, 10 Dec 2014 06:18:12 GMT https://community.qlik.com/t5/QlikView/Above-Function-in-chart/m-p/801356#M282830 brijesh1991 2014-12-10T06:18:12Z Re: Above Function in chart https://community.qlik.com/t5/QlikView/Above-Function-in-chart/m-p/801357#M282831 <HTML><HEAD></HEAD><BODY><P></P><P>sum</P><P></P><P><SPAN style="font-size: 12pt;">( </SPAN><SPAN style="color: #800000; font-size: 12pt;">Value</SPAN><SPAN style="font-size: 12pt;">) - </SPAN><SPAN style="color: #0000ff; font-size: 12pt;">above</SPAN><SPAN style="font-size: 12pt;">( </SPAN><SPAN style="color: #0000ff; font-size: 12pt;">sum</SPAN><SPAN style="font-size: 12pt;">( </SPAN><SPAN style="color: #800000; font-size: 12pt;">Value</SPAN><SPAN style="font-size: 12pt;"> ))<BR /> <BR /> </SPAN></P><P>worked!</P></BODY></HTML> Wed, 10 Dec 2014 06:23:16 GMT https://community.qlik.com/t5/QlikView/Above-Function-in-chart/m-p/801357#M282831 brijesh1991 2014-12-10T06:23:16Z Re: Above Function in chart https://community.qlik.com/t5/QlikView/Above-Function-in-chart/m-p/801358#M282832 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Write this expression</P><P></P><P>Below(sum(Value)) - sum(Value)</P><P></P><P>Regards</P><P>Anand</P></BODY></HTML> Wed, 10 Dec 2014 06:24:51 GMT https://community.qlik.com/t5/QlikView/Above-Function-in-chart/m-p/801358#M282832 its_anandrjs 2014-12-10T06:24:51Z