Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
.png "Former Employee"){kind=icon}
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-c...
- 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:
