Absolute sum at the dimension level in a pivot table in Qlik Sense

[LucyN]

Hi,

I'm totally new to Qlik Sense. I have a pivot table with 2 dimensions: Ccy Pair and Account. I'm making a pivot table where the values have signs, but I want the sum at the Account level to be absolute value (please see the screenshot below). Is there any settings or function that can serve this purpose?

 

[Kushal_Chawda]

Assuming sum(Amount) is your measure.  You can replace with your actual measure

=if( Dimensionality()=1,
fabs(sum(aggr(Sum(Amount),Ccy_pair))),Sum(Amount))

[LucyN]

Hi Kush,

Thank you! I got absolute total at the Ccy Pair level, which is great! But the Totals  still show signed (negative) numbers. Is there any way to make Totals = sum of all absolute totals of Ccy Pairs?

[LanBiteam]

Hello Lucy,

I wonder did you get the answer to the Total value? How could it also be shown in absolut value? 

Thank you.

Lan

[Kushal_Chawda]

@LucyN  try below

=if( Dimensionality()=1,
fabs(sum(aggr(Sum(Amount),Ccy_pair))),

if( Dimensionality()=0,
sum(aggr(fabs(sum(aggr(Sum(Amount),Ccy_pair))),Ccy_pair)),

Sum(Amount)))