Support

Dear Qlik Sense users, We are pleased to confirm that the latest patch for Qlik Sense November 2018 is now available on our download site. November 2018 Patch 5 only includes a few product defect fixes and you can find details of all the fixes in the attached release notes. The patch is installed as a MSP and must be installed on top of the full Qlik Sense November 2018 installation. Thank you for choosing Qlik software. As always, please follow best practices when upgrading any software and make sure you back up your system before making changes. Kind regards, Global Support ...View More

Hello Qlik NPrinting World!!Last time I talked about Qlik NPrinting with Qlik Sense -Qlik NPrinting 101: Connecting Qlik Sense AppsBut now it's time for QlikView.So, you have just purchased Qlik NPrinting and now you want to get started with Reports but what do you do with your QlikView Apps?Well look no further! Here is some information on how to get started if you are new to the wonderful world of NPrinting.Topics:1. Requirements2. Connection Rules3. App ConnectionRequirements:First, there are some requirements which are found detailed on ourQlik Help SitePlatform - Windows 2008 R2 (only if Qlik Sense connections are not required) / 2012 / 2012 R2 / 2016 64-bit architecture onlyProcessor - Multi-Core x64 compatible processorsMemory - 8 GB minimumDisk Space - 500 MB minimumDedicated Qlik NPrinting Server & Engine Service Account ConfigurationConnection Rules:You can create connections to your QlikView documents that are stored in the following locations:Local ComputerShared Network FolderQlikView Server that you have permission to accessQlikView ClusterYou can create connections from a Single Qlik NPrinting App to multiple QVWs.App Connection:So, you may be wondering, this is helpful, but now how do I connect my QVWs in Qlik NPrinting?Well I worked with the Education Team to help create a "Qlik Fix" video. The video is found here:It will take you through the basic steps of making an App Connection.To summarize the video:Login to the Qlik NPrinting WebConsole with the needed permissions to create an AppNavigate to Apps to create the "shell" for your AppNavigate to Apps - Connection to create your connectionEnsure that you are picking the appropriateAppfrom the list and yourSource is "QlikView"Choose if you would to connect to a Local, Server, or ClusterLocation Type. In the video we selected a Local ConnectionEnter the Document PathIf Section Access applies check the "connection requires authentication" checkboxRun Verification👍Congratulations! You have connected Qlik NPrinting with QlikView!👍If there are any error messages with the Run Verification step, the common causes of the errors are described on our Help Site:Verify connection errors when setting up a connection to QlikView in Qlik NPrintingI hope you have found this Blog helpful. If you have any questions, feel free to post them below. ...View More

Hi everyone,Want to stay a step ahead of important Qlik support issues? Then sign up for our monthly webinar series where you can get first-hand insights from our #QlikSupport experts.This Thursday, 23 May Qlik Support will host another Support Techspert Thursday session and this time we are looking at Extending Qlik Sense Enterprise with NPrinting On-DemandBut wait, what is it exactly?Support Techspert Thursdays is afreewebinar to facilitate knowledge sharing held on a monthly basis, on the third Thursday of each month.Hear directly from Qlik Techsperts on topics that are relevant to Customers and Partners today.In this session we will cover:One Click NPrinting ReportsConfiguring the buttonAvoiding pitfallsTroubleshooting tipsClick onthis link to choose the webinar time that’s best for you.The webinar is hosted using ON24 in English and will last 30 minutes plus time for Q&A.Hope to see you there!! ...View More

