When a filter results in no records

[NW1965]

Hi Folks

I have a workforce/recruitment report that is scheduled to run every night and is sent to 4000 hiring managers in the company, each manager gets the same email and should get an attachment which is an excel file containing the open roles for that manager.

My problem......

We often have in those 4000 hiring managers a number of managers who do not currently have any open roles and right now they get the standard email telling them a report is attached, followed by an error message saying some reports failed to generate.

Is there any way to stop this?

[Shubham_Deshmukh]

You can maintain one flag in database of open roles and closed roles and put that filter in load script of Qlikview

[NW1965]

I assume you mean that I could keep a Count of Open Roles per hiring manager.

That would be ok for me to do, but what do I then do with that count to make sure that someone with no open roles does not get an email?

[Shubham_Deshmukh]

Ya, that could be the one case like if you are getting count of opening per manager then just check that count in script or I have no idea about Nprinting but there should provision to put condition of fields where >0 or not.

[Ruggero_Piccoli]

Hi,

Did you tested the use of Conditions https://help.qlik.com/en-US/nprinting/February2019/Content/NPrinting/ReportsDevelopment/Conditions.h...?

For example you could create a table with the recruiters that have at least an open selection and use it in a "has values" condition applied to the report.

Best REgards,

Ruggero