Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW

Qlik NPrinting Filter Rules and Limitations

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
Andre_Sostizzo
Digital Support
Digital Support

Qlik NPrinting Filter Rules and Limitations

Last Update:

May 26, 2021 5:01:17 AM

Updated By:

Sonja_Bauernfeind

Created date:

Jul 11, 2015 12:08:36 AM

Environment:

Qlik NPrinting 

 

Filter Rules

  • Formulas are evaluated first, in order to have static values to manage.
  • Filters will not necessarily overwrite past selections. There is no strict hierarchy.
  • Each filter will be analyzed in sequence: "task -> user -> report -> object."
  • The values of filter fields at different levels will be intersected.
  • If the intersection gives an empty result, the filter chain will become invalid.
  • There is no limit to how many task, report, object, or users filters you can apply in an app. However, only one object filter can be applied to a single image or table object in the NPrinting template editor.
  • If the application of a filter results in an impossible selection, a specific error is returned: "Cannot apply filter {0} to current document data. Requested fields with evaluates are: {1}",
  • 'Empty Set' Logging errors can be expected if the same dimension is used as a filter value twice in the "task -> user -> report -> object" sequence.
Filter intersection example: city=paris (user filter) and city=seatte (task filter)
Result: "Empty Set" Error logging

*Note that there is one specific flag that allows you to change these behaviors: "Override values". This flag, which is related to specific fields of a filter, allows you to clear the selections on a certain field on a certain level of the chain.

To view other examples of Filter intersections see the reference link below:

ReferenceFilters

Other Important Limitations to note:

  • Tables that have calculated dimensions or null values can be used as levels in the template editor, however it is not supported to place any objects or additional 'nested' levels within them. Error indicating this usage limitation: "ERROR: Cannot expand cycle or level. Cycle expansion produces an empty filter"
  • Qlik Sense On-Demand reports with selections applied on calculated dimensions will fail. This limitation is also specified in the NPrinting product release notes attached to this article.

 

To Ensure the report and report distribution works as expected, check the following:

  • Filter Rules: Ensure the report filters are not intersecting as per the Filter rules above (See reference link above for examples)
  • Nested Levels: Do not add nested levels or other objects within a level that is derived from a Calculated Dimension. Consider moving the calculated dimension to the load script.
  • Formulas/Expressions the evaluate the full set of records:  "1" (Set Analysis Identifier) represents the full set of all the records in the application, irrespective of any selections (NPrinting Filters) made/used. This will interfere with normal NPrinting filtering. Remove this value from your set expression/measure to mitigate filter errors. Using this identifier also results in the "Cycle expansion produces an empty filter" via NPrinting previews and publish task execution
  • Calculated Dimensions with On Demand: The workaround is to move the calculated dimension formula to the load script
Labels (1)
Comments
Gerardo1
Partner - Contributor
Partner - Contributor
  1. Se puede crear en Nprinting filtros con dimensiones calculadas?, es decir, tengo esta expresión en mi app y es un objeto panel de filtrado con el siguiente calculado:

aggr(if(

sum({<Año={'$(=max(Año))'}, ID_TABLA={1,2,3}>}VentaTotSinIva)>0

and

sum({<Año={'$(=max(Año)-1)'}, ID_TABLA={1,2,3}>}VentaTotSinIva) >0,'Mismas', 'NMT'), IDCadenaTienda,

$(vCampos))

 

  1. Es posible generar un filtro en un reporte, pero que este filtro solo afecte a ciertos objetos del reporte?

 

Quedamos atentos a tus comentarios sobre estas dudas.

Sonja_Bauernfeind
Digital Support
Digital Support

Hello @Gerardo1 

I recommend posting your query on the NPrinting forums for better access to the rest of the community: NPrinting Discussions.

All the best,
Sonja 

Gerardo1
Partner - Contributor
Partner - Contributor
  1. Is it possible to generate a filter in a report, but that this filter only affects certain objects in the report?

aggr(if(

sum({<Año={'$(=max(Año))'}, ID_TABLA={1,2,3}>}VentaTotSinIva)>0

and

sum({<Año={'$(=max(Año)-1)'}, ID_TABLA={1,2,3}>}VentaTotSinIva) >0,'Mismas', 'NMT'), IDCadenaTienda,

$(vCampos))

2. It is possible to generate a filter in a report, but that this filter only affects certain objects of the report?

 

Thank you for your support. 

Gerardo1
Partner - Contributor
Partner - Contributor

Thank you. I will do it. 

Regards 

Contributors
Version history
Last update:
‎2021-05-26 05:01 AM
Updated by: