topic Re: Summing measures per dimensions in table in App Development

Summing measures per dimensions in table

JHoltrop — Thu, 06 Apr 2023 12:25:45 GMT

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.

Re: Summing measures per dimensions in table

brunobertels — Thu, 06 Apr 2023 13:08:04 GMT

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 ))

)

fabs(

Sum(

aggr( Measure_a ,Employee ,week )

)

Sum(

aggr( Measure_b ,Employee ,week )

)

Re: Summing measures per dimensions in table

JHoltrop — Fri, 07 Apr 2023 08:11:57 GMT

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