topic Re: Column Total for each row in QlikView

Column Total for each row

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I have the following data

PID	CustomerID	Country	Qty	Amount
1	ALFKI	India	10	1000
2	ANATR	India	20	2000
3	BERGS	India	30	3000
4	ALFKI	USA	15	15000
5	ANATR	USA	25	25000
6	BERGS	USA	35	35000
7	ANATR	UK	20	200000
8	BERGS	UK	40	400000
9	ALFKI	UK	60	600000
10	AROUT	Japan	100	100000

I have created the pivot table in qlikview.

I want the "Sum of Count PID" and "Sum of Amount" to be displayed. (for below I have created it manually)

Please suggest.

CustomerID	ALFKI	ALFKI	ANATR	ANATR	AROUT	AROUT	BERGS	BERGS	Sum of Count PID	Sum of Amount
Country	Count PID	Amount	Count PID	Amount	Count PID	Amount	Count PID	Amount	Sum of Count PID	Sum of Amount
India	1	1000	1	2000	-	-	1	3000	3	6000
Japan	-	-	-	-	1	100000	-	-	1	100000
UK	1	600000	1	200000	-	-	1	400000	3	1200000
USA	1	15000	1	25000	-	-	1	35000	3	75000

Re: Column Total for each row

sunny_talwar — Thu, 14 Dec 2017 18:55:14 GMT

Did you try to enable 'show partial sums' on the presentation tab of chart properties?

Re: Column Total for each row

devarasu07 — Fri, 15 Dec 2017 06:58:28 GMT

Hi,

Try to create pivot chart object

Dimension:

Country

CustomerID

Measure:

Count

Count(DISTINCT PID)

Amount:

sum(Amount)

go to chart property--> presentation tab--> enable "Always fully expanded"

and "Show Partial Sums" check box then you will get the desired output.

Thanks

Deva

Re: Column Total for each row

sunny_talwar — Fri, 15 Dec 2017 09:58:32 GMT

devarasu07‌, Why is 'Always fully expanded' needed here? Did I miss the part of the question above?

Re: Column Total for each row

devarasu07 — Fri, 15 Dec 2017 10:04:38 GMT

Hi Sunny,

It's not required actually, because of two dimension expanded it (this case not required, one dimension sitting in row and other one sitting in column.)

Thanks,
Deva

Re: Column Total for each row

sunny_talwar — Fri, 15 Dec 2017 10:06:44 GMT

Oh okay, I saw that part in your response and I wondered that did I miss something in the question. Thanks for getting back with the explanation

Re: Column Total for each row

Anonymous — Tue, 19 Dec 2017 18:43:15 GMT

Thanks for your reply.

Is there any way to show a common header "CustomerID" above customer id values (ALKFI,ANTAR,AROUT,BERGS).

Currently it is displayed on left Side.

Please Suggest