Qlik Community

Ask a Question

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Specialist
Specialist

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
Specialist
Specialist

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

View solution in original post

22 Replies
Specialist
Specialist

pls attach a small sample app

Partner
Partner

enable this for every dimension you need

Capture.PNG

Specialist II
Specialist II

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

Specialist
Specialist

Hi Jebamalai,

1.png

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

Specialist
Specialist

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

But no result.

Specialist
Specialist

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

Specialist
Specialist

22.png

I did it.

But Total is not showing up.

Specialist
Specialist

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

Go for straight table

Specialist
Specialist


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