Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
kizzydavies
Creator
Creator

Qlik Sense - Totalling row sum in a pivot table

Hello,

I cannot find an answered question regarding this topic.

I have a pivot table where the row measure are an average of a data field.  When I click add totals in the it adds up the total records and not the totals of each row.  Please see below totals do not add up to the totals of all the other rows.

Please help.

Thanks,

Kizzy

QLIK Pivot Chart Totals.jpg

17 Replies
OmarBenSalem
Partner
Partner


Sthing like this:

sum(AGGR(Avg(Days),Division,Status))

kizzydavies
Creator
Creator
Author

Hi,

I added the dimension but it still does not work.

Thanks,

Kizzy

QLIK Pivot Chart Totals4.PNG

sunny_talwar

Dimension doesn't have to between <>. That was just to show that the you need to put your dimension/s here....

kizzydavies
Creator
Creator
Author

Hi Omar

Days in Status is field that contains numerical data and I want the average calculation to display on the pivot table and the total of those figures to show in the total.  I don't know how splitting the days and status into 2 sections will work?

Thanks,

kizzy

kizzydavies
Creator
Creator
Author

Hi Sunny,

I amended the expression but now it only shows the total and the first column of data titled default.  below shows all the other columns which should also be included.

Thanks,

Kizzy

QLIK Pivot Chart Totals.jpg

sunny_talwar

You have two dimension, don't you? You need to add all of them into your expression

Sum(Aggr(Expression, Division, [Application Status]))

View solution in original post

kizzydavies
Creator
Creator
Author

it works thanks!!

jltpuzzle
Contributor
Contributor

I would like to have something similar, though the entire pivot table become 0, can shield some lights on me?

sum(Aggr (
if(Trans_Date_YYYYMM<=201810, sum( ANP_New_Combine_USD)/1000000,sum( Forecast_ANP_Total)/1000000)

, CHANNEL, [Transaction Month]))