Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Conditional Count

I am trying to create a KPI. The data is an excel spreadsheet with a list of companies and their corresponding employee count. There are roughly 250 companies in my list of various sizes relevant to employees. How do I display the number of companies that have employee counts over 3,000. Columns are Company and Employees. Any ideas how to do this?

Tags (1)
3 Replies
sunny_talwar
Not applicable

Re: Conditional Count

May be something like this:

Count(DISTINCT {<Company = {"=Count(DISTINCT Employee) > 3000"}>} Company)

You may not be doing a count, but the idea is to add the set analysis to your current expression

{<Company = {"=Count(DISTINCT Employee) > 3000"}>}

Another option could be to use a calculated dimension

Aggr(If(Count(DISTINCT Employee) > 3000, Company), Company)

Not applicable

Re: Conditional Count

Sunny

Thank you for the response

Scott

sunny_talwar
Not applicable

Re: Conditional Count

Is it working? If not, please let us know or else please close this thread down

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny