# New to Qlik Sense

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

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for
Did you mean:
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)

• ### New to Qlik Sense

1 Solution

Accepted Solutions
MVP

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

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

3 Replies
MVP

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

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

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

MVP

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

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

Tags
Community Browser