Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
brettaustin
Contributor III
Contributor III

AGGR Sum Function does not display for each Row

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.  

Deptlvl2Deptlvl4RegionRepsGrand TotalT/F
BuildDistributionAP237False
BuildDistributionEU3037True
BuildDistributionNA537False

 

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)

Deptlvl2Deptlvl4RegionRepsGrant TotalT/F
BuildDistributionAP237FALSE
BuildDistributionEU30-FALSE
BuildDistributionNA5-FALSE

 

 

Labels (3)
1 Solution

Accepted Solutions
edwin
Master II
Master II

add a nodistinct to the aggr:

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

 

edwin_0-1603760957341.png

 

View solution in original post

2 Replies
edwin
Master II
Master II

add a nodistinct to the aggr:

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

 

edwin_0-1603760957341.png

 

brettaustin
Contributor III
Contributor III
Author

Thank you Edwin!