topic Re: Incorrect subtotal for pivot table in QlikView

Incorrect subtotal for pivot table

Tue, 02 Feb 2016 05:07:34 GMT

Hi All,

I have a table like following:

And I was intend to do a pivot table that sum the result of value1 according to different Type1 subtype1. And if the value of subtype1 = '1' then if should also add the sum of Value2 for the corresponding Type1 into the result

Type1	SubType1	Result
A	1	55.02
	2	10
	Total	65.02
B	1	65.09
	2	40
	Total	105.09

However, the sub total for Type1 and is incorrect.

Anybody have any idea on how to fix it?

Attached is my Qlikview application.

Thanks in advance!

Re: Incorrect subtotal for pivot table

settu_periasamy — Tue, 02 Feb 2016 06:37:44 GMT

May be try this..

=Sum(Aggr(sum(Value1) + if(SubType1 = '1', sum(Total<Type1> Value2),0),Type1,SubType1))

Re: Incorrect subtotal for pivot table

vipin_mishra479 — Tue, 02 Feb 2016 07:56:48 GMT

Please see this