topic Re: NPrinting Filter Exclusion in Qlik NPrinting

NPrinting Filter Exclusion

tomdon14 — Tue, 17 Nov 2020 00:35:58 GMT

Hi all –

I’m struggling with creating a NPrinting filter and hoping you might be able to help. It seems like a fairly straightforward request but not sure how to implement it.

An example data set:

Product City of Sale
Apple Philadelphia
Apple New York
Apple Chicago
Orange Philadelphia
Orange New York
Orange Chicago
Pear Philadelphia
Pear New York
Pear Chicago

For my report, I want to exclude Apples and Pears if they are sold in Philadelphia. Can I create something using the Advanced Search Filter to exclude only those items?

Thanks in advance.

Re: NPrinting Filter Exclusion

Lech_Miszkiewicz — Tue, 17 Nov 2020 02:24:42 GMT

Remember that filters in NPrinting are the same as selections in Qlik Sense. If you wish to apply filters on Product or City fields it will not be possible, so no - there is no way you can apply such filter with this data set.

What you are showing us is a combination of 2 fields which in your case are stored as 2 separate fields. If that is the case you will not be able to apply what you are trying to as selection on one field will be global and exclusion will be applied on all rows where Apples and Pears are.

Solution would be to :

create composite field in your data model, which would be built of those 2 fields.
or use another field (some field from fact table which will uniquely describe combination of Product and city and apply advanced filter on that field) see below example:

Load *, Rand()*1000 as sales Inline [Product, City of Sale Apple, Philadelphia Apple , New York Apple , Chicago Orange, Philadelphia Orange , New York Orange , Chicago Pear, Philadelphia Pear , New York Pear, Chicago ] ;

loading this as a data model you can then apply advanced filter on "sales" field using following Advanced search expression:

=sum({<Product={"*"},[City of Sale]={"*"}>-<Product={'Apple','Pear'},[City of Sale]={'Chicago'}>}sales)>0

regards

Lech

Re: NPrinting Filter Exclusion

tomdon14 — Tue, 17 Nov 2020 13:19:35 GMT

Thank you Lech. Is it possible to create a concatenated field (ie. ApplePhiladelphia) in NPrinting and apply a filter on that field? Thanks again.

Re: NPrinting Filter Exclusion

Ruggero_Piccoli — Tue, 17 Nov 2020 15:47:22 GMT

Hi,

You have to create the field with the load script. Qlik NPrinting cannot create new fields on the source apps.

Best Regards,

Ruggero

Re: NPrinting Filter Exclusion

Lech_Miszkiewicz — Tue, 17 Nov 2020 21:36:10 GMT

That is what I called "composite field" and as I said before it needs to be done in data model (not in NPrintig). Ruggero confirmed the same!

Re: NPrinting Filter Exclusion

tomdon14 — Tue, 17 Nov 2020 21:49:21 GMT

Thank you all. I've been able to identify a unique identifier for each row (RowID) and use that to exclude the items in question. It's not a perfect solution but it looks like it will work.