topic Adding WHERE clause to recipients import in Qlik NPrinting

Adding WHERE clause to recipients import

sspe — Wed, 15 Jul 2015 09:04:04 GMT

Hi,

I'm trying to import some recipients from a SQL server table, but I'm getting stucked on how to limit the number of records to import? I can select the table I want to import from, but this contains a lot of records that I don't want to get into Nprinting so how do I write a "query" or in other ways filter the records I'm importing?

I know I can create a view in my SQL database that only contains the records I want to import, but I can't imagine that there isn't a way to do this query in NPrinting-

Re: Adding WHERE clause to recipients import

Frank_S — Thu, 16 Jul 2015 23:40:29 GMT

NPrinting cannot limit the number of rows imported

I suggest creating a QVW application to import the number of rows that you need imported and import the table object from the new Qlikview recipients document.

See documentation below for details.

How to Import Recipients from QlikView Documents - Features Track – Customer Feedback for Vizubi

Re: Adding WHERE clause to recipients import

sspe — Fri, 17 Jul 2015 06:25:44 GMT

Hi Frank,

Thanks for your answer. That was also what I was ended up concluding. I think I'll just create view that gives me the recipients I need - it was just easier if I could have made that query/selection in NPrinting.