Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
haneeshmarella
Contributor II

Aggregation Help

WeekSupervisorAssociateTotal CartonsTotal Pieces
02/04/2019 - 02/10/2019AAAA1,1237,701
02/04/2019 - 02/10/2019AAAB167758
02/04/2019 - 02/10/2019AAAC1,2089,369
02/04/2019 - 02/10/2019 D1,2655,345
02/04/2019 - 02/10/2019BBBE1,0195,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

WeekTotal CartonsTotal Pieces
02/04/2019 - 02/10/20193,51722,955

 

Any help is highly appreciated!

Labels (4)
1 Solution

Accepted Solutions
pradosh_thakur
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
pradosh_thakur
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.
haneeshmarella
Contributor II

Re: Aggregation Help

Thanks for the response Pradosh.

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

pradosh_thakur
Honored Contributor II

Re: Aggregation Help

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

Re: Aggregation Help

The total sum of carton/pieces for that supervisor.

pradosh_thakur
Honored Contributor II

Re: Aggregation Help

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

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

Re: Aggregation Help

Thank you, that works!