Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Not applicable

Filtering in nPrinting for a Qlikview report

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

Status

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:

<(Today()-2)

2. In the value field I've entered:

<>'Closed'

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?

thanks

Cameron.

1 Solution

Accepted Solutions
Employee
Employee

Re: Filtering in nPrinting for a Qlikview report

Hi all,

Starting from NPrinting 15.4.0.0 (Feature release) it is possible to configure filters that use "Advanced search"-like formulas.

For more details about this see http://community.vizubi.com/knowledgebase/articles/413836-how-to-use-qlikview-advanced-search-with-n...

Hope this helps.

7 Replies
ngulliver
Valued Contributor III

Re: Filtering in nPrinting for a Qlikview report

Hi, Cameron.

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).

Hope that helps,

Neil

Employee
Employee

Re: Filtering in nPrinting for a Qlikview report

Dear Cameron,

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.

Here are some links to specific tutorials:

Creating NPrinting Filters Based on Existing QlikView Bookmarks – Customer Feedback for Vizubi

How to Report Sales for the Six Months Previous to This One – Customer Feedback for Vizubi

How to Report Sales for Last Year and This to Date – Customer Feedback for Vizubi

Hope this helps.

Andrea

Not applicable

Re: Filtering in nPrinting for a Qlikview report

Hi Neil,

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.

Any pointers will help.

Thanking you

Preethi

Employee
Employee

Re: Filtering in nPrinting for a Qlikview report

Preethi,

concerning your questions:

1. You can find detailed instructions about recipients import in the Vizubi community (Knowledge Base – Customer Feedback for Vizubi ).

particularly here you can find a tutorial that explains the syntax to use when creating source files for an import:

Filter Syntax, Parameters, and Options for Importing Recipients – Customer Feedback for Vizubi

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.

Hope this helps.

Andrea

Employee
Employee

Re: Filtering in nPrinting for a Qlikview report

Hi all,

Starting from NPrinting 15.4.0.0 (Feature release) it is possible to configure filters that use "Advanced search"-like formulas.

For more details about this see http://community.vizubi.com/knowledgebase/articles/413836-how-to-use-qlikview-advanced-search-with-n...

Hope this helps.

Not applicable

Re: Filtering in nPrinting for a Qlikview report

Hi Andrea,

Your links are not working anymore. Do you please have another links that i can use?

Thanks.


Tatiana

Employee
Employee

Re: Filtering in nPrinting for a Qlikview report

Community Browser