4 Replies Latest reply: Dec 15, 2017 7:32 AM by Sunny Talwar

# Wrong Table Total

Dear Experts,

I have a column in table with some calculation. It is showing correct individual values but the total is wrong. I export the data in excel and the total in excel and qlik have huge difference.

Formula used is:

((SUM(FABS(INPUT_QUANTITY))-SUM(OUTPUT_QUANTITY))/SUM(FABS(INPUT_QUANTITY)))*100

Regards,

Zahid Rahim

• ###### Re: Wrong Table Total

May be use this

Sum(Aggr(

((SUM(FABS(INPUT_QUANTITY))-SUM(OUTPUT_QUANTITY))/SUM(FABS(INPUT_QUANTITY)))*100,

YourDimension/s))

Also, look here

Sum of rows in pivot tables ‒ QlikView

• ###### Re: Wrong Table Total

Dear Sunny,

Thank you very much. You were always my life savor. May i know the reason as why my expression was showing wrong total whereas your gave correct totals.

Regards,

Zahid Rahim

• ###### Re: Wrong Table Total

What I gave you is basically doing sum of individual rows, where as without Sum(Aggr()) it performs the same calculation for the total row... i.e.

It will first perform the numerator calculation and sum it up

((SUM(FABS(INPUT_QUANTITY))-SUM(OUTPUT_QUANTITY))

and then the denominator calculation

SUM(FABS(INPUT_QUANTITY))

and then divide it....

Does that make sense?

• ###### Re: Wrong Table Total

try with below expression:

(

sum( FABS(INPUT_QUANTITY) - OUTPUT_QUANTITY )

/

SUM( FABS(INPUT_QUANTITY) )

)

* 100