Filters in Nprinting

[woutermak]

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

[lironbaram]

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]

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

[Stephen_Jasionowski · Accepted solution]

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]

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.

[Daniel_Jenkins]

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.

[dysjd]

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

[monaali602]

Hi,

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

[Lech_Miszkiewicz]

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

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

cheers

Lech