topic Re: Subtotals in Pivot table in QlikView

Subtotals in Pivot table

Fri, 25 Apr 2014 05:31:51 GMT

Hi everyone,

Need to add subtotal in pivot table

I have a Pivot table like this:

But i need to show subtotals like the following:

Can anyone help me to find solution for the above requirement..

Re: Subtotals in Pivot table

its_anandrjs — Fri, 25 Apr 2014 05:35:30 GMT

Go to properties >> Presentation >> Select Dimension >> Subtotals at bottom.

If have some sample then provide.

Re: Subtotals in Pivot table

Fri, 25 Apr 2014 05:38:37 GMT

hi you can select subtotal at bottom in the presentation tab

Re: Subtotals in Pivot table

Fri, 25 Apr 2014 05:43:18 GMT

Hi Anand,

thanks for your reply....

After enabling Subtotals at bottom,I got the last row Total like this

But i need subtotal like this

pls suggest me some other solutions....

Re: Subtotals in Pivot table

Fri, 25 Apr 2014 05:45:55 GMT

Hi,

Right Click on Pivot Table >> Go to Properties >> Presentation >> Dimensions And Expressions >> Select Dimension (Source) >> Click check Box Show Partial Sum.

Re: Subtotals in Pivot table

its_anandrjs — Fri, 25 Apr 2014 05:47:51 GMT

Check how many dimension you have for that go to the presentation >> Dimension & expression and select dimension >> and then partial sum like ways do for rest of the dimension and you get its partial sum.

For each dimension you have to give partial sum.

Re: Subtotals in Pivot table

MK_QSL — Fri, 25 Apr 2014 05:58:09 GMT

Right Click on Pivot Table >> Presentation Tab >> Select Source From Dimensions and Expressions

>> Tick Show Partial Sum >> Select Subtotal at Bottom

Write Labels for Total as SUBTOTAL

Re: Subtotals in Pivot table

SunilChauhan — Fri, 25 Apr 2014 06:02:33 GMT

you can do subtotal only on the basis of field in dimention

but if you want subtotal in samefield that is bit difficult to find

then you can use like below

if(Source='A-Call in' or Source='A-SMS' or Source='A-Web', Subtotal,Source)

same for others and Total

hope this helps

Re: Subtotals in Pivot table

jagan — Fri, 25 Apr 2014 06:03:50 GMT

Hi,

How many Dimensions you have in your chart? If you have second dimension then only you will get the Subtotals. On what basis you want to generate the SubTotal?

Regards,

Jagan.

Re: Subtotals in Pivot table

Fri, 25 Apr 2014 06:13:34 GMT

Thanks for all reply...

Here,I have attached the sample application....

Pls help me to achieve subtotal......

Re: Subtotals in Pivot table

MK_QSL — Fri, 25 Apr 2014 06:21:12 GMT

Go to presentation tab

Select Source >> TICK Show Partial Sum

Select 2nd Dimension Which is Blank >> Tick Show Partial Sum

Select Subtotal At Bottom

Re: Subtotals in Pivot table

jagan — Fri, 25 Apr 2014 06:48:48 GMT

Hi,

Try like this

Chart Properties -> Presentation -> Click on Source and select Show Partial Sum

>> Click on 2nd Dimension (which is Blank) >> select Show Partial Sum

Hope this helps you.

Regards,

Jagan.

Re: Subtotals in Pivot table

Fri, 25 Apr 2014 07:02:19 GMT

Thanks for all reply.....

I need to add subtotal row like the following table:

PFA and help.....

Re: Subtotals in Pivot table

Anonymous — Wed, 11 Jun 2014 08:59:20 GMT

A simple method would be to create an inline Table using the Source field and giving the 'A-' records a value of 'A' and the remaining 3 a value of 'B'. Chose suitable field names to join with your main table. You can then use the new field with the A & B values as your first dimension and use subtotals on this field.

Regards

Dave

Re: Subtotals in Pivot table

Wed, 11 Jun 2014 09:20:53 GMT

Thanks David,

Similarly, I did this by adding same dimension again using Add calculated Dimension under Dimension.

Re: Subtotals in Pivot table

PradeepReddy — Wed, 11 Jun 2014 09:21:12 GMT

Just drag the column to the top of the expressions columns and enable the partial sums option, you will ge the partial suma at right side of the chart.