topic Re: how to use next to function and previous function? in QlikView https://community.qlik.com/t5/QlikView/how-to-use-next-to-function-and-previous-function/m-p/589281#M681077 <HTML><HEAD></HEAD><BODY><P>thanks alessandro </P></BODY></HTML> Thu, 17 Apr 2014 10:02:25 GMT 2014-04-17T10:02:25Z how to use next to function and previous function? https://community.qlik.com/t5/QlikView/how-to-use-next-to-function-and-previous-function/m-p/589278#M681074 <HTML><HEAD></HEAD><BODY><P>hi guys ,</P><P>i wrote function like this sum({$1}sales) ,this function display all year sales but actually this function display previous year sales. i do not know how&nbsp; write previous year sales function.please tell me out&nbsp; how to write function.</P><P>Regards:</P><P>madhu</P></BODY></HTML> Thu, 17 Apr 2014 08:33:20 GMT https://community.qlik.com/t5/QlikView/how-to-use-next-to-function-and-previous-function/m-p/589278#M681074 2014-04-17T08:33:20Z Re: how to use next to function and previous function? https://community.qlik.com/t5/QlikView/how-to-use-next-to-function-and-previous-function/m-p/589279#M681075 <HTML><HEAD></HEAD><BODY><P>sum({$ &lt;year={'&lt;$(=year(today()))'}&gt;} sales)</P></BODY></HTML> Thu, 17 Apr 2014 08:36:08 GMT https://community.qlik.com/t5/QlikView/how-to-use-next-to-function-and-previous-function/m-p/589279#M681075 alexandros17 2014-04-17T08:36:08Z Re: how to use next to function and previous function? https://community.qlik.com/t5/QlikView/how-to-use-next-to-function-and-previous-function/m-p/589280#M681076 <HTML><HEAD></HEAD><BODY><P>SUM({$&lt;Year = {'$(=Max(Year)-1)'}&gt;}Sales)</P></BODY></HTML> Thu, 17 Apr 2014 08:36:38 GMT https://community.qlik.com/t5/QlikView/how-to-use-next-to-function-and-previous-function/m-p/589280#M681076 MK_QSL 2014-04-17T08:36:38Z Re: how to use next to function and previous function? https://community.qlik.com/t5/QlikView/how-to-use-next-to-function-and-previous-function/m-p/589281#M681077 <HTML><HEAD></HEAD><BODY><P>thanks alessandro </P></BODY></HTML> Thu, 17 Apr 2014 10:02:25 GMT https://community.qlik.com/t5/QlikView/how-to-use-next-to-function-and-previous-function/m-p/589281#M681077 2014-04-17T10:02:25Z Re: how to use next to function and previous function? https://community.qlik.com/t5/QlikView/how-to-use-next-to-function-and-previous-function/m-p/589282#M681078 <HTML><HEAD></HEAD><BODY><P>Thanks manish</P></BODY></HTML> Thu, 17 Apr 2014 10:02:47 GMT https://community.qlik.com/t5/QlikView/how-to-use-next-to-function-and-previous-function/m-p/589282#M681078 2014-04-17T10:02:47Z Re: how to use next to function and previous function? https://community.qlik.com/t5/QlikView/how-to-use-next-to-function-and-previous-function/m-p/589283#M681079 <HTML><HEAD></HEAD><BODY><P>If you have got your answer, please close the thread by selection appropriate answer.</P></BODY></HTML> Thu, 17 Apr 2014 10:06:20 GMT https://community.qlik.com/t5/QlikView/how-to-use-next-to-function-and-previous-function/m-p/589283#M681079 MK_QSL 2014-04-17T10:06:20Z Re: how to use next to function and previous function? https://community.qlik.com/t5/QlikView/how-to-use-next-to-function-and-previous-function/m-p/589284#M681080 <HTML><HEAD></HEAD><BODY><P>how to write forward function?</P></BODY></HTML> Thu, 17 Apr 2014 10:21:23 GMT https://community.qlik.com/t5/QlikView/how-to-use-next-to-function-and-previous-function/m-p/589284#M681080 2014-04-17T10:21:23Z Re: how to use next to function and previous function? https://community.qlik.com/t5/QlikView/how-to-use-next-to-function-and-previous-function/m-p/589285#M681081 <HTML><HEAD></HEAD><BODY><P>how to write forward function</P></BODY></HTML> Thu, 17 Apr 2014 10:22:30 GMT https://community.qlik.com/t5/QlikView/how-to-use-next-to-function-and-previous-function/m-p/589285#M681081 2014-04-17T10:22:30Z Re: how to use next to function and previous function? https://community.qlik.com/t5/QlikView/how-to-use-next-to-function-and-previous-function/m-p/589286#M681082 <HTML><HEAD></HEAD><BODY><P>There is no Forward Function...</P></BODY></HTML> Thu, 17 Apr 2014 10:22:39 GMT https://community.qlik.com/t5/QlikView/how-to-use-next-to-function-and-previous-function/m-p/589286#M681082 MK_QSL 2014-04-17T10:22:39Z Re: how to use next to function and previous function? https://community.qlik.com/t5/QlikView/how-to-use-next-to-function-and-previous-function/m-p/589287#M681083 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">sum({$ &lt;year={'&lt;$(=year(today())+1)'}&gt;} sales)</SPAN></P></BODY></HTML> Fri, 18 Apr 2014 06:09:41 GMT https://community.qlik.com/t5/QlikView/how-to-use-next-to-function-and-previous-function/m-p/589287#M681083 anbu1984 2014-04-18T06:09:41Z