Wrong Table Total

[zahidrahim_ocp]

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

[sunny_talwar · Accepted solution]

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

[agigliotti]

try with below expression:

(

sum( FABS(INPUT_QUANTITY) - OUTPUT_QUANTITY )

/

SUM( FABS(INPUT_QUANTITY) )

)

* 100

[zahidrahim_ocp]

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

[sunny_talwar]

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?