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.