topic How to create total for each column in pivot table? in QlikView

How to create total for each column in pivot table?

Mon, 17 Nov 2014 01:18:27 GMT

Hi , I'm having problem to display the total of each column in the pivot table in my dashboard. Can anyone help me?

This is my pivot table

I want to display one more row in the pivot table and shows the total of the columns November, December and January.

Can anyone helps me with that?

Regards,

Kama

Re: How to create total for each column in pivot table?

Mon, 17 Nov 2014 01:36:28 GMT

Hi Kama,

In the Presentation tab of the pivot table's properties, select your dimension and check the flag "Show Partial Sums".

Re: How to create total for each column in pivot table?

r_wroblewski — Mon, 17 Nov 2014 01:36:42 GMT

Hi Kama,

Does your Screenshot not show a straight table ?

Did you checked inside the chart properties:

1. Expressions Tab -> Total Mode -> Expression Total

If you need Sub Totals for Pivot table:

Chart properties -> PresentationTab -> Dimensions and Expressions -> Show Partital Sums

Best regards,

Ronny

Re: How to create total for each column in pivot table?

Mon, 17 Nov 2014 01:42:37 GMT

Hi Ronny,

I guess it's a pivot table that may have the option "Always Fully Expanded" checked.

The straight table would basically repeat the dimension's values over the rows.

Re: How to create total for each column in pivot table?

Mon, 17 Nov 2014 01:54:10 GMT

Hi,

Can I display the overall total in the pivot table? I want to add a new row that display the overall total of the column November, December and January. Can I do that in pivot table?

Re: How to create total for each column in pivot table?

r_wroblewski — Mon, 17 Nov 2014 01:56:26 GMT

Hi,

thanks for the hint. You're right.

Regards,

Ronny

Re: How to create total for each column in pivot table?

r_wroblewski — Mon, 17 Nov 2014 02:02:10 GMT

Kama,

you need to do following to enable Totals:

Presentation Tab -> Dimensions and Expressions-> Select your first dimension "FY15 Resource Pool"

-> mark checkbox "Show Partital Sums" and Subtotals "Subtotals at Bottom"

The last row should show now Totals for your month columns.

Regards,

Ronny

Please see one of my pivot tables as example:

Re: How to create total for each column in pivot table?

Mon, 17 Nov 2014 02:05:53 GMT

I can display it now...

Thanks Ronny!

Re: How to create total for each column in pivot table?

Mon, 17 Nov 2014 02:16:03 GMT

Hi,

I am new to Qlikview,In this case which dimension should be selected to show totals at the bottom of the table. Because I tried "show partial sums" and it was showing totals in between rows.

Regards,

Navdeep

Re: How to create total for each column in pivot table?

r_wroblewski — Mon, 17 Nov 2014 02:24:08 GMT

Hi Navdeep,

You need to select your first dimension(highest dimension) because for the pivot table it is just Subtotal.

Please see following screenshot:

In this Example I need to select "Geo Zone" Dimension only under Presentation Tab->

Dimensions & Expressions and Subtotals at the Bottom.

If I would select another dimension I also would get the Subtotals between, depending which dimension is select.

Regards,

Ronny