Hello Qlik NPrinting World!!You have just purchased Qlik NPrinting and now you want to get started with Reports but what do you do with your Qlik Sense Apps?Well look no further! Here is some information on how to get started if you are new to the wonderful world of NPrinting.Topics:RequirementsCertificatesEngine StatusApp ConnectionRequirements:First, there are some requirements which are found detailed on our Qlik Help SitePlatform - Windows 2012 / 2012 R2 / 2016 64-bit architecture onlyProcessor - Multi-Core x64 compatible processorsMemory - 8 GB minimumDisk Space - 500 MB minimumVersion - Qlik Sense must be on a version that is newer than 3.0.1 / Qlik NPrinting must be on a version that is newer than 17.2.1**Qlik Sense and Qlik NPrinting cannot be installed on the same Server. This is extremely important.**Certificates:After all the basic requirements have been met you must install the Qlik Sense certificates on the Qlik NPrinting Server.These certificates are obtained from your Qlik Sense Administrator, and the detailed export instructions are available here:Exporting Certificates through the QMCInstalling Qlik Sense CertificatesEngine Status:After the certificates have been successfully imported, navigate to the Qlik NPrinting WebConsole to the Admin - Engine Manager page. Ensure the hostname is filled out correctly. You should now see your Engine with an "Online" status as pictured below:Engine Status is OnlineWell done for Connecting Qlik NPrinting with Qlik Sense! You are a Rockstar!!⭐App Connection:So, you may be wondering, this is helpful, but now how do I connect my QVFs in Qlik NPrinting?Well I worked with the Education Team to help create a "Qlik Fix" video. The video is found here:It will take you through the basic steps of making an App Connection.To summarize the video:Login to the Qlik NPrinting WebConsole with the needed permissions to create an AppNavigate to Apps to create the "shell" for your AppNavigate to Apps - Connection to create your connectionEnsure that you are picking the appropriate App from the list and your Source is "Qlik Sense"Enter the Proxy Address - the full name of the Qlik Sense Server prefixed with http or httpsFor example: https://sense_proxy_computer_name.domain_nameOr if using a prefix: https://sense_proxy_computer_name.domain_name/prefixEnter the Sense App ID which is found in Qlik Sense via the QMC - Apps or the Qlik Sense HubChoose an Identity of a Qlik Sense user that has access to the AppFormat - windows domain name\user nameIf section access applies check the "Apply user section access for reports" checkboxRun VerificationIf there are any error messages with the Run Verification step, the common cause of the errors are described on our Help Site:Verify connection errors when setting up a connection to Qlik Sense in Qlik NPrintingThanks for taking the time to read my Blog and feel free to ask any questions! ...View More

Sense April 2019 latest patch released!

...View More

Hello QlikView Users, We are pleased to announce the release of QlikView Governance Dashboard 2.1.0! This release of QlikView Governance Dashboard includes a new "Sense Profile Score" sheet which presents new insights into Qlikview app metadata to support the analysis of Qlikview apps in relation to their adoption rate and compatibility with Qlik Sense. Additional metrics are also available to assist QlikView app developers and administrators in prioritizing efforts to improve usability of existing QlikView apps. For more details about this release, please see the attached release notes. Thank you for choosing Qlik software. Kind regards Global Support Team ...View More

The Global Support organization is happy to announce improvements to our Qlik Support Portal. The “new look” portal offers new designs aimed at helping you find answers and information more easily. By highlighting engaging content and using intuitive navigation, our goal is to enhance your self- service experience. We look forward to providing you: Topic and product based content for the anonymous user Universal navigation and new custom page designs Easy visibility and connectivity to additional Qlik resources (Community, Help, QCC, YouTube Channels, Cloud status) Enhanced navigation to existing functions such as My Environments, My Licenses and My Cases for the authenticated users More “1-click” navigation Organized resources and knowledge content based on popular searches and usage Finally, we’ve made it even easier for you to engage our vibrant Qlik community product forums where you can ask your questions and look for solutions, tips and tricks from over 68,000 Qlik product users. Check out our preview videohttps://support.qlik.com/articles/000073402 Our maintenance window for Go Live is over the weekend of May 11/12. See Portal Maintenance announcement in the below comments. If you have any questions, please feel free to comment. We’ll be monitoring and updating you as our progress for deployment continues.For those of you attending Qonnections, please visit our Support Kiosk to share your feedback. Niall Gillick Senior Global Support Director, EMEA ...View More

