Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
haneeshmarella
Creator II
Creator 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
Master II
Master II

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

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

View solution in original post

6 Replies
pradosh_thakur
Master II
Master II

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

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

Try the above

Learning never stops.
haneeshmarella
Creator II
Creator II
Author

Thanks for the response Pradosh.

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

pradosh_thakur
Master II
Master II

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

The total sum of carton/pieces for that supervisor.

pradosh_thakur
Master II
Master II

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

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

Thank you, that works!