Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

cmatcovich
New Contributor

Partial sum value in a pivot table

Hi everibody,

I need an expression to calculate a partial percentage (percentage on a subtotal) in a pivot table like this:

Dim1Dim2Sum(Value)SumTPartPerc
AAA1617%
AB2633%
AC3650%
Total6 100%
BBA106017%
BB206033%
BC306050%
Total60 100%
Total 66

I tried with this SumT expression:

sum(aggr(sum(Value), Dim1))


but the correct value (6 or 60) is shown only in some cells and not in all of them.

Tanks for any suggestion!

Corrado Matcovich

1 Solution

Accepted Solutions
Not applicable

Re: Partial sum value in a pivot table

Hi,

Try with this:

sum(TOTAL <Dim1> Value)

See the attached.

Regards,

Ricardo

View solution in original post

2 Replies
Not applicable

Re: Partial sum value in a pivot table

Hi,

Try with this:

sum(TOTAL <Dim1> Value)

See the attached.

Regards,

Ricardo

View solution in original post

cmatcovich
New Contributor

Re: Partial sum value in a pivot table

It works (and il was so easy ...)

Thanks a lot.

Regards

Corrado