topic Re: Dynamic value for Username in Qlik NPrinting

Dynamic value for Username

sturmeyp — Wed, 04 May 2022 09:10:20 GMT

Hi All

I'm sure this is possible but having some difficulty in finding a solution.

I have a Qlik Sense app which in this example is showing a list of Salesman names (Firstname, Surname) , and monthly sales values.

I've designed an NPrinting report which I'd now like to distribute via email and be sent to each salesman.
However I need to filter the report so that it only shows data associated with that salesman.
How can I dynamically pass the username in NPrinting when the report is run. (is that possible?)
Or do I have to handle it in the Qlik Sense app?

Any ideas appreciated

Paul

Re: Dynamic value for Username

Ruggero_Piccoli — Wed, 04 May 2022 10:22:09 GMT

Hi,

I suggest you to start by reading the Getting Started chapter of the official Qlik NPrinting help site at https://help.qlik.com/en-US/nprinting/May2021/Content/NPrinting/Introduction/Get-started.htm. You need to create a filter for each user and a publish task to deliver the reports. The whole workflow is explained in detail there.

Best Regards,

Ruggero

Re: Dynamic value for Username

Frank_S — Wed, 04 May 2022 22:28:21 GMT

@sturmeyp

So this is a commonly needed requirement.

To do this:

In your QS or QV app, find the user dimension like userID or useremail
Create NPrinting recipients for each intended email recipient. Creating a new user manually in the NPrinting Web Console
Create a separate NP filter for each NP recipient. Creating a static filter
Add each user filter to each NP user/recipient. Setting user filters
Create a publish task as per Distributing reports by email
Before executing the publish task, make sure to set up your SMTP settings on the NP server (outbound only. no settings for inbound) Configuring SMTP server

Hope this helps...and for more information about working with NPrinting, please feel free to visit Qlik NPrinting Training and Information Resources- Step by Step Help Pages