topic Re: Aggregation Help in QlikView

Aggregation Help

haneeshmarella — Sat, 16 Nov 2024 04:30:16 GMT

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!

Re: Aggregation Help

pradosh_thakur — Sat, 09 Feb 2019 06:56:28 GMT

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

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

Try the above

Re: Aggregation Help

haneeshmarella — Sat, 09 Feb 2019 07:07:17 GMT

Thanks for the response Pradosh.

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

Re: Aggregation Help

pradosh_thakur — Sat, 09 Feb 2019 07:10:50 GMT

what do you need when supervisor is selected ?

Re: Aggregation Help

haneeshmarella — Sat, 09 Feb 2019 07:11:54 GMT

The total sum of carton/pieces for that supervisor.

Re: Aggregation Help

pradosh_thakur — Sat, 09 Feb 2019 07:16:25 GMT

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

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

Re: Aggregation Help

haneeshmarella — Sat, 09 Feb 2019 07:21:03 GMT

Thank you, that works!