Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for
Did you mean:
Creator II

## Count If Sum Is...

Hi,

I would like to ask how to create a set analysis that can test if the Sum of a certain field is met before it will be included on the count.

I have this sample but I cannot get a good result:

=COUNT({1<KPI_ForProj={1}, nAlloc >= {'100'}>} [Name])

Just to explain some of these variables:

KPI_ForProj -> From script which gets the current month

nAlloc -> Numeric Field which consists of numbers. (100 is the target)

Name -> The person who got the nAlloc of 100

Required:

Get the sum of nAlloc per Name, if the nAlloc is equal of more than 100. It will be counted.

I hope I give my problem clear. Thanks!

I just need a set analysis because mine is not working.

THANKS!

1 Solution

Accepted Solutions
MVP

May be this?

=COUNT({1<KPI_ForProj={1}, nAlloc = {'>=100'}>} [Name])

5 Replies
MVP

May be this?

=COUNT({1<KPI_ForProj={1}, nAlloc = {'>=100'}>} [Name])

Creator II
Author

Hi Tresesco,

Thanks! I will try it out...

If its not a burden. can you teach me how you come up with that?

or explain how it works like that. I'm not really good at set analysis.

MVP

There would be many very good resources to learn from. You can search this community for the same to get links like:

A Primer on Set Analysis

Re: Learning Set Analysis from Scratch

Creator II
Author

Wow! That's great!

By the way. Just to check if my idea is right. If ever I need nAlloc lower than 30 does my set analysis would be like this?

=COUNT({1<KPI_ForProj={1}, nAlloc = {'<30'}>} [Name])

Specialist

Yes it will work.

Regards,

Mayank

Community Browser