topic Re: Re: Calculate daily return in QlikView https://community.qlik.com/t5/QlikView/Calculate-daily-return/m-p/691595#M1074602 <HTML><HEAD></HEAD><BODY><P>I just would like to calculate basic (r1-r2)/r2 where r1 is price today and r2 is price of yeasterday... I would like to do this with expression as there needs to be done some aggregation in my actual data.</P></BODY></HTML> Thu, 31 Jul 2014 12:45:13 GMT 2014-07-31T12:45:13Z Calculate daily return https://community.qlik.com/t5/QlikView/Calculate-daily-return/m-p/691593#M1074600 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>How can I calculate daily return in Qlikview?</P><P></P><P><IMG alt="Picture1.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/63480_Picture1.png" style="width: 620px; height: 382px;" /></P></BODY></HTML> Thu, 31 Jul 2014 12:29:09 GMT https://community.qlik.com/t5/QlikView/Calculate-daily-return/m-p/691593#M1074600 2014-07-31T12:29:09Z Re: Calculate daily return https://community.qlik.com/t5/QlikView/Calculate-daily-return/m-p/691594#M1074601 <HTML><HEAD></HEAD><BODY><P>share sample document or try previous() function in load script.</P><P>or above() function in front end...</P></BODY></HTML> Thu, 31 Jul 2014 12:37:52 GMT https://community.qlik.com/t5/QlikView/Calculate-daily-return/m-p/691594#M1074601 israrkhan 2014-07-31T12:37:52Z Re: Re: Calculate daily return https://community.qlik.com/t5/QlikView/Calculate-daily-return/m-p/691595#M1074602 <HTML><HEAD></HEAD><BODY><P>I just would like to calculate basic (r1-r2)/r2 where r1 is price today and r2 is price of yeasterday... I would like to do this with expression as there needs to be done some aggregation in my actual data.</P></BODY></HTML> Thu, 31 Jul 2014 12:45:13 GMT https://community.qlik.com/t5/QlikView/Calculate-daily-return/m-p/691595#M1074602 2014-07-31T12:45:13Z Re: Calculate daily return https://community.qlik.com/t5/QlikView/Calculate-daily-return/m-p/691596#M1074603 <HTML><HEAD></HEAD><BODY><P>try </P><P></P><P>(Above(sum(Price))-sum(Price)) / sum(Price)</P><P></P><P>Ale.-</P></BODY></HTML> Thu, 31 Jul 2014 12:46:18 GMT https://community.qlik.com/t5/QlikView/Calculate-daily-return/m-p/691596#M1074603 male_carrasco 2014-07-31T12:46:18Z Re: Calculate daily return https://community.qlik.com/t5/QlikView/Calculate-daily-return/m-p/691597#M1074604 <HTML><HEAD></HEAD><BODY><P>Thanks! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 31 Jul 2014 12:48:59 GMT https://community.qlik.com/t5/QlikView/Calculate-daily-return/m-p/691597#M1074604 2014-07-31T12:48:59Z Re: Calculate daily return https://community.qlik.com/t5/QlikView/Calculate-daily-return/m-p/691598#M1074605 <HTML><HEAD></HEAD><BODY><P>Like this?</P></BODY></HTML> Thu, 31 Jul 2014 12:49:27 GMT https://community.qlik.com/t5/QlikView/Calculate-daily-return/m-p/691598#M1074605 MK_QSL 2014-07-31T12:49:27Z