# New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Highlighted
Contributor II

## Aggregation Help

 Week Supervisor Associate Total Cartons Total Pieces 02/04/2019 - 02/10/2019 AAA A 1,123 7,701 02/04/2019 - 02/10/2019 AAA B 167 758 02/04/2019 - 02/10/2019 AAA C 1,208 9,369 02/04/2019 - 02/10/2019 D 1,265 5,345 02/04/2019 - 02/10/2019 BBB E 1,019 5,127

Hi guys,

How do I get the total sum of Total Cartons and Total pieces for the week where supervisor is present? I use the following formula to get the numbers above

Total Cartons = Count (Distinct case#)

Total Pieces = Sum (Units#)

How do I aggregate such that the total sum for the week should include only where there is Supervisor name, if Supervisor is blank, the sum should not include the respective cartons or pieces numbers.

The result would be this without including numbers of blank supervisor cell

 Week Total Cartons Total Pieces 02/04/2019 - 02/10/2019 3,517 22,955

Any help is highly appreciated!

Labels (4)

• ### sum

1 Solution

Accepted Solutions
Honored Contributor II

## Re: Aggregation Help

```Total Cartons = Count (Total <Week> {<Supervisor*={"*"}>}Distinct case#)

Total Pieces = Sum (Total <Week> {<Supervisor*={"*"}>}Units#)```
Learning never stops.
6 Replies
Honored Contributor II

## Re: Aggregation Help

```Total Cartons = Count (Total <Week> {<Supervisor={"*"}>}Distinct case#)

Total Pieces = Sum (Total <Week> {<Supervisor={"*"}>}Units#)```

Try the above

Learning never stops.
Contributor II

## Re: Aggregation Help

When I filter it based on Supervisor, it gives a wrong total.

Honored Contributor II

## Re: Aggregation Help

what do you need when supervisor is selected ?
Learning never stops.
Contributor II

## Re: Aggregation Help

The total sum of carton/pieces for that supervisor.

Honored Contributor II

## Re: Aggregation Help

```Total Cartons = Count (Total <Week> {<Supervisor*={"*"}>}Distinct case#)

Total Pieces = Sum (Total <Week> {<Supervisor*={"*"}>}Units#)```
Learning never stops.
Contributor II

## Re: Aggregation Help

Thank you, that works!

Community Browser