Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Taylorcc
Contributor III
Contributor III

AGGR Set Analysis

Hello, 

 

How can I change the following to count referral numbers that have a null K10 difference? 

 

COUNT( IF(AGGR($(K10 Difference),OMReferralNumber)<=0 OR AGGR($(K10 Difference),ReferralNumber)>0,1))

 

Thank you

Labels (4)
1 Solution

Accepted Solutions
rubenmarin

Hi, maybe with: COUNT(AGGR(If(IsNull($(K10 Difference)),OMReferralNumber),OMReferralNumber))

Or: Sum(Aggr(If(IsNull($(K10 Difference)),1),OMReferralNumber))

View solution in original post

3 Replies
rubenmarin

Hi, maybe with: COUNT(AGGR(If(IsNull($(K10 Difference)),OMReferralNumber),OMReferralNumber))

Or: Sum(Aggr(If(IsNull($(K10 Difference)),1),OMReferralNumber))

View solution in original post

Taylorcc
Contributor III
Contributor III
Author

Thanks Ruben, 

The first option is working 🙂 How do I convert this to show the referral numbers in a table? 

(I would like just one column with referral numbers, not one column with referral numbers and a second with 1 or 0 if the difference is null)

Thanks again 

rubenmarin

Hi, you can try to create a dimesnion with this:

Aggr(If(IsNull($(K10 Difference)),OMReferralNumber),OMReferralNumber)