Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

zahidrahim_ocp
Contributor

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

Tags (1)
1 Solution

Accepted Solutions
MVP
MVP

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

4 Replies
MVP
MVP

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

agigliotti
Honored Contributor II

Re: Wrong Table Total

try with below expression:

(

sum( FABS(INPUT_QUANTITY) - OUTPUT_QUANTITY )

/

SUM( FABS(INPUT_QUANTITY) )

)

* 100

zahidrahim_ocp
Contributor

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

MVP
MVP

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?