topic How to include Filter value in NPrinting Report. in Qlik NPrinting

How to include Filter value in NPrinting Report.

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

Hi All,

I have a QV generalized report that includes a wide range of information. I am using Filter to generate specific report on user need. Is there a way to include this Filter value in the NPrinting report?

This will help to indicate the scope of the hard copy report. Any help on this will be highly appreciated.

Regards

Jay.

Re: How to include Filter value in NPrinting Report.

devarasu07 — Fri, 03 Nov 2017 04:08:22 GMT

Hi,

Yes, try to create filter in nprinting and create a ask then apply your filed.

like this

=sum(Sales) >=500

=Sum(Sales)>=2000 and sum(Sales) <=1000

QlikView NPrinting 16 Tutorials - Filters & Cycles

Re: How to include Filter value in NPrinting Report.

jayabedin — Fri, 03 Nov 2017 04:29:37 GMT

Hi Devarasu,

I have Created the Filter and the Task. They are working fine. I want to include the Filter value in the generated report.

ie from the example you mentioned, I want to add a line on the header like:

Sales : >=1000 and <=2000

I am using Nprinting 17.3. How could I do lthis.

Re: How to include Filter value in NPrinting Report.

Lech_Miszkiewicz — Fri, 03 Nov 2017 04:45:28 GMT

Hi Jaynal,

so yeah - giving us a version of NPrinitng changes everything as NPrinting 17 works differently than version 16.

Now this kind of filtering (>= or <=) is not possible straight in NPrinting filter properties. NPrinting 17 filter cannot return range values but single value.... more than this - this kind of filtering (the one you have suggested in your comment) is not as straight forward as you think as it relies mainly on measure (not on dimension).

If you want to filter particular dimension based on values related to it you have to preaggregate those values in load script as an additional field and then apply the filter on this aggregate or even more rather on top of it flag records which are meeting required criteria as say "1" and apply filter in NPrinting ion flag = 1.

regards

Lech

Re: How to include Filter value in NPrinting Report.

devarasu07 — Fri, 03 Nov 2017 04:48:56 GMT

HI,

At this time, NPrinting 17 filters can only return a single value, not an array like is possible in NPrinting 16.

for more details check this article,

Advanced Search filters in NPrinting 17.5

Support team said it's on the roadmap so try to test with Sep'17 or Nov'17 batch file and it's there raise ticket with qlik support. thanks

close this thread

Regards,

Deva

Re: How to include Filter value in NPrinting Report.

jayabedin — Fri, 03 Nov 2017 05:10:30 GMT

Thanks Deva,

Is this possible to include a single value when my filter is with one value. ie Sales >= 1000

I can add Sales >= as text. Now need to pass 1000 which is the value in filter. This will be result as Sales >= 1000.

Regards

Jay.

Re: How to include Filter value in NPrinting Report.

devarasu07 — Fri, 03 Nov 2017 05:33:26 GMT

Hi Jay,

my side i have only Nprinting 16.3 version and i'v not tested. just do simple test your side
based on @Stephen Jasionowski post said greater than or lesser than condition won't work. (i.e <,>, <=,>= all this kind of filter won't supported in NPrinting 17 version) lets wait for the bug fix/enhanced version of batch release.

for temp. solution, in your qlikview/sense - u can you apply that filter into chart object and call it via nprinting then should work for now.

Advanced Search filters in NPrinting 17.5

Thanks

Deva

Re: How to include Filter value in NPrinting Report.

Ruggero_Piccoli — Fri, 03 Nov 2017 14:05:19 GMT

Hi,

Create a new Formula in your template
Add the Qlik Formula =GetCurrentSelections(). If necessary add some options. Refer to GetCurrentSelections ‒ QlikView.
Drag and drop the formula into the template
Run a Preview. It will contain the list of all applied filters.

Best Regards,

Ruggero

---------------------------------------------

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

Re: How to include Filter value in NPrinting Report.

wonkymeister — Tue, 24 Apr 2018 15:28:16 GMT

so simple yet perfect.

cheers Ruggero, i was stuck with this one!

Re: How to include Filter value in NPrinting Report.

Ruggero_Piccoli — Thu, 26 Apr 2018 08:41:20 GMT

Great!

Please mark the correct answer to help other readers.

Best,

Ruggero

Re: How to include Filter value in NPrinting Report.

chaper — Mon, 28 Oct 2019 13:10:15 GMT

@Ruggero_Piccoli I tried same with excel report. I am getting as 'Field= 8 out of 15' instead of 'Field=1;2;3 :4:5:6:7:8' ? I am using Nprinting 16.4. Tried as formula and also variable.No luck .Is there any limit on how many values it can dispaly from current selections of a field?

Thanks,

Chai

Re: How to include Filter value in NPrinting Report.

chaper — Thu, 24 Oct 2019 16:22:49 GMT

By default getcurrentselections() will show 6 values above 6 it instead of values it will show as 7 of total records of that field.Solution as suggested in below link to add 4th aparameter which refers to the maximum number of field values to be individually listed.

https://community.qlik.com/t5/Qlik-NPrinting-Discussions/Show-Current-Selections-of-multiple-values-from-a-field-not/m-p/1639556#M26625

Re: How to include Filter value in NPrinting Report.

Ruggero_Piccoli — Mon, 28 Oct 2019 09:16:12 GMT

Hi,

Refer to the GetCurrentSelections() documentation at https://help.qlik.com/en-US/sense/September2019/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/FieldFunctions/getcurrentselections.htm. You can change this behaviour by adding the max_values option.

Best Regards,

Ruggero