Formula

[qlikviewaf]

Hi,

i'm using this formula Rangesum(HistoricalWIUSD-Previous(HistoricalWIUSD)) as DailyDelta to calculate the Daily Delta.

The thing is that i would like to have for each day the difference between current day and the previous day.

The solution is to order the table using ORDER BY DATE at the end?
Thank you

[sunny_talwar]

The solution is to order the table using ORDER BY DATE at the end?

Yup

[qlikviewaf]

And what if i would like to have differences by customer?

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?

Thank you!

[sunny_talwar]

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