Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Partial sum total in Pivot Table with Dimensions as CyclicGroup

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

4 Replies
Not applicable

Partial sum total in Pivot Table with Dimensions as CyclicGroup

Can anyone help with this Issue?

Thanks

Sravan

MVP
MVP

Partial sum total in Pivot Table with Dimensions as CyclicGroup

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.

Not applicable

Partial sum total in Pivot Table with Dimensions as CyclicGroup

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

Not applicable

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

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

Community Browser