Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
cliff_clayman
Creator II
Creator II

How to use several different filters and variables within one PowerPoint

I have a general type question for creating a PowerPoint file using NPrinting.  I am using version 16.5.0.0.  I have a QVW with many different fields and variables.  My end users want a single PowerPoint presentation that contains several graphs and charts that are based on a variety of selection criteria.  What is the best way to create the slides when my filters will not necessarily be the same from slide to slide?

1 Solution

Accepted Solutions
Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

There is no single answer to your question as it is dependent on filters you will be using.

If the filters are coming from the same field (for example  country) you might be able to use page tag to minimize work on your template

Otherwise i would use object filters (where each object on the slide can have individual filter)

details here:

https://help.qlik.com/en-US/nprinting/June2018/Content/ReportsDevelopment/Static-dynamic-filters.htm

Applying a filter to an object

Object filters are useful when you want to filter a specific table or image. For example, if you have a report with no filters, but you want to add a table that only displays last year's sales, you would apply an object filter.

Objects can only have a single filter. If you need to add a complex filter to an object, you must create a unique filter before you edit the report template.

Do the following:

  1. On the Reports screen, click on your report.
  2. Click the Edit template button to open the Qlik NPrinting Designer template editor.
  3. On the left pane, right-click the type of object you would like to filter, and select Add objects.You can filter tables and images.
  4. A new window will open. Select the object you would like to filter, and click OK.
  5. Drag your new object from the left pane to your report template.
  6. On the Properties pane, go to Filters and click the ¥.
  7. A new window will open. Select the filter you would like to use, and click OK

.If you accidentally pick the wrong filter, you can click the eraser icon next to the ¥ to remove all filters from an object.

  1. Click Preview.Your report object will only show information related to the filter.


cheers


Lech

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

When applicable please mark the appropriate replies as CORRECT https://community.qlik.com/docs/DOC-14806. 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.


cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.

View solution in original post

3 Replies
Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

There is no single answer to your question as it is dependent on filters you will be using.

If the filters are coming from the same field (for example  country) you might be able to use page tag to minimize work on your template

Otherwise i would use object filters (where each object on the slide can have individual filter)

details here:

https://help.qlik.com/en-US/nprinting/June2018/Content/ReportsDevelopment/Static-dynamic-filters.htm

Applying a filter to an object

Object filters are useful when you want to filter a specific table or image. For example, if you have a report with no filters, but you want to add a table that only displays last year's sales, you would apply an object filter.

Objects can only have a single filter. If you need to add a complex filter to an object, you must create a unique filter before you edit the report template.

Do the following:

  1. On the Reports screen, click on your report.
  2. Click the Edit template button to open the Qlik NPrinting Designer template editor.
  3. On the left pane, right-click the type of object you would like to filter, and select Add objects.You can filter tables and images.
  4. A new window will open. Select the object you would like to filter, and click OK.
  5. Drag your new object from the left pane to your report template.
  6. On the Properties pane, go to Filters and click the ¥.
  7. A new window will open. Select the filter you would like to use, and click OK

.If you accidentally pick the wrong filter, you can click the eraser icon next to the ¥ to remove all filters from an object.

  1. Click Preview.Your report object will only show information related to the filter.


cheers


Lech

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

When applicable please mark the appropriate replies as CORRECT https://community.qlik.com/docs/DOC-14806. 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.


cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
balabhaskarqlik

Ruggero_Piccoli
Support
Support

This is the solution. The help is related to Qlik NPrinting 17+ but object filters are available also in Qlik NPrinting 16.



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.