Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
The initial release of Qlik Cloud Tabular Reporting in December was a long awaited capability for many customers. We will continue to expanded the functionality within the broader roadmap.
This post offers a short-term outlook for some improvements in development for the Tabular Reporting capability. Stay tuned to the What's New for official availability notices over the course of Q1'24.
The feedback from customers / partners has been fantastic! Please keep growing the discussion in this forum, sharing your experience and increasing the community knowledge around tabular reporting use cases. Of course, use our Ideation portal to suggestion additional capabilities.
Disclaimer: as with any future looking statements I need to caveat that this post is not a commitment and timing/feature functionality can change. Please continue to work with the official product in hand, documented through help.qlik.com, as the confirm expected functionality.
With Qlik Cloud Native Subscriptions and advanced report composition with Qlik Reporting Service / Qlik Application Automation, we are seeing growth in the adoption of reports based on Qlik Sense Apps. In fact, our experience with Qlik NPrinting tells us that many customers will create Qlik Sense Apps that are tailored by way of sheets and objects for reporting output. It has been identified that the interactive nature of a Qlik Table and Pivot Table would benefit from more style control when transitioning to printing on Qlik Cloud. The Product roadmap will introduce a new Table and Pivot Table in the future that offers better control of style elements and Qlik will continue to refine the transition from interactive mode to report mode with more cloud updates in the future.
In the meantime, some of our Qlik reporting SME’s collaborated to create a theme that offers reports from cloud a more professional table presentation. The attached theme can be deployed to an app that is specific for reporting in Qlik Cloud. It uses an explicit set of attribute definitions to remove interactive elements and clean-up the table for visual reporting. While this theme is not officially supported, the Qlik team will be monitoring releases for any changes to the existing Straight Table and Pivot Table and look to update the theme if needed. If you start to use this theme, please hit "Subscribe" to get notifications, we will update the theme if necessary due to changes in coming releases of Qlik Cloud. We will continue to monitor this community post and theme until a time at which “like” capability is offered with new visualizations on Qlik Cloud.
Looking for NPrinting articles that were created by other users/members? They were moved to their new home here: https://community.qlik.com/t5/Member-Articles/tkb-p/qlik-communityarticles.
They are all broken up by the appropriate label, you can search by a label and subscribe to labels.
Remember official Qlik Support articles for NPrinting can be found here: https://community.qlik.com/t5/Knowledge/tkb-p/qlik-support-knowledge-base
The NPrinting document board has been retired.
[Edited]
Dear All,
Qlik NPrinting May 2021 SR3, or newer, solves this issue and is available for download. Refer to the Release Notes https://community.qlik.com/t5/Release-Notes/Qlik-NPrinting-May-2021-SR3/ta-p/1872634#toc-hId-404311360.
Thanks to some conversations with Qlik NPrinting users we discovered that latest version v2109 of Excel and PowerPoint include in Microsoft Office 365 is not working correctly with Qlik NPrinting Designer. The R&D team is working right now to solve at the same time we suggest avoid installing Microsoft Excel and PowerPoint v2109 on the computers you use to edit Qlik NPrinting templates. Please note that Qlik NPrinting uses Microsoft Office only to edit report templates. Instead it is not used to generate reports.
To check the version of Microsoft Office you are using refer to https://support.microsoft.com/en-us/office/about-office-what-version-of-office-am-i-using-932788b8-a3ce-44bf-bb09-e334518b8b19
The update history for Microsoft 365 Apps is available at https://docs.microsoft.com/en-us/officeupdates/update-history-microsoft365-apps-by-date
You can also refer to the support article https://community.qlik.com/t5/Knowledge/Qlik-NPrinting-can-t-find-supported-reporting-template-editor/ta-p/1716228
SUGGESTED SOLUTION https://community.qlik.com/t5/Qlik-NPrinting-Documents/Qlik-NPrinting-Designer-cannot-find-a-supported-template-editor/ta-p/1861060
Word. PixelPerfect and HTML templates are not affected.
Best Regards,
Ruggero
Hello NPrinting Community!
Please check out this Blog post and article as soon as possible if you are considering upgrading QlikView to 12. 8 track.
Kind regards...
I've tried to move QMS on another machine as described here.
How to move the QlikView Management Service to a n... - Qlik Community - 1714113
Now new QMS is able to manage all services on old machine except QVS.
status = running
DSC@old_server
LicenseService@old_server
QDS@old_server
QVWS@old_server
QMS@new_server
status = disconnected
QVS@old_server
I've check port 4747 in both directions - telnet makes contact. I was able to create a task with the new QMS and distribute on QVS@old_server. However, when I've added another QVS as QVS@new_server and created a task to distribute there, then distribution failed as QVS@new_server was not available.
Somehow connections QMS@new_server -> QDS@old_server -> QVS@new_server do not work.
Can you help with this?
I wrote the below Macro code using VBScript I know the code is correct. Anytime I press the button attached to macro on my system instead of the script to fire it was reopening the macro editor. please, what can I do apart from changing module security to system access in which I did but it is not running.
Sub HideTabRow
Set DocProp = ActiveDocument.GetProperties
DocProp.ShowTabRow=False
ActiveDocument.SetProperties DocuProp
End Sub
Sub ShowTabRow
Set DocProp = ActiveDocument.GetProperties
DocProp.ShowTabRow=True
ActiveDocument.SetProperties DocuProp
End Sub
Hi there
I was wondering whether it is possible to populate Qlik Sense Users by reading a REST API endpoint? We have an application in which we have users, but we would like to give some of the users access to Qlik Sense. We can expose the user details (ID, Name and Attributes) using a REST API endpoint, but I am not sure if we will be able to create those users in Qlik Sense? The plan is to use the application together with a certificate to get tickets for these users, but I assume that we need to have the users available in Qlik Sense first (we want to use certain rules based on attributes).
The alternative we are considering is to have a Qlik Sense App consume that REST API and then writing the details to an Excel file which is the source of a Qlik Sense UD connector, but we would like to cut out the QS app and Excel file if possible (seems like we are creating unnecessary steps in the process).
Please let me know if anyone has done something like this or if you have any suggestions.
Regards,
Mauritz
Update: My Excel plan won't work as I cannot write/store data into an Excel file. Now I REALLY need suggestions 😉
Hi Team,
We are working on one SaaS requirement, where we want to send mail to users and in that mail we have to do 2 activity
1: attached excel ( output of one object)
2: add chart image in body.
We are able to achieve both individually but user need one single mail with both required results.
How can we achieve it? Your thought/suggestion will really helpful for me.
Regards,
Prashant Sangle
Hi! I have a requirement to generate a report with Excel sheets for a set of months. This works fine but how do I show the most recent month as the first worksheet?
Hi,
I'm encountering an issue while trying to securely connect to my Qlik Sense server hosted on an AWS EC2 instance from a remote machine using curl
. I followed the steps provided in the Qlik documentation to export a set of certificates for this purpose.
The exported server.pem
certificate correctly contains the public DNS of the EC2 instance as the Subject Common Name (CN). This aligns with my expectation to use the public DNS for remote connections.
However, when I attempt to establish a connection using curl
with the specified certificates, I encounter SSL verification issues. To diagnose the problem, I used the openssl s_client
command to inspect the SSL handshake and the certificate being presented by the server:
`openssl s_client -connect <public DNS>:4242 -servername <public DNS>`
Surprisingly, the output indicates that the server is presenting a certificate with the Subject CN set to the private DNS of the EC2 instance, rather than the public DNS specified in server.pem
. This discrepancy leads to a "no alternative certificate subject name matches target host name" error from curl
, as there's a mismatch between the host I'm connecting to and the CN in the presented certificate.
I'm trying to understand why there's a difference between the CN in the exported server.pem
certificate and the CN in the certificate presented during the SSL handshake with the server. Is there a configuration within Qlik Sense that determines which certificate is presented for remote connections, or could this be related to the AWS setup?
Any insights or guidance on resolving this discrepancy would be greatly appreciated, as I aim to establish a secure connection using the public DNS of the EC2 instance.
I have couple of reports which I am sending as excel attachment via NPrinting email. In them I have columns which have numerical data e.g. Amounts.
The problem is in the excel attachment these columns get converted into 'text' type due to which sub-totals are not calculated.
I have already taken below steps to troubleshoot this:
1. The specific column is 'measure' in the Sheet (straight table widget) with 'Number' formatting.
2. In the NPrinting template of the report have disable 'Keep Source Formats'.
3. Have changed the format of the column to 'Number' in the NPrinting excel template.
Please advise what can I do to solve this.
Hi,
I'm following AEM API documentation here
and able to login and getting APISessionID, but when APISessionID returned is passed to other APIs such as
/api/v1/servers it's returning application-status as 500 and error as "SYS-E-UNRECREQ, Unrecognized request pattern 'GET: /v1/servers'."
Can someone help me, what's missing?
our products is Qlik sense 2023 may patch 4 and server 2016.
found risk Critical Security fixes for Qlik Sense Enterprise for Windows (CVE-2023-48365)
I want to update with 2023 may patch 6.
But could not successful update and tell me patch 4 could not uninstall.
how to deal with ?
detail see attached documents.
jens
Hi,
We have a requirement to setup a default folder which will be destination folder for multiple reports (generated based on different Qlik apps).
So instead of creating multiple destination folders for each app. Is it possible to create a folder without choosing the app.
I see that in the Publish Task--> Destination tab, it seem I can only see the folder if it is linked to the App.
How can a set a common designation folder that can you used by Publish Tasks belonging to different apps.
Thanks
Hello Experts,
Can a user have and use NewsStand without Nprinting?
Will they still be able to see and access reports on the NewsStand? Or do they need to get NPrinting installed to be able to see it?
Thanks
Hi everyone,
Been trying to automate the process of sending out reports on Qlik Cloud's 'Reporting' service via email in the form of an Excel File but kept getting the error:
'Failed to Send: Could not generate'
Not sure if anyone has encountered this issue and if there are any solutions to this.
Thanks in advance!
Hello community,
We have an issue in our server and we are not being capable to figure out what's going on: We have one app that is not really that heavy ( around 200 Mb) and has many users accessing to it (lets say more than 300)
It reloads more than 2 times a day (The data is updated daily at different times from different sources) and sometimes (for whatever reason we couldn't figure out) the tasks finishes ok on the QMC, and the label on the APP says that is has been reloaded, however the actual data on the app is outdated: the numbers that appear on the charts and all the visualizations don't have any data from the last update. It's like if the last reload task had never run in the first place.
We've checked the logs on the tasks, there seem to be no errors over there.
If we have another version of the app, and we reload it in our work area, it's ok and the data is updated. Even the source QVDs have all the data up to date. If we republish overwriting the stale qvf on the stream, however, the data will not be updated on that application.
Right now our only solution is reload a backup of the app and republish it on the same stream, but as a different app, telling our users to access to a new URL (since the app id is different)
Does anyone has any idea why this could be happening?
Hi everyone, I have been trying to explore different options to create mashups, I ended up using nebula.js, till now everything is working fine except the map component from @nebula.js/sn-map , I dont know what are these values :
Bonjour,
J'ai besoin d'aide sur un kpi que je dois calculer sur Qlik.
j'ai besoin de vérifier pour chaque date sélectionnée dans un filtre par l'utilisateur. Sur les 24 derniers mois à partir de la cette date, j'ai 24 montants par centre et par enseigne au total( un montant par mois).
j'ai créé un flag pour vérifier si sur chaque ligne j'ai un montant saisi, Après j'ai compté le nombre de valeur de flag='Oui'
Ensuite, j'ai calculé le nombre de flag sur les 24 derniers mois dans un set analysis.
Ce qui me reste c'est de créer un flag pour quand j'ai 24 mois.
Quand je le fais sur une mesure ça marche, mais sur une dimension ça ne marche pas. Sachant que j'ai besoin plutôt d'une dimension que d'une mesure.
Script Qlik :
Résultats du deuxième flag
Quelqu'un peut me dire qu'est ce qui n'est pas bon dans ce que j'ai fait et comment je dois calculer ce kpi s'il y'a une façon de le faire.
Bien à vous
Chaimaa
Hello.
I am trying to assign a set of Custom properties to more than 1000 users in Qlik Sense. Is there a way to assign it in a bulk mode?
The Users are already pulled into the Qlik environment and i just need to assign them different security rules based on custom properties.
Thanks.
Hi,
We have few excel reports in NP-16(.nsq), few of those reports are based on Qlikview Entity report and others are normal reports created within NP-16.
I am planning to migrate this .nsq file to the Qlik Nprinting(21.14). I read that Qlikview entity reports cannot be migrated using the inbuilt migration tool present in Nprinting v21.
In this case what is the solution.
Can i still load the .nsq file into the Nprinting v21 and manually create the entity reports?
Thanks