Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
praveen_peddi
New Contributor

Totals Function - Auto vs Sum

Hi,

While I am using Totals function as 'Auto' it's generating wrong totals (despite summing up the records in the expression) but another filed with same expression but when select Totals Function as 'Sum' giving the right results.  

I have a requirement to show the value as KPI where it's automatically considering Auto as Totals function and I don't see any option for that KPI's to change the Totals function from Auto to Sum.  Hence, can we use some expression and make the KPI's expression to automatically consider 'Sum' but not 'Auto'?

Attached the qvf, screenshot and source file.  Please help.  Thanks.

1 Solution

Accepted Solutions
Highlighted
Employee
Employee

Re: Totals Function - Auto vs Sum

Use this expression:
Sum(Aggr(Sum(Sales)*avg(Price),Country))

View solution in original post

1 Reply
Highlighted
Employee
Employee

Re: Totals Function - Auto vs Sum

Use this expression:
Sum(Aggr(Sum(Sales)*avg(Price),Country))

View solution in original post