# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for
Did you mean:
Contributor III

## moving difference

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 %

 term sales sales difference sales difference % 201710 429.461.964 -105.272.061 -19,69% 201709 534.734.025 8.759.702 1,67% 201708 525.974.323 6.334.298 1,22% 201707 519.640.025 29.041.695 5,92% 201706 490.598.329 -20.112.051 -3,94% 201705 510.710.380 23.725.775 4,87% 201704 486.984.606 -5.615.864 -1,14% 201703 492.600.470 32.737.748 7,12% 201702 459.862.722 -7.776.271 -1,66% 201701 467.638.993 -18.887.594 -3,88% 201612 486.526.587 23.837.553 5,15%

1 Solution

Accepted Solutions
Contributor III

Hi,

supposed descending sort on month, try this :

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

and this for % :

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

2 Replies
Contributor III

Hi,

supposed descending sort on month, try this :

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

and this for % :

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

Contributor III
Author

i did this solution,

it worked.

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

thanks my friend!