topic Re: Filters in Nprinting in Qlik NPrinting

Filters in Nprinting

woutermak — Mon, 19 Dec 2016 08:03:00 GMT

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

Re: Filters in Nprinting

lironbaram — Mon, 19 Dec 2016 09:08:25 GMT

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

Re: Filters in Nprinting

woutermak — Mon, 19 Dec 2016 16:08:03 GMT

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

Re: Filters in Nprinting

Stephen_Jasionowski — Mon, 19 Dec 2016 16:17:37 GMT

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.

Re: Filters in Nprinting

woutermak — Thu, 29 Dec 2016 10:07:14 GMT

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.

Re: Filters in Nprinting

Daniel_Jenkins — Fri, 30 Dec 2016 01:19:15 GMT

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.

Re: Filters in Nprinting

Derek_Dang — Fri, 10 Jan 2020 07:00:16 GMT

Hi, I am looking for the approach for the same request. Shall we use single one filter to achieve user = {user}?

If the filters is necessary for each person, suppose we should have 1000 filters for 1000 users. 😞

thanks,

Derek

Re: Filters in Nprinting

monaali602 — Thu, 20 Jan 2022 04:47:04 GMT

Hi,

were you able to add something like user = {user} in a filter to generate a report for each user

Re: Filters in Nprinting

Lech_Miszkiewicz — Thu, 20 Jan 2022 06:40:37 GMT

HI @monaali602

Such thing does not exist. i suggest to study help document to understand how NPrinting works:

https://help.qlik.com/en-US/nprinting/May2021/Content/NPrinting/DeployingQVNprinting/Import-Users-Filters.htm

You can also keep on browsing community as this topic was discussed many times.

cheers

Lech