Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
fisland92
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
kerdoncuff
Contributor III
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

View solution in original post

2 Replies
kerdoncuff
Contributor III
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

fisland92
Contributor III
Contributor III
Author

i did this solution,

it worked.

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

thanks my friend!