Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ashishpalkar
Contributor II

Total function Auto () and Sum () returning different values

Hi There

I am trying to understand Total Function available in the straight table.

I am using these functions for one of the app and when Total Function 'Auto()' is used it shows different value than 'Sum()'

Thanks for your help,

5 Replies
MVP
MVP

Re: Total function Auto () and Sum () returning different values

Check here for TOTAL qualifier within Sum or Avg or Min....

What does the TOTAL qualifier do?

MVP
MVP

Re: Total function Auto () and Sum () returning different values

Auto function? Have never heard of this before... do you mean RowNo() or Above() function?

Re: Total function Auto () and Sum () returning different values

Can you post an example of your difference?

ashishpalkar
Contributor II

Re: Total function Auto () and Sum () returning different values

File

Re: Total function Auto () and Sum () returning different values

Auto means calculate the total by evaluating the expression over all data.  Sum means to sum up the rows in the chart. There can be differences depending on your data model and dimensions used.  For example, Auto will never double count. Sum can double count when for example the same fact is connected to more than one dimension in the chart.

I couldn't speculate on the details of your difference without seeing the data model and the expression.

-Rob