Hi everyone,Starting with Qlik Sense September 2017, we introduced the Qlik Centralize Logging (QLogs) database. This database is managed by the Qlik Logging Service.Databases still need space though, so deployments that were using the QLogs database for an extended period already, or larger and active deployments, may find themselves accumulating big chunks of data. At this stage, your QLogs database might be consuming several GB of disk space.This situation can be a major problem for your System Administrator. But don’t worry. There are ways around this (housekeeping), and I’ll be going over what to do to prevent this from happening in the first place, as well as how to slim down an existing database.Here is what we will cover todayIntroductionAm I using Qlik Centralize logging?How much space does it take on disk?How can I better control the usage on disk?Help! What to do if it consumes all or almost all the available disk space?IntroductionThe Qlik Logging Service centralizes the logging by collecting all the messages and inserting them into a PostgreSQL database named QLogs.In addition to collecting the Qlik Sense Services logs, it also consumes the Windows Event logs and the Performance Counters, such as CPU, Memory, Disk latency and queue, Network, etcRight now, it is most commonly used as a default data source for the Monitoring Applications reload. If the Centralize Logging is not enabled, the monitoring applications will use the log files as a data source. More details to this are available in my previous post All you need to know about deploying the Qlik Sense Monitoring Applications.Am I using the DB or flat files? To verify if the Qlik Centralize Logging is enabled in your environment, you can run the following command from the central node.Microsoft Windows [Version 10.0.17134.619] (c) 2018 Microsoft Corporation. All rights reserved. C:\Windows\system32> cd C:\Program Files\Qlik\Sense\Logging C:\Program Files\Qlik\Sense\Logging> Qlik.Logging.Service.exe validate archive_age_in_hours: 720 last_forced_db_trim: 2019-04-02 16:32:52.107208+02 purge_age_in_hours: 1440 version: 0.5 CentralizedLoggingEnabled: True LoggingToFileEnabled: True MaximumDatabaseSizeInGB: Max db size not enforced DB Host: QlikServer1.domain.local DB Name: QLogs DB Writer User: qlogs_writer DB Reader User: qlogs_reader DB Port: 4432Reference and additional information available in knowledge article: How To Verify Qlik Sense Is Running With Centralized Logging ServiceIf you wish to set up the Qlik Centralize Logging, you can refer to this help.qlik.com - Qlik Logging Service.How much space does it take on disk?To check how much disk space each database consumes, you can use the following SQL Request.I usually use PGAdmin4 to run this request. You simply need to right-click on one of the databases and select Query ToolSELECT d.datname AS Name, pg_catalog.pg_get_userbyid(d.datdba) AS Owner, CASE WHEN pg_catalog.has_database_privilege(d.datname, 'CONNECT') THEN pg_catalog.pg_size_pretty(pg_catalog.pg_database_size(d.datname)) ELSE 'No Access' END AS SIZE FROM pg_catalog.pg_database d ORDER BY CASE WHEN pg_catalog.has_database_privilege(d.datname, 'CONNECT') THEN pg_catalog.pg_database_size(d.datname) ELSE NULL END DESC -- nulls first LIMIT 20Reference: https://wiki.postgresql.org/wiki/Disk_UsageTo give you an example: below is the output from a single node environment without any usage, DEBUG log level enabled on all services and collected over about a week. name | owner | size --------------------------------------------------------------------------- Qlogs | qlogs_writer | 548 MB QSR | postgres | 40 MB SenseService | qliksenserepository | 7223 kB QSMQ | qliksenserepository | 7183 kB postgres | postgres | 7055 kB template0 | postgres | 6945 kB template1 | postgres | 6945 bytesIt is also possible to narrow down to which node(s) or even service(s) is logging the highest number of entries using the following request.SELECT * FROM ( SELECT d.process_host,d.process_name,d.entry_level,COUNT(id) AS message_volume FROM ( SELECT id,process_host,process_name,entry_level FROM public.log_entries UNION ALL SELECT id,process_host,process_name,entry_level FROM public.archive_entries ) AS d GROUP BY d.process_host, d.process_name, d.entry_level ) AS d ORDER BY d.message_volume DESC;Output: Process_host | Process_name | entry_level | message_volume --------------------------------------------------------------------------- QlikServer1 | proxy | DEBUG | 380020 QlikServer1 | proxy | INFO | 221839 QlikServer2 | proxy | INFO | 103589 QlikServer1 | repository | INFO | 98254 QlikServer2 | scheduler | INFO | 54269 QlikServer1 | repository | ERROR | 35874 QlikServer1 | repository | WARN | 34568How can I better control the usage on disk? Logging LevelTo make certain the QLogs database does not start consuming large amounts of disk space, you need first to control and limit the data you want to be logged.In order to not create unnecessary traffic, and to limit the amount of data logged in the database, we recommend to not set the logging level of any services to DEBUG for an extensive period of time.DEBUG level is mostly used while troubleshooting an issue and should be set back to INFO directly after that.Purge and limitIt is possible to purge the logs after a certain amount of days or limit the size of the databasePurge: (Where x and y are a day’s threshold and archive_age value must be lower than purge_age, otherwise it will fail)Microsoft Windows [Version 10.0.17134.619] (c) 2018 Microsoft Corporation. All rights reserved. C:\Windows\system32> cd C:\Program Files\Qlik\Sense\Logging C:\Program Files\Qlik\Sense\Logging> Qlik.Logging.Service.exe update --archive_age x --purge_age yReference Knowledge article: Qlik Sense - How to control the size of the Qlik Sense Logging Database when using Centralized Logging Limit: (Where n is the size in GB)Microsoft Windows [Version 10.0.17134.619] (c) 2018 Microsoft Corporation. All rights reserved. C:\Windows\system32> cd C:\Program Files\Qlik\Sense\Logging C:\Program Files\Qlik\Sense\Logging> Qlik.Logging.Service.exe update --maximum_db_size_in_gb nReference Knowledge article: Qlik Sense - How to control the size of the Qlik Sense Logging Database when using Centralized Logging Help! What to do if it consumes all or almost all the available disk space? First of all, you can take the steps mentioned above to control and limit the amount of information logged into the database.But the process to purge or reduce the size of the database can take a long time, so if you need a quick (but short-term) solution, you can temporarily increase the size of the disk while the purging process is working.If this is not possible you can trigger a manual archiving and then purge of the logs in the QLogs database. (Where X is in hours)Microsoft Windows [Version 10.0.17134.619] (c) 2018 Microsoft Corporation. All rights reserved. C:\Windows\system32> cd C:\Program Files\Qlik\Sense\Logging C:\Program Files\Qlik\Sense\Logging> Qlik.Logging.Service.exe archive –cutoff_in_hours X C:\Program Files\Qlik\Sense\Logging> Qlik.Logging.Service.exe purge --cutoff_in_hours XReference: Qlik logging service database urgently needs to be reduced in size in by going to help.qlik.com : If presented with a message stating the system is too busy, retry the command.If the second try generates the same message, try again at a less busy time on the server.Thank you for reading my blog post and I really hope it helps you.I’ll be watching for your questions, feedback or suggestions so please comment and share! ...View More

