topic Re: Incorrect TOTAL in pivot table in QlikView

Incorrect TOTAL in pivot table

Fri, 20 Nov 2020 18:02:30 GMT

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

I am calculating product sales as val* mni

Thanks

Re: Incorrect TOTAL in pivot table

Thu, 12 Feb 2015 10:57:08 GMT

Expand the table and check

Re: Incorrect TOTAL in pivot table

Thu, 12 Feb 2015 11:02:00 GMT

Hi,

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

Please check.

Regards,

Joshmi

Re: Incorrect TOTAL in pivot table

Thu, 12 Feb 2015 11:04:42 GMT

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.

Re: Incorrect TOTAL in pivot table

Thu, 12 Feb 2015 11:16:44 GMT

expanding didnt help

Re: Incorrect TOTAL in pivot table

Thu, 12 Feb 2015 11:17:33 GMT

this radio button mode is disabled.

Re: Incorrect TOTAL in pivot table

Thu, 12 Feb 2015 11:18:35 GMT

could you pls Post your sample data.

Re: Incorrect TOTAL in pivot table

Gysbert_Wassenaar — Thu, 12 Feb 2015 11:19:16 GMT

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

Re: Incorrect TOTAL in pivot table

Thu, 12 Feb 2015 11:19:21 GMT

this expression gives me error.

Re: Incorrect TOTAL in pivot table

Fri, 13 Feb 2015 10:56:05 GMT

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

Re: Incorrect TOTAL in pivot table

rubenmarin — Fri, 13 Feb 2015 11:04:48 GMT

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.

Re: Incorrect TOTAL in pivot table

Fri, 13 Feb 2015 11:08:09 GMT

Thanks a lot. Just why are we using the dimensionality and in what all conditions it can be used?!