Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

markgraham123
Contributor II

Pivot table - Sum total of column - Not working

Hi,

I have large num. of rows in a column and i'm trying to get the sum of the numbers in the column.

I tried using Subtotals>Display on top/bottom. But, no result.

Can anyone pls help me in getting the grand total of the column.

1 Solution

Accepted Solutions
jebamalai
Valued Contributor

Re: Pivot table - Sum total of column - Not working

In straight table check the total mode area in the expressions tab

22 Replies
jebamalai
Valued Contributor

Re: Pivot table - Sum total of column - Not working

pls attach a small sample app

giakoum
Honored Contributor II

Re: Pivot table - Sum total of column - Not working

enable this for every dimension you need

Capture.PNG

israrkhan
Valued Contributor II

Re: Pivot table - Sum total of column - Not working

you need to select a dimension, for which you want to see the total..then select "show partial sum" for that selected dimension..see in the image..

how many dimensions , do you have in chart??

Untitled.png

markgraham123
Contributor II

Re: Pivot table - Sum total of column - Not working

Hi Jebamalai,

1.png

i'm trying to get the total of the "30 day velocity"

markgraham123
Contributor II

Re: Pivot table - Sum total of column - Not working

I have one dimension and i enabled the "Show partial sums" and "Sub totals on the top".

But no result.

jebamalai
Valued Contributor

Re: Pivot table - Sum total of column - Not working

can you attach the screenshot of the pivot and the settings mentioned by the experts in this thread?

markgraham123
Contributor II

Re: Pivot table - Sum total of column - Not working

22.png

I did it.

But Total is not showing up.

jebamalai
Valued Contributor

Re: Pivot table - Sum total of column - Not working

If you have only one dimension then why do you use pivot?

Go for straight table

jebamalai
Valued Contributor

Re: Pivot table - Sum total of column - Not working


You have to check all the calculations(expressions) used in this pivot

For me it looks like you enabled only in the dimension not in the expression