Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Eagleblue
Contributor
Contributor
‎2023-08-30 08:14 AM

Count number of projects by Manager that is NOT funded

I have an excel sheet that has multiple columns in it, but I am trying to get QLIK to count the number of projects that manager has that is NOT funded.  They usually show up on the excel sheet as a blank cell.  The only time the cell is filled out is if the project is funded.   I can easily count the funded ones, I just can't figure out how to count the projects without a value in the cell.  I can't add to the excel file.  It is automatically generated by a system that only has those values.

Labels (3)
Labels
339 Views
0 Likes
2 Replies
Eagleblue
Contributor
Contributor
‎2023-08-30 08:26 AM
Author

Here's an example of what I would be looking at.  Counting how many projects that each Project Manager has that is NOT funded.

Preview file
10 KB
335 Views
0 Likes
MK_QSL
MVP
MVP
‎2023-08-30 08:34 AM

Try this

COUNT(DISTINCT {<[Project Name] = {"=Len(Funded)=0"}>}[Project Name])

331 Views
0 Likes