Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
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
Specialist III
Specialist III

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

add a nodistinct to the aggr:

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

 

edwin_0-1603760957341.png

 

View solution in original post

brettaustin
Contributor III
Contributor III
Author

Thank you Edwin!