Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

woutermak
Contributor III

Filters in Nprinting

Hi All,

I have the following case:
A data sheet with data linked per sale employee.
I want to use Nprinting to send every month a report to each sales person.

So person A, may only see his own results in his report.
Person B may only see his own results in his report.
And so on

I have to use filters for this. But is there a possibility to use a loop or something in filters? Or do I have to create for each user a filter?

I use nPrinting 17.2

Please let me know if you have any ideas.
Regards,
Wouter

Tags (1)
1 Solution

Accepted Solutions
Employee
Employee

Re: Filters in Nprinting

Wouter - if the users have been imported with associated filters, you only need one publish task.

Simply add all the users (or create a group for them and then add the group to make things easier) along with the reports you want distributed to them.

NPrinting will then go thru each user, apply filters to the report data, create the report and move on to the next user.

5 Replies
lironbaram
Honored Contributor II

Re: Filters in Nprinting

hi

your best approach will be to assign each user the relevant filter

(you can do a batch reload of users using this method

Importing users with filters and groups ‒ Qlik NPrinting )

with this approach you'll only have one template of the report

furthermore in future reports you'll be assured that the users will only get their relevant data only

woutermak
Contributor III

Re: Filters in Nprinting

Hi Thanks,

But I have know all my users imported.
For example user ABC with filter ABC. (user name linke ABC). Everything is linked to my app.

Do I still need to create a publish task per user? And use the created filter rules?
Regards,
Wouter

Employee
Employee

Re: Filters in Nprinting

Wouter - if the users have been imported with associated filters, you only need one publish task.

Simply add all the users (or create a group for them and then add the group to make things easier) along with the reports you want distributed to them.

NPrinting will then go thru each user, apply filters to the report data, create the report and move on to the next user.

woutermak
Contributor III

Re: Filters in Nprinting

Thanks,

is it also possible to create one filter for every employee? You explained that Nprinting go thru each user. Is something possible like this: user={user}.
Otherwise I have to create a filter per employee with something like user={username} per user.

Employee
Employee

Re: Filters in Nprinting

Hi Wouter,

You need to create a filter per employee (user).

If you have many users, normally (as long as there is a fixed pattern) you should be able to use Excel functions or QlikView Calculated Dimensions to parse existing fields to create e-mail addresses and/or filter definitions.

HTH - Daniel.

Community Browser