Qlik Community

Ask a Question

Search the Community

cancel
Showing results for 
Search instead for 
Did you mean: 
Alexia_Frn02
Contributor
Contributor

Différence between auto() and sum() in a total function

Hello, I am trying to understand why I don't have the same result when I am using Auto in the total function for a measure and when I am using the Sum option.

 

rtaImage.png

Could you please explain to me how it is possible ?

I have already red the article "Expression total vs sum of rows" but it did not helped me to understand. 

Thank you in advance.

Alexia

1 Reply
Nicole-Smith

The Auto option uses your calculation for the total whereas the Sum option takes the values in the rows and adds them up.

For example, say you have the following data:

Field1 Field2
A 100
B 100
B 200
C 200
C 300


If you create a table with the following dimension and measure:

Dimension: Field1
Measure: min(Field2)

When choosing Auto, your output will look like this because it applied the Measure (in this case min) across all the values:

Field1 Field2
Total 100
A 100
B 100
C 200


When choosing Sum, your output will look like this because it sums up all of the values of the rows:

Field1 Field2
Total 400
A 100
B 100
C 200

Community Browser