topic Re: Pivot table with sum TOTAL in QlikView

Pivot table with sum TOTAL

Wed, 25 Nov 2020 16:16:04 GMT

I need to use a Dynamic table with TOTAL, but this should add up all the columns and not redo the calculation based on the total.

tks

Re: Pivot table with sum TOTAL

sunny_talwar — Fri, 23 Sep 2016 22:47:43 GMT

Try this:

If(SecondaryDimensionality() = 0, Sum(Aggr(Sum(Metric)/Sum(Denom), Period)), Sum(Metric)/Sum(Denom))

Update: My bad the dimension should be Period and not SECTION.

Re: Pivot table with sum TOTAL

sunny_talwar — Sat, 24 Sep 2016 11:00:55 GMT

I think after testing it out, this is what you might need:

If(SecondaryDimensionality() = 0 and Dimensionality() = 1, Sum(Aggr(Sum(Metric)/Sum(Denom), Period, SECTION)), If(SecondaryDimensionality() = 0 and Dimensionality() = 0, Sum(Aggr(Sum(Metric)/Sum(Denom), Period)), Sum(Metric)/Sum(Denom)))

Re: Pivot table with sum TOTAL

antoniotiman — Sat, 24 Sep 2016 12:29:36 GMT

Hi,

You can try

If(SecondaryDimensionality()=0,
RangeSum(First(Sum(Metric)/Sum(Denom),1,NoOfColumns())),
Sum(Metric)/Sum(Denom))

Regards,

Antonio

Re: Pivot table with sum TOTAL

Mon, 26 Sep 2016 17:32:59 GMT

It worked, tks.

but forgot to mention that the total of the top must also add up. As example.

Can you help me?

Re: Pivot table with sum TOTAL

sunny_talwar — Tue, 27 Sep 2016 17:21:32 GMT

That simplify things:

Sum(Aggr(Sum(Metric)/Sum(Denom), Period, SECTION))

Re: Pivot table with sum TOTAL

Fri, 30 Sep 2016 17:15:33 GMT

Perfect... thanks so much...