Qlik NPrinting Filter Rules and Limitations

[Andre_Sostizzo]

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:

Reference: Filters

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

[Gerardo1]

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]

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]

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]

Thank you. I will do it. 

Regards