topic moving difference in QlikView

moving difference

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

hi there,

ı need to calculate "moving difference" in a table, by expression or what ever.

ı have a table like that,

how can ı calculate the sales difference and sales difference by %

thanks for your helps.

Anonymous — Tue, 24 Oct 2017 08:12:04 GMT

Hi,

supposed descending sort on month, try this :

sum(sales)-Above(sum(sales),-1)

and this for % :

sum(sales)/Above(sum(sales),-1)-1

Anonymous — Tue, 24 Oct 2017 15:38:19 GMT

i did this solution,

it worked.

but : in percentage calculating , with no "relative" check.

thanks my friend!