Skip to main content

# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
cancel
Showing results for
Search instead for
Did you mean:
Creator 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
Master II
```Total Cartons = Count (Total <Week> {<Supervisor*={"*"}>}Distinct case#)

Total Pieces = Sum (Total <Week> {<Supervisor*={"*"}>}Units#)```
Learning never stops.
6 Replies
Master II
```Total Cartons = Count (Total <Week> {<Supervisor={"*"}>}Distinct case#)

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

Try the above

Learning never stops.
Creator II
Author

Thanks for the response Pradosh.

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

Master II
what do you need when supervisor is selected ?
Learning never stops.
Creator II
Author

The total sum of carton/pieces for that supervisor.

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

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

Thank you, that works!

Community Browser