Pivot table not sub totalling properly

Wed, 05 Sep 2012 13:43:56 GMT

Hello Everyone:

I have an issue where a sub total in a pivot table isn't calculating properly and I'm not sure how to fix my expression. I have a calculated dimension and in the expression I need to turn a negative number into a positive for one of the dimensions. I've done this with the following expression:

If([ACSEGVAL01] >= 41000 and [ACSEGVAL01] <= 46500,

money(sum({<Scenario={'Budget'}>} Amount)) * -1,

money(sum({<Scenario={'Budget'}>} Amount))

)

If the "problem" dimension is expanded all the numbers are positive but the sub-total for this expression/dimension is still negative.

I'm not sure how to resolve this.

Thank you!

Re: Pivot table not sub totalling properly

jvitantonio — Wed, 05 Sep 2012 14:12:59 GMT

Can you attach yourapplication?

Re: Pivot table not sub totalling properly

Wed, 05 Sep 2012 14:17:03 GMT

Try changing to this:

money(sum({<Scenario={'Budget'}>} Amount * If([ACSEGVAL01] >= 41000 and [ACSEGVAL01] <= 46500,-1,1) ))

topic Re: Pivot table not sub totalling properly in QlikView

Pivot table not sub totalling properly

Re: Pivot table not sub totalling properly

Re: Pivot table not sub totalling properly