QlikSense: RangeSum(Sum...

[karolka]

Hello, can someone please explain to me the below code:

Sum(Aggr(Fabs(RangeSum(Sum({<"Key Figure"= {'Code1'}>}Quantity),
-Sum({<"Key Figure"= {'History'}>}Quantity))), Country ,Market, Date))

[brunobertels · Accepted solution]

hi 

it sums the quantity when key figure is code 1 ; Sum({<"Key Figure"= {'Code1'}>}Quantity)

then substract the quantity when figure is history ; -Sum({<"Key Figure"= {'History'}>}Quantity) = 

RangeSum(Sum({<"Key Figure"= {'Code1'}>}Quantity),
-Sum({<"Key Figure"= {'History'}>}Quantity))

then sort the result always in absolute positive value : 

Sum(Aggr(Fabs(RangeSum(Sum({<"Key Figure"= {'Code1'}>}Quantity),
-Sum({<"Key Figure"= {'History'}>}Quantity))), Country ,Market, Date))

Fabs(RangeSum(Sum({<"Key Figure"= {'Code1'}>}Quantity),
-Sum({<"Key Figure"= {'History'}>}Quantity)))

And group the result by country, market and date : 

Aggr(Fabs(RangeSum(Sum({<"Key Figure"= {'Code1'}>}Quantity),
-Sum({<"Key Figure"= {'History'}>}Quantity))), Country ,Market, Date)

and give the result as an integer :