Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Portrait vs. Landscape: how to control?
Use the Excel Tabular Reports plugin with the Desktop Excel edition of Microsoft Office 365. The web edition does not include an orientation drop down.
In Excel desktop, you will see this menu option.
However in the browser, you only see this:
In Excel desktop, the page border will show up as hashed lines as below:
As you can see in the above screenshot, all columns fit inside the hashed lines so the current orientation will result in all columns appearing on a single page.
Note: if you don't see the hashed lines at first, try toggling the setting two times and it should show up.
Lastly, if you have found a way in Excel web to visualize page borders, please share and improve the collective knowledge!
-Jonny
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...
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.
<!DOCTYPE html>
<html>
<head>
<style>
body {
margin: 20px;
font-family: Arial, sans-serif;
}
</style>
</head>
<body>
<p style="font-style: italic; margin-bottom: 10px;">
The list below does not include direct transfers from Home Health to SNF/SNU or transfers to hospitals outside of Lee Health. Please notify the Leadership team if your patient is transferred directly to SNF/SNU or to a hospital outside of Lee Health.
</p>
<div style="font-size: 16px; font-weight: bold; margin-bottom: 10px;">
Patients in Inpatient Status Last 72 Hours
</div>
<div>
<table role="presentation" style="width: 100%; border-collapse: collapse; border: 2px solid black;">
<tr>
<th style="background-color: #add8e6; border: 1px solid black; padding: 8px;">Patient DOB</th>
<th style="background-color: #add8e6; border: 1px solid black; padding: 8px;">Chief Complaint/Dx</th>
</tr>
<tr>
<td style="border: 1px solid black; padding: 8px;">%%PatientDOB_1%%</td>
<td style="border: 1px solid black; padding: 8px;">%%=ChiefComplaint_1%%</td>
</tr>
</table>
</div>
</body>
</html>
I have this html code when i try to fetch data and create a html report that gets embedded to the outlook its not working .It just creates the outline of the table but the columns and rows are not divided as seen in attached image output.
but pdf gives me the actual output, but not html .
Any help??
I created a cloud deployment in the Qlik Sense Enterprise QMC and assigned a few apps to it. It's working fine, deploying those apps to my SaaS tenant, but I want to rename the deployment now. I tried it, and suddenly my apps are no longer syncing, so I named it back to its original name and that fixed it. So, the question is how can I rename the deployment and have the apps update to use the new deployment name?
hi collegues, I have a problem when I try to update to the version of April 2019, it does not appear the option to update, it seems like it did not detect the previous version (November 2019 patch 1),in the attachment are the images.
note: the shared folder is on another server
I am using qlik sense may 2024 version, my question is regarding this API, My question is this APi requires a qlik-web-integration-Id where can I find it or How can I can Access this API using qlik ticket
Hi All
We encountered with issue regarding Windows Authentication Prompt, it's occur after SAML SSO authenticate successfully to HUB, than any attempt to opening app will Prompt Windows Authentication.
we found KB https://support.qlik.com/articles/000027459 with resolution
we've remove all those extensions except for Qlik bundle extensions.
but we still getting Windows Authentication in any attempt to open App.
we also change IWA as auto logon, but still same issue occur.
the article above declare it as WAD, but we need to find resolution or workaround
Can someone advise ?
Many thanks
Problem Description: By using the Engine API we are trying to build a script that dynamically cycles through the values of 3 fields and updates the contents of a sheet accordingly. Getting the cardinal for each field works, however for getting the actual values fails (theses are needed in another script, not discussed here)
Attempted Solutions:
connect to the Engine API on port 4747
establish a synchronous socket connection
open the required app by using the “OpenDoc” method. From the json response the application_handle is extracted
using the application_handle a Session Object is created
From here 2 approaches have been tested:
Access and update the fields directly from the Application level
use the app_handle and the “GetField” method to obtain the field_handle
using the field Handle and the “GetCardinal” method we get the cardinal
using the app_handle we get responses on other methods like “GetFieldDescription”
However trying to use the “GetFieldValues” fails with “Method not found” error
Access and update the fields directly from the Sheet level
essentially an additional step is added where a specific sheet is selected and its handle used in tandem with the “GetFieldValues” method, with the same error as the result
Blocking Points:
- getting the actual values of any particular Field
- updating the sheet and consequently its visualizations, after the values for the 3 Fields have been updated
Questions:
Is it possible to get a json response containing an array with the Values of a particular Field? Or is such a method missing from the backend Engine API?
If the answer is yes to the first question can anyone provide a working example for the proper chain of the Requests and their syntax?
Thanks a lot in advance for your time and effort
(if these questions have already been answered please provide a link)
Is there any way to use the qlik-embed "classic/app" UI and listen to events (like changing sheets) that occur within it? We need to be able to embed the whole app so that users have access critical features (exporting data from individual charts to excel, rendering visualizations that aren't supported in the "analytics/sheet" UI, etc.) But it seems like if we use the qlik-embed "classic/app" UI, we lose the ability to have the URL reflect what sheet the user is currently viewing, or allowing the user to click the "back" button on the browser in order to view the sheet they were looking at previously.
I'm wondering if there is a solution or work around for this. Thanks.
We have come across the issue where Repository is taking up all the available CPU on the server making QlikSense Enterprise slow or out in some of the cases. We have uplifted the server from 48 CPU to 64 CPU but still facing the issue.
Implemented the changes like maxpoolsize increase for postgreSQL connection etc but still issue is not resolved.
We are on February 2024 Patch 4. Has anyone else seen this issue in their system?
We also have ODAG (Dynamic View) application that gets used by 300 users at a given time with concurrency of 150.
Regards,
Jenil
Hello experts
I have couple of questions in regards to time/ranges.
What I have is this:
Column:
Time
07:00:00
08:00:00
09:00:00
etc..
Column:
Price
1400
1410
1390
etc
1) I need to know if the price at 07:00:00 was Higher then the price at 16:00:00?
2) then I need to calculate the difference - by how many points
3) and then I need to build time ranges and find an average price for each interval:
range: 'morning' - time: 07-12
range ' lunch' - time 12-13
range 'evening' - time 13-16
Can you please help me with that. Thanks in advance for your help!
How can I monitor the time users spend using a Qlik Sense Enterprise on Windows environment
For our analyzer capacity users I am able to find a their capacity minutes consumption this the license monitoring application (it is not the exact time spent, due to the 6 min license chunks, but its a good enough approximation). But for the users with named Professional or Analyzer licenses I am missing this information.
I've tried to look at the session duration informaiton found in the session monitoring application, but as users may have multiple active sessions running in parallel the sum of session time is not a good approximation of time spent using Qlik Sense.
Having this information would give a better insights on user patterns before deciding on purchasing new capacity minutes or regular Analyzer licenses to our Qlik environment.
Hello,
I have encountered the issue where I can see dashboards within host server (by Qlik accesspoint), but cannot see them from external site (using web link) as in screenshots below. Note that both screenshots are taken from the same external environment.
Please help to point out the issue and guide me what should I do in this situation. Thank you very much for your help.
We are still using Qlik sense for windows 2018 and planning for an upgrade. (Current version 12.5.2 ). Which would be the suitable version for a Direct upgrade .. The plan is to move to a supported (latest) version step by step. Please help.
Hi,
I'd need to distribute an excel report to sales agents applying the correct data reduction using the sales agent code as filter.
Is it possible to create a unique filter for all sales agents in order to send the right data (filtered on sales agent code) to the right person?
Please let me know.
Many thanks in advance for your time.
Best Regards
Hi
Seems like Qlik Sense Task dont care how much it pushes processor & memory.
We have, especially in out of business hours(12:30am - 8:30am), more than 200 ETL & Report reload tasks. Some are really process intensive tasks.
And so much that, Qlik Sense engine service on a node stall and restarts automatically by Windows, killing all the running tasks and restarts on the rest of the scheduler nodes. Few gets failed and few causes index creation failure.
So some times we try to insert dummy delay apps as tasks to stagger the reload.
My question/recommendation is, is there any process/task queue option can be implemented in Qlik Sense?
I have a data table that has been connected in previous app updates, but with the update I just did yesterday, it is no longer connected. The script for it is there and it is still in the Access table as well. I re-ran the script and there were not any errors, but the table did not load it. It is like the Data load editor completely skipped over that script for the table. Any suggestions of what I can do or what happened?
Hello Everyone.
I have a problem. After upgrading our QlikSense Enterprise on Windows (Meows)
QlikSense not working after upgrade from november2023 patch 9 to may2024IR.
Situation: a cluster with one Central and one Rim Node. Operating system Windows 2016 server.
In the past, we update the application many time successfully. However, no after the upgrade to May2024 IR,. we also did an upgrade to feb 2024 IR. But got the same problem.
QlikSense isn't working anymore after the upgrade on the Central node. There were No errors during the upgrade and all QlikServices are up and running. We shut down the Rim Node and only working on the Central node.
The setup of the upgrade went successfully, but after a restart, the QMC or Hub is not accessible anymore.
All the Qlikservices are up and running but we cannot access the QMC or Hub.
Does anyone have this issue before?
Anyone an idea what could be problem of this upgrade?
Hello,
As far as I know in the report generation, filter selections are defined manually in the "Filter" tab. So I was wondering if there is a possibility to define these selections beforehead in the loading script section, the same way it is possible to define the distribution list by script ?
Thank you
Hello, I have been using the NPrinting API, but suddenly on 7/31 I've started receiving authentication failures (401) when making calls to the API. I'm using the /login/ntlm endpoint to connect. Using postman, yesterday I was able to successfully authenticate once and proceed to make additional calls to the API, but once I disconnected it went back to the authentication failures. I have tried via multiple admin accounts and have used a python script as well as postman in attempts to connect.