Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

jayabedin
New Contributor III

How to include Filter value in NPrinting Report.

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.

1 Solution

Accepted Solutions
Employee
Employee

Re: How to include Filter value in NPrinting Report.

Hi,

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

GetCurrentSelections.png

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.



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 with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.
9 Replies
devarasu07
Honored Contributor II

Re: How to include Filter value in NPrinting Report.

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 &amp; Cycles

1.JPG

2.jpg

jayabedin
New Contributor III

Re: How to include Filter value in NPrinting Report.

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.

Lech_Miszkiewicz
Honored Contributor III

Re: How to include Filter value in NPrinting Report.

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

cheers Lech
When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution.
Please LIKE threads if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem.
devarasu07
Honored Contributor II

Re: How to include Filter value in NPrinting Report.

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

jayabedin
New Contributor III

Re: How to include Filter value in NPrinting Report.

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.

devarasu07
Honored Contributor II

Re: How to include Filter value in NPrinting Report.

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

Employee
Employee

Re: How to include Filter value in NPrinting Report.

Hi,

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

GetCurrentSelections.png

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.



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 with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.
wonkymeister
Contributor

Re: How to include Filter value in NPrinting Report.

so simple yet perfect.

cheers Ruggero, i was stuck with this one!

Employee
Employee

Re: How to include Filter value in NPrinting Report.

Great!

Please mark the correct answer to help other readers.

Best,

Ruggero



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 with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.
Community Browser