topic Re: Subtotal in pivot table in QlikView

Subtotal in pivot table

agni_gold — Wed, 06 May 2015 16:29:55 GMT

Hi Friends , i trying to subtotal at each level , but it is not working , please help .

I am attaching the screenshot.

Re: Subtotal in pivot table

sunny_talwar — Wed, 06 May 2015 16:31:36 GMT

What is not working? What was your expecation? It would be much better if you can post a sample with what is the expected result.

Best,

Sunny

Re: Subtotal in pivot table

Anonymous — Wed, 06 May 2015 16:38:01 GMT

Hi!

Select Show Partial Sums, by dimensions or expressions where you want the subtotal

Regards!

Re: Subtotal in pivot table

Anonymous — Wed, 06 May 2015 16:38:57 GMT

Maybe something's wrong with your expression.

Re: Subtotal in pivot table

buzzy996 — Wed, 06 May 2015 16:44:56 GMT

from style tab--select indent mode.

Re: Subtotal in pivot table

agni_gold — Wed, 06 May 2015 16:48:44 GMT

Please see the attached image

Thanks

Re: Subtotal in pivot table

sunny_talwar — Wed, 06 May 2015 16:50:15 GMT

What is your expression for Sum???

Re: Subtotal in pivot table

agni_gold — Wed, 06 May 2015 16:50:23 GMT

I have done this . but same result is coming.

Re: Subtotal in pivot table

Anonymous — Wed, 06 May 2015 17:02:18 GMT

You can share your application please

Re: Subtotal in pivot table

Clever_Anjos — Wed, 06 May 2015 20:31:16 GMT

Please post here your expression formula

Re: Subtotal in pivot table

ToniKautto — Wed, 06 May 2015 22:54:32 GMT

I am quite confident with that the results you see are accurate, based on your current expression. The result will depend on your dimension, expression, current selection and data model. It is impossible to explain why you get the result you get, or to suggest how you can get the expected result, based on a screenshot.

If the Sum() aggregation is fairly simple this issue can be commonly resolved by applying Aggr() in the below pattern.

Sum( Aggr( Sum(Expression), Dim1, Dim2, ... ,DimN )

Please attach a sample QVW so that dimension, expression, current selection and data model can be considered in more detail.

Re: Subtotal in pivot table

Anonymous — Wed, 06 May 2015 23:31:59 GMT

I expect this result if the expression is without explicit aggregation for example:

If it is

sum(1)

the totals will be rather different