Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Search our knowledge base, curated by global Support, for answers ranging from account questions to troubleshooting error messages.
Qlik offers a wide range of channels to assist you in troubleshooting, answering frequently asked questions, and getting in touch with our technical experts. In this article, we guide you through all available avenues to secure your best possible experience.
For details on our terms and conditions, review the Qlik Support Policy.
Index:
We're happy to help! Here's a breakdown of resources for each type of need.
Support | Professional Services (*) | |
Reactively fixes technical issues as well as answers narrowly defined specific questions. Handles administrative issues to keep the product up-to-date and functioning. | Proactively accelerates projects, reduces risk, and achieves optimal configurations. Delivers expert help for training, planning, implementation, and performance improvement. | |
|
|
(*) reach out to your Account Manager or Customer Success Manager
Your first line of support: https://community.qlik.com/
Looking for content? Type your question into our global search bar:
Leverage the enhanced and continuously updated Knowledge Base to find solutions to your questions and best practice guides. Bookmark this page for quick access!
Subscribe to maximize your Qlik experience!
The Support Updates Blog
The Support Updates blog delivers important and useful Qlik Support information about end-of-product support, new service releases, and general support topics. (click)
The Qlik Design Blog
The Design blog is all about product and Qlik solutions, such as scripting, data modelling, visual design, extensions, best practices, and more! (click)
The Product Innovation Blog
By reading the Product Innovation blog, you will learn about what's new across all of the products in our growing Qlik product portfolio. (click)
Q&A with Qlik
Live sessions with Qlik Experts in which we focus on your questions.
Techspert Talks
Techspert Talks is a free webinar to facilitate knowledge sharing held on a monthly basis.
Technical Adoption Workshops
Our in depth, hands-on workshops allow new Qlik Cloud Admins to build alongside Qlik Experts.
Qlik Fix
Qlik Fix is a series of short video with helpful solutions for Qlik customers and partners.
Suggest an idea, and influence the next generation of Qlik features!
Search & Submit Ideas
Ideation Guidelines
Get the full value of the community.
Register a Qlik ID:
Incidents are supported through our Chat, by clicking Chat Now on any Support Page across Qlik Community.
To raise a new issue, all you need to do is chat with us. With this, we can:
Log in to manage and track your active cases in Manage Cases. (click)
Please note: to create a new case, it is easiest to do so via our chat (see above). Our chat will log your case through a series of guided intake questions.
When creating a case, you will be prompted to enter problem type and issue level. Definitions shared below:
Select Account Related for issues with your account, licenses, downloads, or payment.
Select Product Related for technical issues with Qlik products and platforms.
If your issue is account related, you will be asked to select a Priority level:
Select Medium/Low if the system is accessible, but there are some functional limitations that are not critical in the daily operation.
Select High if there are significant impacts on normal work or performance.
Select Urgent if there are major impacts on business-critical work or performance.
If your issue is product related, you will be asked to select a Severity level:
Severity 1: Qlik production software is down or not available, but not because of scheduled maintenance and/or upgrades.
Severity 2: Major functionality is not working in accordance with the technical specifications in documentation or significant performance degradation is experienced so that critical business operations cannot be performed.
Severity 3: Any error that is not Severity 1 Error or Severity 2 Issue. For more information, visit our Qlik Support Policy.
If you require a support case escalation, you have two options:
A collection of useful links.
Qlik Cloud Status Page
Keep up to date with Qlik Cloud's status.
Support Policy
Review our Service Level Agreements and License Agreements.
Live Chat and Case Portal
Your one stop to contact us.
While using Qlik Sense Desktop on windows 10 with high DPI machine specifically screen resolution set to 150%, Sense app won't fit to the full screen resolution.
Compatibility issue with Qlik Sense and the resolution of the monitor(s).
Note: If Qlik Sense Desktop is already running, please close it before following the DPI scaling steps.
When adding an alternate measure or alternate dimension to Tree map, Box plot, Distribution plot, or Histogram chart types, the newly added measures or dimensions are only visible via the Exploration menu.
This is working as designed.
To apply an alternative dimension or measure to a Tree map, Box plot, Distribution plot, or Histogram chart object, it must be done via the Exploration menu. To access the Exploration menu, hover over the chart object (the middle icon), and then select the different dimensions or measures associated with the chart object.
Qlik Sense Enterprise on Windows
Qlik Sense Business
Qlik Cloud
QLIK-96555
Working with Qlik Sense in mashups or other integrations such as Sharepoint can lead to issues with a SameSite attribute.
Qlik Sense will show the error:
You cannot access Qlik Sense because you have too many sessions active in parallel
The error seen in Chrome is:
"A cookie associated with a cross-site resource at ....[URL]... was set without the `SameSite` attribute. It has been blocked, as Chrome now only delivers cookies with cross-site requests if they are set with `SameSite=None` and `Secure`. You can review cookies in developer tools under Application>Storage>Cookies and see more details at https://www.chromestatus.com/feature/5088147346030592 and https://www.chromestatus.com/feature/5633521622188032."
Even though this comes from the Chrome console, other browsers as Mozilla and Edge are also displaying similar warnings. Is there a way around this error?
Also see Community post Cross-Site requests with cookies without the SameSite attribute are being blocked by Google Chrome
NOTE: This issue does not impact NPrinting and no NPrinting patches are required
Environment:
This is a new CORS security standard/feature that browsers are now enforcing, or beginning to enforce as developers begin to opt in. More information is available here https://www.chromestatus.com/feature/5088147346030592 and here https://www.chromestatus.com/feature/5633521622188032 as the above error mentions.
Product Defect ID(s):
The issue has been fixed by setting the attribute SameSite=None. It is possible to change the SameSiteAttribute values if needed as described below.
Note! Please review the list of Patches from which Qlik has made the changes possible.
The SameSite attribute is set directly in the GUI of the Virtual Proxy settings.
Qlik Sense February 2020
Qlik Sense November 2018 Patch 8 Update 1
Qlik Sense February 2019 Patch 7
Qlik Sense April 2019 Patch 7
Qlik Sense June 2019 Patch 10
Qlik Sense September 2019 Patch 6
Qlik Sense November 2019 Patch 5
The default behavior for https is to set SameSite=None. The default behavior for http is not to set SameSite attribute, neither the Secure attribute, just like it was before this change. Other behaviors can be configured. This change is available in all patches listed above. By default above applies. If you wish to configure other values, do the following:
1. Open the Proxy.exe.config file, which by default is located in "C:\Program Files\Qlik\Sense\Proxy".
2. Add following strings in the section <appSettings> with the desired values, in example:
<add key="SessionCookieSettings.Https.HasSecureAttribute" value="true"/>
<add key="SessionCookieSettings.Https.SameSiteAttribute" value="None"/> <!-- Valid values are NoAttribute, None, Lax and Strict -->
<add key="SessionCookieSettings.Http.HasSecureAttribute" value="false"/>
<add key="SessionCookieSettings.Http.SameSiteAttribute" value="None"/> <!-- Valid values are NoAttribute, None, Lax and Strict -->
3. Restart Qlik Sense Proxy Service.
4. Repeat above actions on each node of the cluster running the Qlik Sense Proxy Service.
NOTE:
The fix does have some limitations, bugs in older browsers can cause the following:
Browser | Bug | Effect |
Chrome 51-66 Android releases before 12.13.2 |
SameSite=None cookies are rejected | External mashups will not work |
Safari on MacOS 10.14 All browsers on iOS 12 |
SameSite=None is treated as SameSite=Strict |
To help Qlik customers manage costs more effectively, Qlik has developed the Qlik Snowflake Monitoring application, designed to provide invaluable insights about your Snowflake costs, usage, inventory, security, performance and contract utilization. This app utilizes Qlik's Associative Engine to connect directly to your Snowflake instance and reveal insights from Snowflake's detailed metadata, offering valuable information that traditional query-based tools and Snowflake's own reports are unable to provide.
Leveraging Qlik Application Automation, and Data Alerts, you can:
*Minor configuration is required on first run to create the required data connections.
Content:
This automation template is a fully guided installer/updater for the Qlik Snowflake Monitor. Leverage this automation template to easily install and update this application. The application itself is community-supported; and it is provided through Qlik’s Open-Source Software GitHub and thus is subject to Qlik’s open-source guidelines & policies.
For more information, refer to the GitHub Repository.
If the monitoring app was installed manually (i.e. not through the application automation installer), then the app will not be detected as existing. The automation will install new copies side-by-side. Any subsequent executions of the automation will detect the newly installed monitoring application and check their versions. This is because the application is tagged with ‘QCS - QSM - {App Name}’ and ‘QCS – QSM - {Version}’ during the installation process through the automation. Manually installed applications will not have these tags and therefore will not be detected.
The Qlik Snowflake Monitor requires two connections, one to your Snowflake instance to feed the data for your analytics, and one REST connection to the qlik-oss repository to run a version check on the monitor.
You will need to create a custom User, Role and Warehouse on your snowflake tenant. This is to ensure this user and role can see the monitoring details and can be monitored.
For Authentication, this setup is defaulted to username & password.
Finally, you need to name the connection as follows:
If you wish to use an alternative authentication method, please follow the documentation accordingly on both Snowflake & Qlik.
The REST connection is used to fetch version details from the GitHub repository. On reload it will look for the the latest released version in github and check this against the version you have installed. You can later use this in ‘Part Three’ to create an alert when updates to the application are available. To create a REST connection the following information is required:
Once these two connections have been set up, you can reload the application. The application has been created to accommodate Snowflake tenants of all sizes. If you have a small tenant, you will find the initial run of the load script can take around 30 minutes, and for larger tenants this can be over an hour or two. Subsequent runs will utilize cached QVDs that update daily to reduce reload times each subsequent day.
If a new release of the application is made, occasionally a full reload of data is required, but generally, if the data schema is unchanged the existing QVDs will be maintained. This is through the use of versions in the names of the QVDs used to store the data.
The application has the following two variables:
To create a new Data Alert for updates to the monitoring app, follow these steps:
The Qlik Snowflake Monitor can be easily installed by following these steps above. If you wish to find out more, check out this Ometis blog post and this Ometis Webinar to get a run through of the analytics this application can offer.
If you face any issues, please use the GitHub and raise an issue through the repository.
This articles describes how to allow the task executions/tac/tmc api call pick up all necessary certificates when facing a "SSLHandshakeException: unable to find valid certification path to requested target" error.
1. Use the following command (replace the api.anaplan.com to target url used by user), it will generate several crt files for step 2 import
echo "" |
openssl s_client -showcerts -connect api.anaplan.com:443 |
awk '/BEGIN/ { i++; } /BEGIN/, /END/ { print > "a-cert-" i ".crt" }'
Install openssl awk command before using it, it could be found in bash(linux)/git-bash(windows)
2. Use keytool -import to target keystore file. If you did not use tSetKeystore specifically, then youcan import it to jvm used by the Talend product.
keytool -import -trustcacerts -alias xxxcert-1 -file /temp/a-cert-1.cer -keystore jvm/lib/security/cacerts -storepass changeit
keytool -import -trustcacerts -alias xxxcert-2 -file /temp/a-cert-2.cer -keystore jvm/lib/security/cacerts -storepass changeit
keytool -import -trustcacerts -alias xxxcert-3 -file /temp/a-cert-3.cer -keystore jvm/lib/security/cacerts -storepass changeit
For more info about keytool -import, see the Import the Certificate as a Trusted Certificate page on the Oracle Java Tutorials site.
talenduser ALL=(ALL) NOPASSWD: /etc/init.d/talend-remote-engine-service start
talenduser ALL=(ALL) NOPASSWD: /etc/init.d/talend-remote-engine-service stop
Installing Talend Remote Engine
Adding URLs to your proxy and firewall allowlist
Installing and uninstalling Remote Engine service (systemd)
The Oracle source endpoint occasionally encounters an error during the CDC stage.
The error message in task log file:
[SOURCE_CAPTURE ]T: OCI error 'ORA-12592: TNS:bad packet' [1022307] (oradcdc_bfileapi.c:312)
The issue specifically arises during the CDC stage; The problem is irrelevant to the Oracle instant client version, and it's not a timeout issue (parameter SQLNET.SEND_TIMEOUT).
Oracle SQLNet packet inspection feature in Firewall (sometimes called as Advanced SQL feature in Firewalls) has been causing the TNS bad packet ORA-12592 error.
#00156619, QB-26584
When embedding a sheet in Single Configurator, the user notices a blank area on the top
This is working as designed and can't be changed. It is a limitation that the sheet tile cannot be exported. See Downloading a visualization.
Change the value in css file to reduce the padding size:
With Qlik Application Automation, you can get data out of Qlik Cloud and distributing it to different users in formatted Excel. The workflow can be automated by leveraging the connectors for Office 365, specifically Microsoft SharePoint and Microsoft Excel.
Here I share two example Qlik Application Automation workspaces that you can use and modify to suit your requirements.
Content:
Video:
Note - These instructions assume you have already created connections as required in Example 1.
This On-Demand Report Automation can be used across multiple apps and tables. Simply copy the extension object between apps & sheets, and update the Object ID (Measure 3) for each instance.
The information in this article is provided as-is and to be used at own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support.
When running the executescript goal a nullpointer exception occured when trying to execute the ChangeMavenVersion command.
Remove --subjobs flag.
A --subjobs flag was used in the script, which caused the nullpointer exception:
java.lang.NullPointerException
at org.talend.commandline.util.ItemsHelper.getAllSubjobs(ItemsHelper.java:890)
Why tLogcatcher / tStatCatcher components are not available for big data Spark batch?
tLogcatcher / tStatCatcher components are not available that is because :
Customers using 2023.11-SP02 (2023.11.282) with Snowflake as the target endpoint are requested to upgrade to 2023.11-SP03 (2023.11.468) as soon as possible.
Replication to a Snowflake target from a source table with LOB columns fails with Qlik Replicate 2023.11.282. This is caused by Qlik Replicate attempting to create varchar(0) columns in the attrep_changes table for the LOB columns.
The error seen is:
2024-03-19T13:46:33:290153 [TARGET_APPLY ]I: RetCode: SQL_ERROR SqlState: 42601 NativeError: 1810 Message: SQL compilation error: error line 1 at position 266 Invalid character length: 0. Must be between 1 and 16,777,216. [1022502] (ar_odbc_stmt.c:5090)
Upgrade to 2023.11-sp03 (2023.11.468).
2023.11-SP03 (2023.11.468).
Product Defect ID: RECOB-8179
This article provides a list of the best practices for Qlik Sense configuration. It is worth implementing each item, especially for a large environment so that your database can handle the volume of requests coming from all its connected nodes.
For basic information, see Max Connections.
Specifies the maximum number of concurrent connections (max_connections) to the database. The default value for a single server is 100.
In a multi-node environment, this should be adjusted to the sum of all repository connection pools + 20. By default, this value is 110 per node.
Assuming two nodes and assuming the default value of 110 per node, the value would be 240.
The value of 110 above is a default example. You can further refine the value.
The connection pool for the Qlik Sense Repository is always based on core count on the machine. To date, our advise is to take the core count of your machine and multiply it by five. This will be your max connection pool for the Repository Service for that node.
This should be a factor of CPU cores multiplied by five.
If 90 is higher than that result, leave 90 in place. Never decrease it.
For more information about Database Max Pool Size Connection, see https://wiki.postgresql.org/wiki/Number_Of_Database_Connections
Optimizing Performance for Qlik Sense Enterprise
PostgreSQL: postgresql.conf and pg_hba.conf explained
Database connection max pool reached in Qlik Sense Enterprise on Windows
This article provides an overview of how to send straight table data to email as an HTML table using Qlik Application Automation.
The template is available on the template picker. You can find it by navigating to Add new -> New automation -> Search templates and searching for 'Send straight table data to email as table' in the search bar, and clicking the Use template option.
You will find a version of this automation attached to this article: "Send-straight-table-data-to-email -as-HTML-table.json".
Content:
The following steps describe how to build the demo automation:
An example output of the email sent:
The information in this article is provided as-is and will be used at your discretion. Depending on the tool(s) used, customization(s)andor other factors, ongoing support on the solution below may not be provided by Qlik Support.
How to export more than 100k cells using Get Straight Table Data Block
The basic idea behind this procedure is that by default, the data repository of Replicate is encrypted by a machine key which is unique for each machine.
This means, you cannot move the data repository to another Replicate server because that server data repository is encrypted by that server’s machine key which is obviously different.
To allow that procedure, you’ll need to re-encrypt the source data repository with a predefined password which is not machine related, and this password can be used on the target machine to access that repository after it is migrated.
The information in this article is provided as-is and to be used at own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support.
Note: Re-encrypting the data repository requires you to re-enter the endpoint passwords, therefore we strongly recommend encrypting the repository with a predefined key right after installation, before you set endpoints and tasks on the machine.
Since the Server and UI are using 2 different keys, both keys will need to be updated using the following procedure:
Server->User Permissions
Please add a domain user, grant it “Admin” access level, and save the new settings.
Please reopen the console and make sure you can access the console with the credentials of the domain user.
The above step is needed because otherwise you won’t have a valid user to open the console on the target machine.
“Attunity Replicate Command line”
Important: For all the repctl commands below, if the data directory is not in the default location, you must specify the full path to the data directory by using the "-d" switch immediately following "repctl" followed by the rest of the command:
repctl -d "YOUR_DATA_DIRECTORY_PATH"
Run the following command to set the Replicate server key:
C:\Program Files\Attunity\Replicate\bin>repctl setmasterkey master_key_scope=1
master_key=Server_Master_key
[setmasterkey command] Succeeded
C:\Program Files\Attunity\Replicate\bin>RepUiCtl.exe utils genpassword
miBqZuBFgOJevgCt9myBqiWYjZKAdnEn
Note: you must save this password in a safe place for future use
Now, you can set the above password using the following command:
C:\Program Files\Attunity\Replicate\bin>RepUiCtl.exe masterukey set -p miBqZuBFg
OJevgCt9myBqiWYjZKAdnEn
The master user password has been changed. The change will only take effect after the service is restarted.
Replicate Control Program completed successfully.
AttunityReplicateServer
AttunityReplicateConsole
ServiceConfiguration.xml
This file refers to the source machine name and is not valid on the target machine, starting the services on the target machine will create the file from scratch, matching localhost.
C:\Program Files\Attunity\Replicate\bin>RepUiCtl.exe masterukey set -p miBqZuBFg
OJevgCt9myBqiWYjZKAdnEn
From Qlik Sense February 2023 onwards, apps listed in the Qlik Sense Management Console (Apps view) are now represented with clickable links. Clicking them will open the app directly on the hub.
This means the app names are no longer plain grey text but are now formatted as links (blue, underline). See Apps for details.
Example:
To disable clickable links in the Management Console:
Using only a custom virtual proxy prefix is currently not compatible. The default virtual proxy prefix must be accessible as the link generated will always refer to it.
Qlik is actively working on improving this feature: SHEND-1197.
Qlik Sense Enterprise on Windows February 2023 and above
One of the most common issues when creating a visualization is not understanding the best ways to display your data. Especially if you are just getting started creating charts or if you have existing data sets that you seek to visualize. It’s natural if you have a goal in mind and know which chart to rely on, but if you are just beginning to visualize data, basic mistakes are quite common.
Click here to download a complete guide to visualization and discover new methods to map your data to visualizations by Patrik Lundblad.
Unable to uninstall Qlik Sense Patches during Qlik Sense patch process .
Unable to uninstall Qlik Sense Patches through "Control Panel > Program > Program and Features >Installed Updates".
For example:
After a Qlik Sense upgrade, the Qlik Sense Repository service fails to start. The following error is logged in the Windows Application Event log:
Description: The application requested process termination through System.Environment.FailFast(string message).
Message: Unhandled exception: Could not load file or assembly 'Qlik.Sense.Logging, Version=37.3.0.0, Culture=neutral, PublicKeyToken=1a848309662c81e5' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)
System.IO.FileLoadException: Could not load file or assembly 'Qlik.Sense.Logging, Version=37.3.0.0, Culture=neutral, PublicKeyToken=1a848309662c81e5' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)
File name: 'Qlik.Sense.Logging, Version=37.3.0.0, Culture=neutral, PublicKeyToken=1a848309662c81e5'
at Repository.QRSService.Start(Action`1 terminate)
at
The initial recommendation is to repair the installation. See How to repair an installation.
If the repair does not resolve the problem:
The Qlik.Sense.Logging.dll present in [Installation Qlik Sense folder]\Repository\ was missing required inforamtion.