Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
IMPORTANT: Upcoming LEF Database Maintenance, Oct. 3rd - SEE DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

When a filter results in no records

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?

Labels (1)
4 Replies
Highlighted
Specialist
Specialist

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

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?

 

Highlighted
Specialist
Specialist

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.
Highlighted
Employee
Employee

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



Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.