topic Re: Formula in QlikView https://community.qlik.com/t5/QlikView/Formula/m-p/97541#M509736 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE><TABLE border="1"><TBODY><TR><TD> <P>The solution is to order the table using ORDER BY DATE at the end?</P> </TD></TR></TBODY></TABLE></BLOCKQUOTE><P>Yup</P></BODY></HTML> Tue, 17 Jul 2018 15:44:51 GMT sunny_talwar 2018-07-17T15:44:51Z Formula https://community.qlik.com/t5/QlikView/Formula/m-p/97540#M509735 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>i'm using this formula <STRONG>Rangesum(HistoricalWIUSD-Previous(HistoricalWIUSD)) as DailyDelta </STRONG>to calculate the Daily Delta.</P><P></P><P>The thing is that i would like to have for each day the difference between current day and the previous day.</P><P></P><P>The solution is to order the table using ORDER BY DATE at the end?<BR />Thank you</P><P></P><P></P><P></P><P></P><P><IMG alt="daily delta.png" class="jive-image image-1" src="/legacyfs/online/208115_daily delta.png" style="height: auto;" /></P></BODY></HTML> Tue, 17 Jul 2018 15:39:30 GMT https://community.qlik.com/t5/QlikView/Formula/m-p/97540#M509735 qlikviewaf 2018-07-17T15:39:30Z Re: Formula https://community.qlik.com/t5/QlikView/Formula/m-p/97541#M509736 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE><TABLE border="1"><TBODY><TR><TD> <P>The solution is to order the table using ORDER BY DATE at the end?</P> </TD></TR></TBODY></TABLE></BLOCKQUOTE><P>Yup</P></BODY></HTML> Tue, 17 Jul 2018 15:44:51 GMT https://community.qlik.com/t5/QlikView/Formula/m-p/97541#M509736 sunny_talwar 2018-07-17T15:44:51Z Re: Formula https://community.qlik.com/t5/QlikView/Formula/m-p/97542#M509737 <HTML><HEAD></HEAD><BODY><P>And what if i would like to have differences by customer? </P><P></P><P>So imagine that in the table there's another field Customer and i want to calculate difference at customer level? How this can be done?</P><P>Thank you!</P></BODY></HTML> Wed, 18 Jul 2018 10:33:20 GMT https://community.qlik.com/t5/QlikView/Formula/m-p/97542#M509737 qlikviewaf 2018-07-18T10:33:20Z Re: Formula https://community.qlik.com/t5/QlikView/Formula/m-p/97543#M509738 <HTML><HEAD></HEAD><BODY><P>Then you need to first order by customer and then date.... and during the creation of the field.... check if(Customer = Previous(Customer)... before you perform your calculation</P></BODY></HTML> Wed, 18 Jul 2018 10:35:11 GMT https://community.qlik.com/t5/QlikView/Formula/m-p/97543#M509738 sunny_talwar 2018-07-18T10:35:11Z