Hello Qlik Sense Users, We are pleased to confirm that the latest patch for Qlik Sense February 2019 is now available on our download site. In addition to a small number of product defect fixes included in this release, we have improved the responsiveness of the Qlik Sense Hub Client by improving the way security rules, database access, and hub service work together. For more details on the improvements and/or fixes, please review the attached release notes. As a reminder, please follow best practices when upgrading any software and make sure you back up your system before making changes. Thank you for choosing Qlik software!Kind Regards,Global Support Team ...View More

Hi everyone!

This is now my second blog post! yeahhh!!!! And today I wanted to talk about a topic that is generating a lot of discussions in the Qlik Sense Deployment & Management space:

Upgrades and Installations.

...View More

Hi everyone, 

Want to stay a step ahead of important Qlik support issues? Then sign up for our monthly webinar series where you can get first-hand insights from our #QlikSupport experts.

This Thursday, 21 Mars Qlik Support will host another Support Techspert Thursday session and this time we are looking at a Worry-Free Installation of Qlik Sense

 

...View More

Hi all Qlik NPrinting users, We are pleased to announce that Qlik NPrinting February 2019 SR1 is now available on our download site. Attached, please find the release notes with details of all the included product defect fixes. This release only includes fixes. Thank you for choosing Qlik software. As always, please follow best practices when upgrading any software and make sure you back up your system before making changes. Kind regards,Global Support Team ...View More

Hello Qlik Sense Users, We are pleased to confirm that the latest patch for Qlik Sense November 2018 is available on our download site. In addition to a small number of product defect fixes, November 2018 Patch 3 includes the following improvements: Initial Hub access times of typically less than 5s Subsequent access times will be faster Stream navigation and access times of typically less than 5s, and much faster for subsequent access Significant improvement when dealing with concurrent accesses These improvements have been made possible by improving the manner in which security rules, database access and our hub service work together. For more details on the improvements and/or fixes, please review the attached release notes. As a reminder, please follow best practices when upgrading any software and make sure you back up your system before making changes. Thank you for choosing Qlik software! Kind Regards,Global Support Team ...View More

After installing Qlik Sense Enterprise, you probably have noticed that you have been provided with two applications respectively called Operation Monitor and License Monitor. But wait there are more…

Generally speaking, we call those applications Monitoring Applications

Today I would like to introduce you to those applications and how we setup and configure them.

