topic Re: Above function generates null in some rows in QlikView https://community.qlik.com/t5/QlikView/Above-function-generates-null-in-some-rows/m-p/942134#M324768 <HTML><HEAD></HEAD><BODY><P>Thanks a Lot for the links especially the missing manual helped a lot to get things clear </P></BODY></HTML> Thu, 05 Nov 2015 09:52:35 GMT fashid 2015-11-05T09:52:35Z Above function generates null in some rows https://community.qlik.com/t5/QlikView/Above-function-generates-null-in-some-rows/m-p/942131#M324765 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I was trying to learn the above function and i created some sample data to play with it.</P><P>I am facing a problem with my expression&nbsp; "<SPAN style="font-size: 10pt; line-height: 1.5em;">=Above(Sum(sales))"&nbsp; which should simply return the sum of sales from the previous row.</SPAN></P><P></P><P>My query is that I do not get values for the month of Jan 2013 and jan 2014.</P><P></P><P>Could you please tell what the issue could be .</P><P>I am attaching the sample app that am working on.</P><P></P><P>Thanks </P><P>Nadeem</P></BODY></HTML> Thu, 05 Nov 2015 07:00:35 GMT https://community.qlik.com/t5/QlikView/Above-function-generates-null-in-some-rows/m-p/942131#M324765 fashid 2015-11-05T07:00:35Z Re: Above function generates null in some rows https://community.qlik.com/t5/QlikView/Above-function-generates-null-in-some-rows/m-p/942132#M324766 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try </P><P></P><P>=Above(TOTAL Sum(Sales))</P><P></P><P>Hope it helps you.</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Thu, 05 Nov 2015 07:21:28 GMT https://community.qlik.com/t5/QlikView/Above-function-generates-null-in-some-rows/m-p/942132#M324766 jagan 2015-11-05T07:21:28Z Re: Above function generates null in some rows https://community.qlik.com/t5/QlikView/Above-function-generates-null-in-some-rows/m-p/942133#M324767 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/docs/DOC-8242">Missing Manual - Above() and Below()</A></P><P><A href="https://community.qlik.com/qlik-blogpost/4522">The Above Function</A></P></BODY></HTML> Thu, 05 Nov 2015 07:23:59 GMT https://community.qlik.com/t5/QlikView/Above-function-generates-null-in-some-rows/m-p/942133#M324767 MK_QSL 2015-11-05T07:23:59Z Re: Above function generates null in some rows https://community.qlik.com/t5/QlikView/Above-function-generates-null-in-some-rows/m-p/942134#M324768 <HTML><HEAD></HEAD><BODY><P>Thanks a Lot for the links especially the missing manual helped a lot to get things clear </P></BODY></HTML> Thu, 05 Nov 2015 09:52:35 GMT https://community.qlik.com/t5/QlikView/Above-function-generates-null-in-some-rows/m-p/942134#M324768 fashid 2015-11-05T09:52:35Z Re: Above function generates null in some rows https://community.qlik.com/t5/QlikView/Above-function-generates-null-in-some-rows/m-p/942135#M324769 <HTML><HEAD></HEAD><BODY><P>Thanks Jagan . </P></BODY></HTML> Thu, 05 Nov 2015 09:56:25 GMT https://community.qlik.com/t5/QlikView/Above-function-generates-null-in-some-rows/m-p/942135#M324769 fashid 2015-11-05T09:56:25Z Re: Above function generates null in some rows https://community.qlik.com/t5/QlikView/Above-function-generates-null-in-some-rows/m-p/942136#M324770 <HTML><HEAD></HEAD><BODY><P>Actually you need to thank to the person who has wrote Missing Manual... </P></BODY></HTML> Thu, 05 Nov 2015 10:41:11 GMT https://community.qlik.com/t5/QlikView/Above-function-generates-null-in-some-rows/m-p/942136#M324770 MK_QSL 2015-11-05T10:41:11Z Re: Above function generates null in some rows https://community.qlik.com/t5/QlikView/Above-function-generates-null-in-some-rows/m-p/942137#M324771 <HTML><HEAD></HEAD><BODY><P>I did it as soon as I read . he has taken lot of effort in writing that <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 05 Nov 2015 10:52:17 GMT https://community.qlik.com/t5/QlikView/Above-function-generates-null-in-some-rows/m-p/942137#M324771 fashid 2015-11-05T10:52:17Z