topic Re: Exclude values from filter in Qlik NPrinting

Exclude values from filter

deborahs — Mon, 23 Sep 2019 19:23:29 GMT

Hello!! I'm working on an NPrinting Request and I'm stuck at a point where I want to add a filter to my report but the value inside should be excluded. I have seen a sample output where in the filter, it shows that the value is NOT included.

Does anyone know how can I get this filter to work on Nprinting?

I've attached a sample picture for reference, I'm trying to get the "NOT ECDF" part in my filter working, I do not know how to exclude values.

Re: Exclude values from filter

Lech_Miszkiewicz — Mon, 03 Jun 2019 23:50:09 GMT

Hi,

Short answer is: t his feature is currently not available in NPrinting 17 and higher.

You cannot exclude values in NPrinting filter, you can only apply filter.

So if you want to have inverted logic, create it in Qlik load script by creating an additional column like:

If(Not Match(entity_code,'ECDF','ECDIF','ECLDIF','ELDF','ECDLP'),1,0) as Exclude_Flag

and then use it in NPrinting filter like:

Field: Exclude_Flag

Numerical Value Is: 1

That is the simplest solution currently

Re: Exclude values from filter

deborahs — Tue, 04 Jun 2019 14:25:15 GMT

Thank you sir, I shall try this out!

My alternative solution was creating bookmarks and then just taking each as a report without any Nprinting filters.

Re: Exclude values from filter

Lech_Miszkiewicz — Tue, 04 Jun 2019 22:11:04 GMT

Hi,

your alternative with bookmarks.... I do not understand how it would work?

How would you apply bookmarks? NPrinting 17 and above does not have this functionality yet

Re: Exclude values from filter

deborahs — Wed, 12 Jun 2019 14:40:14 GMT

My colleague suggested that I try making bookmarks of the filters I want for individual tables and then pass the bookmark as a filter in NPrinting or something like that. But even he didn't know that this feature has been discontinued after Nprint '11 or '16. So i had to add all the filters except for the one i wanted to exclude (doing it the long way) and pass that as a filter in nprint! Thank you all for your help!