Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
FLASH SALE: Save $500! Use code FLASH2026 at checkout until Feb 14th at 11:59PM ET. Register Now!
cancel
Showing results for 
Search instead for 
Did you mean: 
ing_jesus_lopez
Partner - Contributor II
Partner - Contributor II

Issue with Filters Nprinting

Hello,

I created a report in nprinting and when edit this report works fine, but when i add an static filter for example year, the objects are visualizated empty.

1.png2.png3.png4.png5.png

20 Replies
Ruggero_Piccoli
Support
Support

Hi,

I agree with Daniel:

  1. create a local connection to your .qvw
  2. create a Filter with Value is: Canada
  3. create a filter with Numeric Value Is: 2013
  4. create an Excel template
  5. apply the two filters to the Excel template so they are used during report preview
  6. add the Formula called Filters = GetCurrentSelections() in the template
  7. add some objects as images
  8. run a preview

customer excel filter.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.