...View More

When the QlikView AccessPoint starts showing No Server, or end users are reporting that they are being kicked out of their application while they’re working in them, it’s often the QlikView server (our QIX engine) that’s to blame.

It might have crashed. Or might have just run out of resources, ramping up RAM and CPU usage until the entire system eventually crashes.

So, what do we do in a situation like this?

...View More

Qlik's latest version of NPrinting is now available on our download site!

...View More

Dear Qlik Sense users, we are pleased to confirm that Qlik Sense November 2018 feature release is now available on our download site. Qlik Sense Mobile November 2018 is also now available in the Apple store. These new feature releases include a host of new features as well as product defect fixes, you can find more information in the attached release notes. Please also note that Qlik Sense November 2018 users should apply Sense November 2018 Patch 1 which is also on the download site.Sense November FeaturesPrecendent based learning – Sense Machine Learning for smarter insights and results (limited to Qlik Sense Enterprise for Windows)Insight Advisor Light Authoring – more flexibility and adaptability from Insight Advisor (also available for Qlik Sense Cloud for Business)Alternate States now available without having to use API callsFully supported Dashboard Extension bundle is an option during installalationDate range picker, Navigation button, Tabbed container, Show/hide container and moreFor limitations on all extensions please seehttps://help.qlik.com/en-US/sense/November2018/Subsystems/Hub/Content/Sense_Hub/Visualizations/create-visualization-extensions.htmInsight sharing: detail on potential changes to the app or section accessQlik Sense Mobile November 2018 is available in the Apple store and includes several bug fixes.As always when upgrading any software, make sure that you backup your system and applications before doing any installation and follow upgrading best practices. Thank you for choosing Qlik software.Kind regardsThe Global Support Team ...View More

Good day all QlikView users, We are very happy to confirm that QlikView November 2018, otherwise known as QlikView 12.30 is now available on our download site. QlikView November 2018 is the latest feature release of QlikView and includes features including: Support for IPv6 New QlikView Server Engine log file New reload performance log New "File Exists" Supporting task in Publisher Load full tables from an analytic connections plugin Under the hood, QlikView now uses the Skia graphics library instead of the old GDI+. We have also implemented the official ICU standard for using time zone functions ConvertToLocalTime and LocalTime, non ICU values used in these functions will no longer return a value so please be sure to check your applications if you use these functions (you can disable this change, if needed). Note also that the ability to disable the "new" BNF parsing mode (introduced in QlikView November 2017) has been removed. Full details can be found in the release notes (attached and also KB article 000058766.). Support for .Net Framework 4.7.2 is now also included. QlikView November 2018 technical release version is 12.30.20000 and this release also includes many product defect fixes, all details can be found in the attached release notes. Remember to thoroughly test your applications and system before upgrading any software, make backups and follow best practices. Thank you for choosing Qlik software, if you need any help or assistance please contact us at Support. Kind regards Global Support Team ...View More

Commitment to our NPrinting customersSupport for Qlik NPrinting version16 is scheduled to end on March 31, 2019. However, based on customer feedback, Qlik has decided to continue Extended Support for all NPrinting 16 customers, who are current on maintenance, at no additional charge. Extended Support for NPrinting 16 will be available until March 31, 2020.The availability of Extended Support for NPrinting 16 is to provide our valued customers with ample time to migrate to a fully featured and supported Qlik NPrinting product and is not an indication that customers should stay on NPrinting 16 indefinitely. Over the next year, Qlik will focus on adding remaining gap features from NPrinting 16 to NPrinting 18+ such as On-Demand for Qlik Sense®, advanced search filters, task notifications, variable filters, select excluded filters as well as variables in the email subject line and body. Additionally, Qlik is working to provide a migration tool to help customers migrate their reports, connections, filters and tasks from NPrinting 16.Please find attached the full execute letter explaining this in detail, and the FAQ, or use the links below to view the documents.Executive Letter‌FAQ‌Thank you ...View More

Hello all NPrinting users,Qlik NPrinting June 2017 is now available on our download site. This release is the latest release for NPrinting and it includes several bug fixes. Please see the attached release notes for details regarding the bug fixes and the new features introduced in this version.Qlik NPrinting June 2017 is also the first Qlik Release following our new naming convention. We will now name major releases with the month and year of release.Thank you for choosing Qlik software!Kind regards,Global Support Team ...View More