AGGR Sum Function does not display for each Row

brettaustin — Sat, 16 Nov 2024 17:55:00 GMT

Hello Qlik!

I am trying to create an AGGR Summary table of the total representatives located by region by their department where they represent greater than or equal to 50% of the entire organization department.

For Example EU has 30 reps for distribution out of 37 total for the 'Deptlvl4' column.

Deptlvl2	Deptlvl4	Region	Reps	Grand Total	T/F
Build	Distribution	AP	2	37	False
Build	Distribution	EU	30	37	True
Build	Distribution	NA	5	37	False

However I am unable to get Qlik to display/process the data correctly. It will display 'Nulls' for 2 of the 3 rows.

Qlikview Table (see attached for example)

Deptlvl2	Deptlvl4	Region	Reps	Grant Total	T/F
Build	Distribution	AP	2	37	FALSE
Build	Distribution	EU	30	-	FALSE
Build	Distribution	NA	5	-	FALSE

Re: AGGR Sum Function does not display for each Row

edwin — Tue, 27 Oct 2020 01:09:26 GMT

add a nodistinct to the aggr:

Aggr(nodistinct Sum({1<
Deptlvl4 = {"*"}
>}
[Total Reps])
,
Deptlvl4)

Re: AGGR Sum Function does not display for each Row

brettaustin — Tue, 27 Oct 2020 12:13:50 GMT

Thank you Edwin!

topic AGGR Sum Function does not display for each Row in QlikView

AGGR Sum Function does not display for each Row

Re: AGGR Sum Function does not display for each Row

Re: AGGR Sum Function does not display for each Row