topic Re: Nprinting 17 - filter an object in Qlik NPrinting

Nprinting 17 - filter an object

shaybitton — Wed, 25 Sep 2019 18:40:54 GMT

Hi All,

I'm trying to apply filter to an object in Nprinting 17 in an excel\power point\word report but i can't find a way to do it because this option has been removed from the 17 version.

does anyone have an alternative way to do it ?

Thanks in advance

Re: Nprinting 17 - filter an object

Daniel_Jenkins — Mon, 18 Jul 2016 21:46:28 GMT

Hi Shay,

NPrinting 17.x does have the object level filter option:

HTH - Daniel.

Re: Nprinting 17 - filter an object

Anonymous — Tue, 02 Aug 2016 14:53:43 GMT

Hi, i have the same problem inside the properties of an object there is definitely NO filter

I am using NPrinting 17.1 FR1, also i have defined a filter inside the nprinting admin dashboard.

Please help!!

Re: Nprinting 17 - filter an object

Daniel_Jenkins — Tue, 02 Aug 2016 23:06:45 GMT

Hi Paul,

The PixelPerfect report type that you are using does not have this option and did not have it in earlier versions like NPrinting 16 either, so it has not been removed.

Best,

Daniel.

Re: Nprinting 17 - filter an object

Anonymous — Wed, 03 Aug 2016 06:11:33 GMT

Hi Daniel, but where can i set Filters now?

Re: Nprinting 17 - filter an object

Daniel_Jenkins — Wed, 03 Aug 2016 06:49:22 GMT

Hi Paul,

You can set filters on tasks, users, reports, and (where supported) objects.

Take a look at: https://help.qlik.com/en-US/nprinting/17.1/Content/FiltersCycles/Filters.htm

HTH - Daniel.

Re: Nprinting 17 - filter an object

NZFei — Wed, 12 Oct 2016 01:46:00 GMT

Hi Daniel,

When setting up the dynamic filters in NP17.2 for "Evaluate value", if I input =date('1/06/2016') to search in the "Date" field, it will return the correct result just like the help page explains. However if I input >=date('1/06/2016'), it returns nothing. It looks to me that the "=" is working but ">" or "<" are not. Should I use any special format? How can I build a filter that starts the date from 15/09/2016 to 10/10/2016 in the Date field.

Thanks

Fei

Re: Nprinting 17 - filter an object

Daniel_Jenkins — Wed, 12 Oct 2016 02:04:56 GMT

Hi Fei,

NPrinting 17.x does not (yet) have options to filter based on Variables, Bookmarks and Advanced Search (which is what you are trying to do). At this stage I don't have any information on when (or if, in the case of Advanced Search) these will be implemented.

- Daniel.

Re: Nprinting 17 - filter an object

NZFei — Wed, 12 Oct 2016 21:27:11 GMT

Hi Daniel,

Please see the screenshot below. I added a straight table from a Sense app and I still don't see the filter option in the object property? I am using NP17.2 and it is an Excel template. Have I done anything wrong? Or maybe the filter at object level is only working for table box?

Thanks.

Fei

Re: Nprinting 17 - filter an object

Daniel_Jenkins — Wed, 12 Oct 2016 21:42:57 GMT

Hi Fei,

You have not done anything wrong. It's just that Object Level Filters are only supported for QlikView objects (both Images and Tables). Since you are using Qlik Sense objects, you will need to apply the filter on a higher level - Report level perhaps?

HTH - Daniel.

Re: Nprinting 17 - filter an object

NZFei — Wed, 12 Oct 2016 21:53:22 GMT

Thank you very much Daniel.

Cheers.

Fei

Re: Nprinting 17 - filter an object

Anonymous — Mon, 31 Oct 2016 07:45:01 GMT

Hi Daniel,

First of all thanks for sharing this knowledge. I would like to ask you if you are aware when it will be possible to set filters on object level for Sense apps? In next release 17.3 or later?

Thanks and Regards

Ladislav

Re: Nprinting 17 - filter an object

pablolabbe — Tue, 28 Feb 2017 23:12:05 GMT

Hi Daniel,

Advanced Filter is on my wish list!

Without this feature, we need to do a lot of rework creating objects with custom expressions using set analysis for that filter.

Re: Nprinting 17 - filter an object

coreyhartman — Thu, 25 Jan 2018 22:22:10 GMT

I am also having lots of trouble trying to get around using bookmarks for dynamic date range filters. Extremely frustrating!! I am quite surprised 17 was released without bookmark filters.

I thought Set Analysis was not supported for use with NPrinting? If I could use SA (or, of course, Advanced Filter), my situation would be much less painful. Right now we're playing around with creating custom date fields in the load script that only contain the desired dates, then using them as the first level in a PixelPerfect template. But of course, that messes with the sort, etc. Is there any easier solution?