topic Re: nPrinting Import Recipients via Excel-File in Qlik NPrinting

nPrinting Import Recipients via Excel-File

Markus_QV — Mon, 19 Dec 2016 15:47:03 GMT

Hi,

I need your help, because the documentation of Qlik is not detailed enough.

I want to create 1 Powerpoint presentation which is filled via 2 qvw-Files (2 connections).

I want now create 2 recipients with 2 filter for each connection

(i.e.

User 1 "MK"--> Connection 1 "Sales"--> Filter: Branch= New York

User 1 "MK"--> Connection 2 "Finance"--> Filter: Branch= New York

User 2 "DO"--> Connection 1 "Sales"--> Filter: Branch= Los Angeles

User 2 "DO"--> Connection 2 "Finance"--> Filter: Branch= Los Angeles

)

How does the import file need to look like? Which columns of nPrinting I need to use in which way?

What is the correct syntax for the column "FilterRef" and what is it doing?

Can I write one row with 2 connections (instead of two rows)?

Thx for your help.

Markus

Stephen_Jasionowski — Mon, 19 Dec 2016 16:23:38 GMT

See the Specify the Connection When Creating a New Filter section of this document: Advanced Filters Syntax on Recipients Import

Here is some additional information on filter syntax and parameters: Filter Syntax, Parameters, and Options for Importing Recipients

Markus_QV — Tue, 20 Dec 2016 16:21:20 GMT

Perfect. Thank you. Works.