topic Partial sum total in Pivot Table with Dimensions as CyclicGroup in QlikView

Partial sum total in Pivot Table with Dimensions as CyclicGroup

Tue, 28 Feb 2012 17:05:20 GMT

Hi Guys,

I have this problem as below in the following thread.

http://community.qlik.com/message/189400#189400

Thanks to stefan

I know it gets solved with AGGR as explained in the thread. My Question is if I have a cyclic Group as Dimension containing 6 Dimensions(Dim1...Dim6) grouped,

I can't always write in my Sum(Aggr(Sum(Exp1, Dim1, Dim2, Dim3,..Dim6)) everytime I create a chart for Partial sums.

Is there any other way when using Cyclic Group as Dimension?

Thanks in advance

Sravan

Partial sum total in Pivot Table with Dimensions as CyclicGroup

Wed, 29 Feb 2012 10:42:38 GMT

Can anyone help with this Issue?

Thanks

Sravan

Partial sum total in Pivot Table with Dimensions as CyclicGroup

jagan — Wed, 29 Feb 2012 11:44:01 GMT

Hi Sravan,

Can you try like this

=If(GetCurrentField(GroupName) = 'Dimension1', Sum(Aggr(Sum(Exp1, Dimension1)),

If(GetCurrentField(GroupName) = 'Dimension2', Sum(Aggr(Sum(Exp1, Dimension2)),

If(GetCurrentField(GroupName) = 'Dimension3', Sum(Aggr(Sum(Exp1, Dimension3)),

If(GetCurrentField(GroupName) = 'Dimension4', Sum(Aggr(Sum(Exp1, Dimension4)),

If(GetCurrentField(GroupName) = 'Dimension5', Sum(Aggr(Sum(Exp1, Dimension5)),

If(GetCurrentField(GroupName) = 'Dimension6', Sum(Aggr(Sum(Exp1, Dimension6))))))))

Hope this helps you.

Regards,

Jagan.

Partial sum total in Pivot Table with Dimensions as CyclicGroup

Fri, 02 Mar 2012 09:45:30 GMT

Hi Jagan,

Thanks.

Your solution or my solution(Sum(Aggr(Sum(Exp1, Dim1, Dim2, Dim3,..Dim6))) can solve the problem

but for enduser it is not easy or practical when they are making their own charts to use them.

I hope there is an easy way and somebody can help.

Regards

Sravan

Re: Partial sum total in Pivot Table with Dimensions as CyclicGroup

Fri, 28 Sep 2012 09:50:25 GMT

What a Glitch?! Please use GetObjectField(Dimensionality())