Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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

 

 

1 Solution

Accepted Solutions
Highlighted
Specialist
Specialist

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
Highlighted
Specialist
Specialist

add a nodistinct to the aggr:

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

 

edwin_0-1603760957341.png

 

View solution in original post

Highlighted
Contributor III
Contributor III

Thank you Edwin!