Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Old Topic: difference sum and the qualifier TOTAL

Hello,

I got an old topic where someone tried to explain the difference between the aggregation sum and the qualifier TOTAL.

Can someone explain to me in plain words what he meant?

Here is the old post:

Re: Difference between sum and expression Total in Straight table

Hi,

Sum - will give you the sum of all rows in the table

Expression Total - will give you the overall expression total.

For example:

Year     A     B

2013     50     100

2014     50     150

When you use A/B as expression and use Year as Dimension

Sum Mode - 83% (50 + 33) (50/100 + 50/150 = 50% + 33 % = 83%)

Expression Mode - 40% (100/250) (50 + 50) / (100 + 150)

I understand fully the explanation in the Qlik Website:

Year Quarter Sum(Amount) Sum({1} TOTAL Amount) Sum(Amount)/Sum({1} TOTAL Amount)
  30001080027,8%
2012Q217001080015,7%
2013Q213001080012%

 

But there is also only ONE Column of Amount to calculate. 

 

Can someone please explain me his calculation in plain words (purple highlighted)?

Thank you!

 

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

Re: Old Topic: difference sum and the qualifier TOTAL

The explanation in purple is not about the TOTAL qualifier. The explanation is about the "Total Mode" property available in QlikView Straight Table, but not in Qlik Sense.  It controls how the Total row in the chart is calculated. 

2020-05-31_10-05-32.png

-Rob

View solution in original post

3 Replies
Highlighted
Employee
Employee

Re: Old Topic: difference sum and the qualifier TOTAL

The simple explanation is that the TOTAL qualifier ignores dimensions and calculates the measure across all dimensions.

Highlighted
MVP & Luminary
MVP & Luminary

Re: Old Topic: difference sum and the qualifier TOTAL

The explanation in purple is not about the TOTAL qualifier. The explanation is about the "Total Mode" property available in QlikView Straight Table, but not in Qlik Sense.  It controls how the Total row in the chart is calculated. 

2020-05-31_10-05-32.png

-Rob

View solution in original post

Highlighted
Partner
Partner

Re: Old Topic: difference sum and the qualifier TOTAL