Qlik NPrinting: Unsupported QlikView Document items, System Configurations and other limitations

Yoichi_Hirotake — Wed, 06 Oct 2021 15:52:18 GMT

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).
Any third party extension objects
Alternate identities: ie: qvp://nprinting_svc@qlikviewserver1/qwvs/salesdemo.qvw.
bundled qmem packages.
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 and QS items with respect to On Demand reporting:

Variable selections used from Input buttons as triggers to select data
Input Boxes
Calculated Dimensions used as pages and or levels

! 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:

Check for Macros in the QVW. You need to enable macros while logged on as the NPrinting service account on the NPrinting server and or NP engine computer.

Illegal Operation: marked for deletion: message in the NPrinting Logs: For resolution see NPrinting error: Illegal operation attempted on a registry key that has been marked for deletion
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/Content/NPrinting/ReportsDevelopment/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
Unsupported Configurations: https://help.qlik.com/en-US/nprinting/Content/NPrinting/DeployingQVNprinting/Supported-unsupported-configurations.htm
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 can cause reporting failures or unexpected reporting results

! 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*

NOTE:

This will remain as NPrinting functionality for the foreseeable future. Although these are on the long term R&D road map 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
Connection pseudo-URLs in the format qvp://[[username][@]]hostname[:port|;protocol]/docname in NPrinting connections are NOT supported. More information on Connection-pseudo URLs: http://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Connect_to_Server.htm

Resolution:

Copy the primary QVW

Remove the items mentioned in the article description
Save the copy with NP in the title ie: myqwvNP.qvw
(Option): Binary load the new NP reporting qvw to the original qvw
Use the copied QVW for reporting purposes in the NP connection

Next:

Open Task Manager
End task any QV.exe's on the QlikView and NPrinting server associated with the NP service account (Assuming QVP connections. If Local connections do this step only on the NP server)
Stop and restart all NP services
Reload your NPrinting metadata connection (NPrinting 19 or higher)

NOTE: Additionally, please avoid/mitigate the use of any of the known limitations defined in the description section of this article

For NPrinting And Qlik Sense unsupported items, see the following article:

article Qlik NPrinting: Unsupported QlikView Document items, System Configurations and other limitations in Official Support Articles

Qlik NPrinting: Unsupported QlikView Document items, System Configurations and other limitations

Qlik NPrinting: Unsupported QlikView / Qlik Sense Document items, System Configurations and other limitations

Resolution: