Average and Sum of column in separate KPI text box?

[haneeshmarella]

How do I get the average of Carton Efficiency and Pieces Efficiency in separate KPI box? Also, Sum of Total Cartons and Total Pieces in separate KPI box?

The formula for each row of the columns are:

Total Cartons : Count(distinct CASE#)

Total Pieces: num(sum(UNITS#),'#,##0')

Carton Efficiency: num(Count(TOTAL <USER_NAME> DISTINCT CASE#)/(HOURS*29),'#.# %')

Pieces Efficiency: num(SUM(TOTAL <USER_NAME> DISTINCT UNITS#)/(HOURS*29),'#.# %')

Thank you.

[qlikviewwizard]

Please upload sample file with the dummy data.

[settu_periasamy · Accepted solution]

Maybe try like this in the text box

Total Cartons : =SUM(aggr(Count(distinct CASE#),DATE,SUPERVISOR,ASSOCIATE))

Carton Efficiency :

=Avg(Aggr(

num(Count(TOTAL <USER_NAME> DISTINCT CASE#)/(HOURS*29),'#.# %')

,DATE,SUPERVISOR,ASSOCIATE))

[haneeshmarella]

Thank you Settu. Can you help me here too please?

How do I get Sum for each column?

[haneeshmarella]

Hi Arjun,

Settu has given me the answer. Thank you for the response.