topic Re: Nprinting create a dynamic filter for report in Qlik NPrinting

Nprinting create a dynamic filter for report

skzwane01 — Tue, 22 Sep 2020 10:54:45 GMT

Good Day,

I have created a report that must be filtered based on the Supervisor ID. In my data set I currently have over 400 supervisor ID's. I want to distribute the report for each individual supervisor. My concern is that the only was I can think of achieving is creating 400 Filters and 400 tasks.

Is there a way to create a condition or something similar which will dynamically distribute the report without me manually creating 400 filters and 400 tasks ? The other issue with the manual filter is that I wont be able to cater for removed/added supervisors.

Your assistance is highly appreciated.

Kind Regards,

Re: Nprinting create a dynamic filter for report

Ruggero_Piccoli — Tue, 22 Sep 2020 13:31:56 GMT

Hi,

You need to create 400 filters, one for each supervisor, and associate each filter to its related supervisor. Than create a single publish task, not 400, add the supervisors as user and distribute the reports as you prefer, for example via email. Each supervisor will receive a filtered report.

Filters and supervisors can be created manually but also imported from an Excel file (refer to https://help.qlik.com/en-US/nprinting/September2020/Content/NPrinting/DeployingQVNprinting/Import-Users-Filters.htm) or via APIs (to create a filter https://help.qlik.com/en-US/nprinting/September2020/APIs/NP+API/index.html?page=21 to create a user https://help.qlik.com/en-US/nprinting/September2020/APIs/NP+API/index.html?page=64).

Instead of adding directly all supervisors into a publish task (https://help.qlik.com/en-US/nprinting/September2020/Content/NPrinting/DistributionSchedulesAutomation/Distribute-User-Specific.htm) I suggest you to use groups so when a new supervisor arrives you will need only to add it to the related groups without adding it to all publish tasks.

Best Regards,

Ruggero

Re: Nprinting create a dynamic filter for report

skzwane01 — Thu, 24 Sep 2020 18:10:51 GMT

Hi Rugerro,

Thank you for the response.

So basically the report will not be sent to the individual supervisor however will be distributed to a folder and the report will be filtered based on the Supervisor field in the data.

So basically if we have 100 stores for example and we want to generate a report per store and save the reports in a location with the store name on the report name how would we achieve that? Please note we are not sending the report but distributing to a folder - 1 folder.

Re: Nprinting create a dynamic filter for report

Lech_Miszkiewicz — Thu, 24 Sep 2020 21:13:23 GMT

Ruggero's approach is still needed but instead of email use folder destination with user based folders and subfolders. More here https://help.qlik.com/en-US/nprinting/September2020/Content/NPrinting/AdministeringQVNprinting/Folder-destination.htm#anchor-1

User Folders and Subfolder can be setup during user import via excel.