Hi I am new to nPrinting and Qlikview. I have checked youtube videos and read the KB articles on filters but I haven't been able to get my filters to work.
Here's what I am trying to achieve:
In nPrinting, I have a scheduled report which uses a Qlikview document called Service Desk SLA report. There are 2 fields in the Qlikview document called
Date Last Updated
I need to apply filters so the report only gets sent out when 'Date Last Updated' is older than 2 days from today (ie if Today is 14/04/2014, then anything older than 12/04/2014) AND 'status' is NOT 'Closed'
I've created 2 filters:
1. In the value field I've entered:
2. In the value field I've entered:
But these don't seem to work. I get the report with all the calls and no filters seem to be applied.
I have a feeling the syntax of my filter values is wrong. Can you please tell me how to do this correctly?
You are correct that when reports get produced with all data, it is usually an indication that the filters have not worked.
I would probably approach this issue in a slightly different way; How are you using your Recipient list ?
I would have QlikView write a record to a .csv when the requirements are met. This record would contain Recipient information which you can import into NPrinting.
You would then have several tasks scheduled into NPrinting, the first would be to import the recipient list into a Report group. The second would be to run the report against the recipient list. Obviously, if there are no recipients in a Recipient group, no reports would be produced.
You would then have to make the decision whether to send the output to the user by email or to a folder. And also decide whether to delete the recipient list in NPrinting after every use (recommended).
NPrinting allows tree kind of filters: field filters, variable filters and bookmark filters.
Field filters allows you to add static values (such as 2012 for a filter on the year field) or formulas based on expressions in Qlikview syntax.
The limitation is that any expression to be passed by NPrinting to QlikView for evaluation must return a unique value compatible with the selected field.
For instance, "year(now())" returns a unique integer value compatible with the field Year. As opposite "year>2010" returns a unique value but it's a boolean, true or false, and it's not compatible with the Year field that is an integer.
Also ">year(now())" and "2014>year(now())" are incorrect.
If you want to use more complex logic, you need to create a bookmark in QlikView and create an NPrinting filter based on that bookmark.
Can you explain me how you would do this: "You would then have several tasks scheduled into NPrinting, the first would be to import the recipient list into a Report group. The second would be to run the report against the recipient list. Obviously, if there are no recipients in a Recipient group, no reports would be produced."
1. I have a task that imports the recipients from a file into NPrinting. How do I import the recipients to a group?
2. Can I set filters at the group level? If so how do I do that?
As of now am manually adding the user to the group and running my report using that group. It would be really great and save on lot of time if the task would add the user to the group directly.
2. Filters cannot be associated to groups. But you can associate filters to recipients, recipients to groups, then use groups into tasks. When importing new recipients, NPrinting can associate them automatically (if you want) to specific groups. In this way new recipients will receive reports automatically.