topic Re: Exclude values as filters in Qlik NPrinting

Exclude values as filters

Mon, 04 Apr 2016 15:26:06 GMT

Hi.

is it possible to exclude certain values as fitlers i nprinting? I have an excel document which imports filters and recipients. And if wondering if you could specify excluded values. For example accounts. If I have a client with 20 accounts, is it possible to exclude one of them instead of listing 19 of them?

Br,

Re: Exclude values as filters

Mon, 04 Apr 2016 15:29:05 GMT

In NPrinting 16, you can set the filter parameter to "Select Excluded" which will select all values except those put into the filter.

This feature is missing from NPrinting 17.

Re: Exclude values as filters

Tue, 05 Apr 2016 08:15:38 GMT

Ok nice! Do you know how that would be written in a excel document where I use to import filters and recipients?

Re: Exclude values as filters

Wed, 06 Apr 2016 15:09:33 GMT

There is a list of tutorials which explain the syntax here:

https://community.qlik.com/docs/DOC-14613

these two in particular:

Advanced Filters Syntax on Recipients Import‌

Filter Syntax, Parameters, and Options for Importing Recipients

Best

Aran

Re: Exclude values as filters

khaled_dabbous — Wed, 13 Jun 2018 10:04:30 GMT

Hi Aran,

Is the Select Excluded supported in NPrinting April 2018 release?

Sincere regards,

Khaled