Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
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 %

    

termsalessales differencesales difference %
201710429.461.964-105.272.061-19,69%
201709534.734.0258.759.7021,67%
201708525.974.3236.334.2981,22%
201707519.640.02529.041.6955,92%
201706490.598.329-20.112.051-3,94%
201705510.710.38023.725.7754,87%
201704486.984.606-5.615.864-1,14%
201703492.600.47032.737.7487,12%
201702459.862.722-7.776.271-1,66%
201701467.638.993-18.887.594-3,88%
201612486.526.58723.837.5535,15%

thanks for your helps.

1 Solution

Accepted Solutions
Highlighted
Contributor III
Contributor III

Re: moving difference

Hi,

supposed descending sort on month, try this :

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

and this for % :

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

View solution in original post

2 Replies
Highlighted
Contributor III
Contributor III

Re: moving difference

Hi,

supposed descending sort on month, try this :

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

and this for % :

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

View solution in original post

Highlighted
Contributor III
Contributor III

Re: moving difference

i did this solution,

it worked.

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

thanks my friend!