topic What is above function and where it is used? in QlikView

topic What is above function and where it is used? in QlikView https://community.qlik.com/t5/QlikView/What-is-above-function-and-where-it-is-used/m-p/403298#M150033 <HTML><HEAD></HEAD><BODY><P>Help me......</P></BODY></HTML> Mon, 04 Mar 2013 11:44:07 GMT 2013-03-04T11:44:07Z What is above function and where it is used? https://community.qlik.com/t5/QlikView/What-is-above-function-and-where-it-is-used/m-p/403298#M150033 <HTML><HEAD></HEAD><BODY><P>Help me......</P></BODY></HTML> Mon, 04 Mar 2013 11:44:07 GMT https://community.qlik.com/t5/QlikView/What-is-above-function-and-where-it-is-used/m-p/403298#M150033 2013-03-04T11:44:07Z Re: What is above function and where it is used? https://community.qlik.com/t5/QlikView/What-is-above-function-and-where-it-is-used/m-p/403299#M150034 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>above fuction is useful when you want to take the value of above row of that particular column.</P><P></P><P>eg.</P><P style="margin-bottom: 0.0001pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman','serif'; color: blue;">if</SPAN><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman','serif'; color: black;">(</SPAN><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman','serif'; color: blue;">RowNo</SPAN><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman','serif'; color: black;">(</SPAN><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman','serif'; color: blue;">TOTAL</SPAN><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman','serif'; color: black;"> )=1,</SPAN><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman','serif'; color: blue;">null</SPAN><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman','serif'; color: black;">(), Interval(</SPAN><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman','serif'; color: blue;">Timestamp</SPAN><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman','serif'; color: black;"> (</SPAN><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman','serif'; color: blue;">Above</SPAN><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman','serif'; color: black;"> (</SPAN><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman','serif'; color: blue;">Total</SPAN><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman','serif'; color: black;">  TDATE) - ( TDATE) ),'D hh:mm') )</SPAN></P><P></P><P>Regards,</P><P>Nirav Bhimani</P></BODY></HTML> Mon, 04 Mar 2013 12:02:28 GMT https://community.qlik.com/t5/QlikView/What-is-above-function-and-where-it-is-used/m-p/403299#M150034 nirav_bhimani 2013-03-04T12:02:28Z