Calculate daily return

[#1]

Hi,

How can I calculate daily return in Qlikview?

[israrkhan]

share sample document or try previous() function in load script.

or above() function in front end...

[#3]

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.

[male_carrasco · Accepted solution]

try

(Above(sum(Price))-sum(Price)) / sum(Price)

Ale.-

[#5]

Thanks!

[MK_QSL]

Like this?