Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Oiesof
Contributor
Contributor

Auto vs. Sum (Table vs. KPI)

Hello!

I have a table that shows hours saved per group per process. While I am using Totals function as 'Auto' it's generating wrong totals, but selecting Totals Function as 'Sum' giving the right results.  I want to show the total/sum in a seperate KPI. However, when I write the formula it shows the total wrong (it shows the same number as when I choose 'Auto' in the table). How can I change my formula to show the same number as when I choose 'Sum' in the table? As far as I can see I cannot choose between Auto and Sum for the KPI. 

Additional info is that the 'Completed Cases' is a variable. It consist of incoming cases minus exception cases.

The formula I use for calculating total hours 

=sum(aggr($(vCompletedCases),Process,Group))*sum(aggr([Minutes per case per process], Process,Group))/60

GroupProcessMinutes per case per processCompleted cases per group per processTotal hours per group per process
Total  5114,49 (what I want)
A1104(10*4)/60 = 0,67
B11050,83
C11061
A220103,33
B220124
C220144,66


Hope you can help me! In advance, thank you.

0 Replies