Qlik NPrinting: Unsupported QlikView Document items, System Configurations and other limitations
Article Number: 000026081 | Last Modified: 2020/04/28
Qlik NPrinting: Unsupported QlikView / Qlik Sense Document items, System Configurations and other limitations
Below QlikView document items are NOT supported in NPrinting 16 or NPrinting 17+ platforms. Please remove these items below from the QlikView document (.qvw) before using with NPrinting Connections. Please note that a successful reload of the Connection metadata does not indicate the objects in the source .qvw file will not interfere with successful report generation while previewing or running a Publish Task.
Note: Alternate states, sheet & document triggers, 'Always one selected' list and multi-box properties are the most commonly found causes for connection issues and reporting problems and any other unexpected results.
Alternate states ( in QlikView QVW and Qlik Sense QVF as mentioned in release notes )
Trigger - both sheet, document and any 'actions' triggers within text boxes objects
List box and Multibox which contains property 'always one selected'
AND-mode (Calculated) fields in filters/cycles/levels/pages etc
Buttons that contain 'actions' work as triggers
Containers within a container (also, move objects out of containers for best NPrinting reporting experience - NP reports can only generate output for the selected container object).
QlikView reports are supported, but only for Entity reports. Other report formats are not showing them in the list of the available objects. You can use QlikView reports (RP objects) only to create Qlik Entity reports in NPrinting, but you cannot import them on Office, HTML or PixelPerfect reports. In Office, HTML or PixelPerfect, you can re-create the same layout of the QV report in the template by importing the single objects one by one.
Additionally here are unsupported QV items with respect to On Demand reporting:
Variable selections used from Input buttons as triggers to select data
!Directly selectible dimension values can only be used with On-Demand reporting
NPrinting On Demand reports that contain connections to multiple (Multidoc) QVW's
Hidden tab the nprinting filter
Other unsupported items and configurations/limitations to be aware of:
It is not possible to use NPrinting tags inside Microsoft Excel, Powerpoint, Word headers and footers
Formula that evaluate the value of an array may not be used with NPrinting and NPrinting filters. The use of these formula with result in " - " empty set. Use selectible dimension values or static or supported dynamic filters. See https://help.qlik.com/en-US/nprinting/November2018/Content/NPrinting/ExcelReports/Formulas.htm for NPrinting 17/18 and higher and https://community.qlik.com/docs/DOC-14576 for NP 16.
NOTE: From June 2019 release, you may use Advanced Search filters to achieve this requirement
Charts that require selections due to conditional expressions/dimensions in order to render data into the chart
Document Alerts (ALXX type objects, configured under QV Desktop > Tools > Alerts
The use of '=' (equals sign) in a QVW chart (et al) as a separator will cause QVW sorting not to work as expected. The NPrinting report output will not produce the newly sorted chart values
MS and other 3rd party addons to MS office: ie: Microsoft Power Pivot and other MS addons other 3rd party addons are not supported
Merged Cells in NPrinting Excel Report Templates. These will cause reporting failures or unexpected reporting results
Merged cells are now supported from April 2019 release and later versions of NPrinting (See April 2019 release notes. Fixed as per OP-5545)
!Any of these items above have the potential to cause failures in NP Designer report preview, verification and generation of NPrinting Connections as well as NPrinting Publish or On-Demand Task execution*
This will remain as NPrinting functionality for the foreseeable future. Although these are on the long term R&D road map (2 or more years out) there will be no near term solution within the software to manage these items. The workaround mentioned in the resolution section below needs to be used in the interim
Until Unsupported Items are removed from the QVW, you will continue to encounter unpredictable reporting results including failed report generation or incorrect report output
The NPrinting connection verification tool does not check for unsupported items
NPrinting 16 is not compatible with NT security. NTNAME, NTDOMAINSID and NTSID are not supported in Section Access