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
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.
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...
In coordination with the launch of Qlik AutoML on Qlik Cloud, we are making a set of sample data files available for people to use when trying out the new capability. These files represent a fictitious company with customer subscriptions, looking to predict which customers will stay and leave in the future. This simple data will allow our users to quickly experience the power of machine learning as they learn the AutoML process.
See attached files at the end of this post
Step 1 - When creating your first AutoML Experiment, use the Customer_Cancellations_Training.csv dataset to train your model. This dataset contains historical customer churn data for the machine to learn from.
Step 2 - After you have deployed your first model, you can use the Customer_Cancellations_Apply.csv dataset to create predictions. This dataset contains current customer data on which churn predictions can be made.
Watch this video to get an understand on how to use this data.
Can't see the video? Watch on the Qlik video site.
I have a security rule with name 'ReadOnlyAccess' and
resource filter: App.Object_*
Actions: Read
Context: Hub
below are the conditions:-
((user.roles="ReadOnlyAccess")) and !resource.App.stream.Empty() and resource.App.HasPrivilage("read") and (resource.objectType="dimension" or resource.objectType="measure")
Below is what we need to achieve:
User should be able to see load editor - Read only view
User should be able to see Data connection view - Read only view
User should be able to see all streams - Read only view
User should be able to see all apps inside stream - Read only view
I want to add color to the bar graph by entering the Expression background color.
The conditions are If the bar graph shows data for the year, include rgb(30,144,255) and if the graph shows data for the month, enter Rgb(70,130,180) and if the graph shows data for the day, enter rgb(135,206,250)
This is the code that displays the data in a bar graph.
please help me
In the NPrinting Repository Database, I am trying to find where I associate which data connections a NPrinting report is utilizing.
The entities_xml field looks to have the data connection inside but it is not for all my reports.
Wondering if it is in another table besides report,task,data conneciton.
Hello,
I currently have a button that I have actions set up against it.
In the Action button I have a field that is selected.
Inside of the Expression editor in the field, I am trying to pull these values:
"(6010015 - Penguin Random House LLC|6010030 - HarperCollins Publishers|6010031 - Macmillan Publishing USA|6010033 - Hachette Book Group USA|6010036 - Simon Schuster)"
What is the proper syntax for using text/numbers? I used this before: "(6010030|6010033|6010015|6010031|6010036)" and this worked perfect.
Any help will is appreciated.
All,
I am looking to update the document title bar in QlikView desktop. I would like to remove the QlikView icon, QlikView Text, and the document title entirely. I can settle for leaving the QlikView icon and version text, but I cannot display the document title.
Under the document properties, you can update the document title. However when the document title is set to a null value, the path of the document is shown. Also, placing an empty string will display "[ *]" in the title bar.
Is there a way to update the title to accomplish any of the below layouts?
Preferred Displays
Hi,
I want to load the data from two different SharePoint links.
1. one link opens direct excel file data with no of columns.
2. Second link opens JIRA Details with no of columns directly (we don't want left side and top names ), we want to load the columns into qliksense which are highlighted in yellow
Request you to please let me know the solution and process with more details how to load the data from Share point link, as tried to load through WEB file by putting those URL links but not working.
Base on diagram I will like to acquire Access token for my client app.
I saw that one of supported grant type is "urn:ietf:params:oauth:grant-type:token-exchange".
Short explanation:
Is this flow passible?
Hello,
Can someone please help me with the following:
i am trying to utilize a mashup inside an iframe but i keep getting the below error from the browser console
has someone encountered it before?
Hope anyone can help me
thank you,
We are a Qlik Sense Enterprise site and are interested in giving secure access an external customer access to a specific sheet. They do not have Qlik Sense. Ideally, they would like read-write access to the sheet.
Here are some older links that discuss this scenario:
-Share QlikSense app with non users - Qlik Community - 1578514
QlikSense App Share with non Qlik user - Qlik Community - 1366969
They would need to access via the Hub and would need to use a token. You could create them as a user and assign them a login token instead of a named user if they are not going to be accessing the app often.
Otherwise you would need to use the Cloud. But you would have to export the app from the QMC and then upload it to the Cloud and then publish it there. Kind of a pain. Also, no way to reload the data in the free Cloud. You would have to repeat this process every time you reloaded the app on the server.
Keep in mind that they don't need Qlik to access the app. They just need access to the URL for your hub using their browser. But once they access an app they are technically a Qlik user.
This is sensitive information and not to be consumed by the public.
Questions:
-What has changed since these posts were written?
-Has anyone done this successfully? If so, how did you set it up? There was mention of giving the external user access to the sheet's url .
-Were any additional Qlik products needed? One post mentions that the external user needs Qlik Capacity Analyzer, and there was mention of Qlik Cloud - is that now Qlik Enterprise?
Thanks for any info you can give!
Hi,
what i want is load a excel file from my device to qlik sense and connect to API with Rest connector(this part is ok, i create Rest connection), get analyze data from it. for example ask some question and get response from chatGPT
can anyone guide me please
Hello,
I will need to filter the Actions based on my cursor positon within the Statustable. E.g if I click a date within column TOSV34 the table below supposed to only show Action 34, in case I click within column TOSV100 respectively only action 100.
Best Regards
Timo
Hi,
When I am trying to load data from source DB, it is failing with error code -128.
Can someone please suggest how to resolve this issue?
Below are error details:
2020-03-25 15:49:17 0013 OLEDB CONNECT TO *** (XPassword is ***)
2020-03-25 15:49:17 0015 cp_data:
2020-03-25 15:49:17 0016 SQL SELECT CraneID,
2020-03-25 15:49:17 0017 cp_id,
2020-03-25 15:49:17 0018 parameter,
2020-03-25 15:49:17 0019 datetime,
2020-03-25 15:49:17 0020 RowID,
2020-03-25 15:49:17 0021 value
2020-03-25 15:49:17 0022 FROM cp_data
2020-03-25 16:40:07 6 fields found: CraneID, cp_id, parameter, datetime, RowID, value,
2020-03-25 16:40:07 -128 =
2020-03-25 16:40:31 Execution Failed
2020-03-25 16:40:31 Execution finished.
Please find attached the log file for reference.
We have an app which is 10 GB of size. Recently we started facing severe performance issue like extreme slowness and timeout issues for end users. I wanted to know if below things affect the performance.
1] App reload is scheduled daily so having simultaneous app reload and app hub access is creating an issue?
2] Considering the size of the application how can we accurately measure its CPU and RAM footprint per user?
3] App cache time is currently 8 hours which is default, do you recommend reducing it to lesser time as RAM will always be occupied if the app is constantly in use.
We have some connections to DataRobot from our Qlik Cloud tenant that perform live predictions when certain sliders and drop-downs are changed, creating new values to drive the prediction.
I recently went to review how this had been created so that I could replicate it for a customer demo, and I found that it is no longer possible to save a connection with the fields specified that should be used from the response. Whenever the tick box "Load all available fields" is deselected, the option to test or save a connection is unavailable.
Has anyone else noticed this change? Has the way that the connection is defined changed? The connection is returning predictions when the same connection definition is used in batch, but when I then try to use that endpoint in the chart expression, zero is returned in the chart, which looks like field[0] in the response.
Anyone got this working better than me and able to pull back a specific field in the response?
Hey Everyone,
we are running a QlikSense 14.129.9 with a Postgres 12.5 installation. I tried to follow the description here Upgrading and unbundling the Qlik Sense Repository... - Page 15 - Qlik Community - 1934238 to upgrade to the newest QlikSense Version.
As I try to run the 14.139.4 setup it gets stuck at the step "Installing Repository". I found out in the logs that it is looking for a database with Postgres 14. So I tried to install that first. But at the start of the installation it won't find a previous installation.
Furthermore I found out, that the old paths led to C:\Program Files\Qlik\Sense\Repository\PostgreSQL where version 9.6 of Postgres still exists. But the new installation was made to C:\Program Files\PostgreSQL\12.
(I found some registry keys (Qlik Sense Repository Database) pointing at the old path, but even changing them to the new location does not solve the problem)
What am I doing wrong?
Hello,
brand new Qlik User with a massive project ...
Reinvent a running application using QLIK instead of hardcoded C# . We do have this hardcoded C# exe file which forwards 3 CSV files line by line into a new SQL Master-table. Applying filters deleting empty rows and transpose the data structure. Acctually the transpose function is the major reason we do this line by line.
Now how will I be able to create this master table in Qlik. The attached picture is just a sample of the first part of the original code - creating the Mastertable from filterd Project table. Transposing is not shown yet. But I need to know if it is possible at all.
In Qlik I hardly codes anything yet. BUT in fact what I did so far is not even working out . The where statement is not considered and the table PROJEKTE looks very poor compared to the original CSV there is a lot of data missing.
Dont be confused because of the xls file extension .. it is a CSV format delimiter Tab.
Best regards
Timo
Hello,
the distribution and publishung of qvw files is very slow.
We have 2 servers, a reload server and a server working as accesspoint.
The storage where the files are copied are nfs (SSD).
Publishing qvw files direct to the publisher to local disc is also slow (SSD).
Publishing to a normal folder is fast.
CPU and RAM are not the problems, there are always enough free ressources.
in the Task logs we found this:
(28.11.2023 17:50:01) Information: <Global method="FileWrite"><h>0</h><Pos>83886080</Pos><Buffer /></Global>
(28.11.2023 17:50:01) Information: ExecuteWithAttachments returned no data in buffer.
(28.11.2023 17:50:01) Information: <Global></Global>
The support already checked all logfiles of the operating system and the qlikview server but there were no irregular and suspicious entries.
the following tips of the support are not working or brought no improvement:
https://community.qlik.com/t5/Official-Support-Articles/Scaling-the-QlikView-Publisher/ta-p/1717686
We use the publisher in Version12.80.20000.0 on the reload server.
What could be the reason for slow distribution and are there some hints to solve this problem?
Thank you.
We just cloned our server, we cloned the production one, to make it the qlik approval server, our problem is that now we cannot access qlik on this clone via browser, possibly for the reason that the localhost and ip changed, I would like to know What should we adjust to be able to access the qmc of the clone that became homologated, with a new path.
I want to concanated each data in the 2nd table below by the data in the 1st table.
TABLE 1 | |
key | table1_value_field |
A | 1 |
B | 2 |
C | 3 |
TABLE 2 | ||
key | table2_field | table2_value_field |
A | X | 1 |
A | Y | 2 |
A | Z | 3 |
B | P | 4 |
B | Q | 5 |
B | R | 6 |
C | K | 7 |
C | L | 8 |
C | M | 9 |
Concat(TABLE 2 X value * TABLE 1 A value , TABLE 2 X value * TABLE 1 B value , TABLE 2 X value * TABLE 1 C value....................TABLE 2 M value * TABLE 1 A value , TABLE 2 M value * TABLE 1 B value , TABLE 2 M value * TABLE 1 C value)
=> Concat(1*1 , 1*2 , 1*3.....7*1 , 7*2, 7*3)
=> Result: 1,2,3…..7,14,21
It happens with an alternative state in the text box. However, I cannot calculate the table expressions. I need such a solution. please help me.