topic Re: How to modify the 'above' function in the editor? in QlikView https://community.qlik.com/t5/QlikView/How-to-modify-the-above-function-in-the-editor/m-p/1403522#M817179 <HTML><HEAD></HEAD><BODY><P>Thanks Sunny.</P></BODY></HTML> Tue, 29 Aug 2017 17:09:16 GMT 2017-08-29T17:09:16Z How to modify the 'above' function in the editor? https://community.qlik.com/t5/QlikView/How-to-modify-the-above-function-in-the-editor/m-p/1403520#M817177 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>This formula current takes the share percentage delta (difference) from quarter to quarter (Ie, 2017Q2 - 2017Q1):</P><P></P><P>$(vWtdSharePct)-above($(vWtdSharePct))</P><P></P><P></P><P>Can I modify it to instead look at a difference over a year's period?&nbsp; Ie, so that it will instead calculate 2017Q2 - 2016Q2 for all data points?</P><P></P><P>Thank you,</P><P>Jeff</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-modify-the-above-function-in-the-editor/m-p/1403520#M817177 2020-11-25T16:16:04Z Re: How to modify the 'above' function in the editor? https://community.qlik.com/t5/QlikView/How-to-modify-the-above-function-in-the-editor/m-p/1403521#M817178 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>$(vWtdSharePct)-Above($(vWtdSharePct)<SPAN style="color: #ff0000;">, 4</SPAN>)</STRONG></SPAN></P></BODY></HTML> Tue, 29 Aug 2017 17:03:42 GMT https://community.qlik.com/t5/QlikView/How-to-modify-the-above-function-in-the-editor/m-p/1403521#M817178 sunny_talwar 2017-08-29T17:03:42Z Re: How to modify the 'above' function in the editor? https://community.qlik.com/t5/QlikView/How-to-modify-the-above-function-in-the-editor/m-p/1403522#M817179 <HTML><HEAD></HEAD><BODY><P>Thanks Sunny.</P></BODY></HTML> Tue, 29 Aug 2017 17:09:16 GMT https://community.qlik.com/t5/QlikView/How-to-modify-the-above-function-in-the-editor/m-p/1403522#M817179 2017-08-29T17:09:16Z