topic Above Function in QlikView https://community.qlik.com/t5/QlikView/Above-Function/m-p/1355799#M828553 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>please check attached images, why February is missing in above statement?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT shiveshsingh 2020-11-25T16:16:04Z Above Function https://community.qlik.com/t5/QlikView/Above-Function/m-p/1355799#M828553 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>please check attached images, why February is missing in above statement?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Above-Function/m-p/1355799#M828553 shiveshsingh 2020-11-25T16:16:04Z Re: Above Function https://community.qlik.com/t5/QlikView/Above-Function/m-p/1355800#M828554 <HTML><HEAD></HEAD><BODY><P>Can you share your complete sum() expression with Above()</P><P></P><P>Are you using like Above(Sum(Sales), 0, RowNo()) ?</P></BODY></HTML> Sun, 25 Jun 2017 17:32:44 GMT https://community.qlik.com/t5/QlikView/Above-Function/m-p/1355800#M828554 vishsaggi 2017-06-25T17:32:44Z Re: Above Function https://community.qlik.com/t5/QlikView/Above-Function/m-p/1355801#M828555 <HTML><HEAD></HEAD><BODY><P><IMG alt="Above function.png" class="jive-image image-1" src="/legacyfs/online/168007_Above function.png" style="height: 281px; width: 620px;" /></P><P>Can you please let us know what's your complete Above() expression?</P></BODY></HTML> Sun, 25 Jun 2017 17:56:34 GMT https://community.qlik.com/t5/QlikView/Above-Function/m-p/1355801#M828555 BalaBhaskar_Qlik 2017-06-25T17:56:34Z Re: Above Function https://community.qlik.com/t5/QlikView/Above-Function/m-p/1355802#M828556 <HTML><HEAD></HEAD><BODY><P>Because, You are calculating with Previous one to previous one. Sum(Sales) - Above(...) will return correct only but not the starting stage or sequance</P></BODY></HTML> Mon, 26 Jun 2017 01:28:33 GMT https://community.qlik.com/t5/QlikView/Above-Function/m-p/1355802#M828556 Anil_Babu_Samineni 2017-06-26T01:28:33Z Re: Above Function https://community.qlik.com/t5/QlikView/Above-Function/m-p/1355803#M828557 <HTML><HEAD></HEAD><BODY><P>Simple answer to your question is that, February doesn't show because the data isn't sorted in the right sort order. If the sort was done correctly, then January would not have shown. Is that something you want or do you even want to see January for 2014 and 2015? (2013 won't show because you don't have 2012 data)...but for 2014, you can try your above function with a total</P><P></P><P><STRONG>Above(TOTAL Sum(....))</STRONG></P></BODY></HTML> Mon, 26 Jun 2017 01:39:34 GMT https://community.qlik.com/t5/QlikView/Above-Function/m-p/1355803#M828557 sunny_talwar 2017-06-26T01:39:34Z