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

1 Solution

Accepted Solutions
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

17 Replies
OmarBenSalem
Partner
Partner

Add the total in ur dimensions:

exmple:

Capture.PNG

kizzydavies
Creator
Creator
Author

Hi Omar,

I tried that and it still does not show the total of the rows.

Thanks,

Kizzy

QLIK Pivot Chart Totals2.PNG

sunny_talwar

What exactly is your expression here? Are you using Dimensionality() somewhere in your expression?

kizzydavies
Creator
Creator
Author

Hi Sunny,

not sure what you mean by dimensionality but I am using the following

MEASURE     -     Avg([Days In Status])

Thanks,

Kizzy

sunny_talwar

And you want to see the sum of rows as your total, right?

Check this

Sum of rows in pivot tables ‒ QlikView

Basically, wrap your expression around with Sum(Aggr()) function and see if that works for you

Sum(Aggr(Avg([Days In Status]), <Dimension/s>))

kizzydavies
Creator
Creator
Author

Hi Sunny,

I am using QLIK Sense not Qlik View and the sum does not work, it does not bring up any results.  Any ideas?

Thanks,

kizzy

sunny_talwar

There is not much difference between QlikView and Qlik Sense when it comes to this kind of expression. Anyways, would you be able to share a sample to see what might be going on?

kizzydavies
Creator
Creator
Author

Hi Sunny,

Please see below.  I cannot get the AGGR to work.  please advise.

Thanks,

Kizzy

QLIK Pivot Chart Totals3.PNG

sunny_talwar

This isn't complete... where is the dimension in here?

Capture.PNG