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: 
Anonymous
Not applicable

AGGR Function

I am trying to create a relative frequency using the AGGR function.  I have a snapshot of the data as it is exported to Excel.

I would like to divide each count by the total count for each product code.  All rows other than a randomly chosen row are showing up as missing.

aggr.png

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

=Count(AcctNum)/Count(Total <ProductCode> AcctNum)

Use Distinct if necessary..

View solution in original post

1 Reply
MK_QSL
MVP
MVP

=Count(AcctNum)/Count(Total <ProductCode> AcctNum)

Use Distinct if necessary..