Summing measures per dimensions in table

[JHoltrop]

Hi all,

I have a problem with showing data into a table within Qlik Sense.

I have two measures (Measure_a, Measure_b) with two dimensions (employee, week).

My goal is to get the total absolute value of Measure_a - Measure_b of all employees over all weeks.

Currently I have a master item "Delta" which says : fabs(Measure_a - Measure_b)

However, when inspecting the results it shows the sum of all Measure_a - Measure_b and then takes the absolute value of that number. But I want it to take the absolute of (Measure_a - Measure_b) of each Employee of each week and then sum it. 

[brunobertels · Accepted solution]

hi 

may be this 

But I want it to take the absolute of (Measure_a - Measure_b) of each Employee of each week and then sum it. 

sum(

aggr(

fabs(Measure_a - Measure_b) ,Employee ,week )) 

)

Or 

fabs(

Sum(

aggr( Measure_a ,Employee ,week ) 

)

-

Sum(

aggr( Measure_b ,Employee ,week ) 

)

)

[JHoltrop]

Yes the first one did it! Thank you very much!