Solved: Incorrect TOTAL in pivot table - Qlik Community

Report Inappropriate Content · ‎2015-02-12

Hello, cant understand why qlikview shows incorrect total for Product Sales value in pivot table.

I am calculating product sales as val* mni

Thanks

rubenmarin · ‎2015-02-13

Hi Aditi, you can change last expression to:

If(Dimensionality()>0, val*mni, Sum(Aggr(Sum(VALUES)*Sum(product_weightage), TERRITORIES, [IJSF Brick])))

Problem is mni, saleshas to multiply VALUES*weight, in totals, if you multiply by sum of weight, it multiplies by 3.18.

View solution in original post

Report Inappropriate Content · ‎2015-02-12

Expand the table and check

Report Inappropriate Content · ‎2015-02-12

Hi,

Properties> Expression> click on third radio button (sum of rows).

Please check.

Regards,

Joshmi

Report Inappropriate Content · ‎2015-02-12

Val * mni is correctly calculated and since you have selected parent_B in the table grand total is changing, if you dont want the selection to not disturb your grant total change the settings for total calc or in set analysis nullify the selection

sum(<Parent_B> Val* Mni) so when you select parent_B selections will be negated.

Report Inappropriate Content · ‎2015-02-12

expanding didnt help

Report Inappropriate Content · ‎2015-02-12

this radio button mode is disabled.

Report Inappropriate Content · ‎2015-02-12

could you pls Post your sample data.

Gysbert_Wassenaar · ‎2015-02-12

Post a qlikview document that demonstrates the problem. Screenshots are worthless for actual troubleshooting.

talk is cheap, supply exceeds demand

Report Inappropriate Content · ‎2015-02-12

this expression gives me error.

Report Inappropriate Content · ‎2015-02-13

It shows wrong product sales to me, is it because of segmented values w.r.t. the IJSF bricks

Incorrect TOTAL in pivot table

Related Topics