Deviation from a previous line

[jrbrutto]

Hi there's anyone knows how to achieve this in Qlik Sense?

Column % is bases on the previous value so calculation for the 6/10 should be 

((229910-241756)/241756)*100

Thanks

[martinpohl]

load

Date,

Value,

((Value-previous(Value))/previous(Value))*100 as "%"

from your data

Regards

[jrbrutto]

Hi,

Could I do it at pivot table level also?

Thanks

[jrbrutto · Accepted solution]

I think I found: Above function is the key

=(if(isnull(Line),0,Line)-if(isnull(Above(Line)),0,Above(Line))) / if(isnull(Above(Line)),0,Above(Line))

Thanks everyone anyway