topic Subtotals / Dimension in QlikView

Subtotals / Dimension

Wed, 01 Jun 2011 11:49:25 GMT

Hello,

I've got two dynamic dimensions in my pivot and want to get the subtotals for the second dimension.

Mhh, i think with a sample it's easier to understand:

My pivot looks like that:

And I want to get this:

Is this possible?

Thank you for suggestions

Björn

Subtotals / Dimension

Wed, 01 Jun 2011 12:11:10 GMT

Hello Bjorn,

Hope this helps: Goto Properties-> Presentaion -> Select DinDym2 and check the box Show Partial Sums.

I dont know if you tried this, but this should help.

Thanks,

ANDY

Subtotals / Dimension

Wed, 01 Jun 2011 12:16:26 GMT

Hello Andy,

yes I tried this, but the output is:

But my goal is to get the totals for the Devils on the one hand, and the totals for the Angels on the other hand.

Subtotals / Dimension

Wed, 01 Jun 2011 12:55:37 GMT

Hello Jonas,

Pivot tables are really powerful and a bit tricky sometimes to use, as totalling mostly depends on the Dimensions you are selecting. Try this, move the dimension DynDim2 before DynDim and get rid of Val. If this doesnt work then you might need a calculated dimension or an expression which should be if(DynDim2 = Devils, sum()) and so on.

Hope this helps,

ANDY