VizLib Pivot Table: Group Sum

ChristofZ — Wed, 12 Jun 2024 13:14:05 GMT

hello,

I have a VizLib Pivot Table with a few Dimensions and Values - the Table is grouped by the A and/or B column, the table inserts Totals after each group.

I need to calculate the value of the totals by formula - so far I've tried things like aggr(sum(C), A, B) and sum(aggr(...)) and various combinations, sum({1} C), sum(all C), sum(total C), etc etc.

RangeSum() doesn't help me either, because you can't ask it to sum the current group.

Any help would be greatly appreciated.

A	B	C
A1	B1	3
A1	B1	5
A1	B1	2
		Total 10
A2	B2	4
A2	B2	1
A2	B2	3
A2	B2	4
		Total12

Re: VizLib Pivot Table: Group Sum

ChristofZ — Thu, 13 Jun 2024 06:15:41 GMT

ok - found it:

sum(Total <A, B> [C])

you really have to narrow it down giving all the dimensions of the group ("<A, B, ...>") you want to sum up column C in.

Thank you! 😎

topic Re: VizLib Pivot Table: Group Sum in QlikView

VizLib Pivot Table: Group Sum

Re: VizLib Pivot Table: Group Sum