Question

How do I convert a Qlik Sense Bar Chart to a Table without having to recreate the table?

Environment

• Qlik Sense: All supported versions

Solution:

• edit the Qlik Sense sheet containing the Bar Chart
• make a copy of the bar chart then convert it to a straight table by dragging the 'table' object onto the copied bar chart.
• click 'convert to table'

Result:

Use Case: NPrinting Reporting

Keep in mind that Qlik Sense bar charts are not supported for use as exportable data 'tables' with NPrinting. (See unsupported and partially supported objects here https://help.qlik.com/en-US/nprinting/Content/NPrinting/ReportsDevelopment/Qlik-objects-supported-NP.htm )

To use the data in the bar chart in an NPrniting report, you can simply follow the steps above and then

• Reload the NPrinting connection to this QS app
• find the new object is visible in the tables list

Then you can use the straight table data in your NPrinting report.

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.

Server Patch: https://da3hntz84uekx.cloudfront.net/QlikSense/13.51/18/_MSI/Qlik_Sense_update.exe

Desktop: https://da3hntz84uekx.cloudfront.net/QlikSenseDesktop/13.51/18/_MSI/Qlik_Sense_Desktop_setup.exe 

Server Patch: https://da3hntz84uekx.cloudfront.net/QlikSense/13.62/13/_MSI/Qlik_Sense_update.exe 

Desktop: https://da3hntz84uekx.cloudfront.net/QlikSenseDesktop/13.62/13/_MSI/Qlik_Sense_Desktop_setup.exe 

Server Patch: https://da3hntz84uekx.cloudfront.net/QlikSense/13.72/17/_MSI/Qlik_Sense_update.exe

Desktop: https://da3hntz84uekx.cloudfront.net/QlikSenseDesktop/13.72/17/_MSI/Qlik_Sense_Desktop_setup.exe 

A certificate error is displayed when you open the Qlik Sense Management Console or Hub:

There is a problem with this website's security certificate.

The end-user can click Continue to this website (not recommended) and successfully access Qlik Sense. 

Environment

• Qlik Sense Enterprise on Windows 

Qlik Sense Enterprise for Windows will by default use a self-signed certificate to allow for the use of HTTPS when accessing the Management Console (QMC) or the Hub. This certificate is by default not trusted, as it does not have a Trusted Certificate Authority. 

Resolution

Option 1: Use a signed certificate

1. Obtain a 3rd party certificate signed by a Trusted Certificate Authority (Enterprise CA, VeriSign, etc...).
2. Install the certificate as per Qlik Sense Hub and QMC with a custom SSL certificate.

Option 2: Import the currently used self-signed certificate to the client machines

Perform the following on the Microsoft IIS server or Certificate Server to import the Qlik Sense server certificate to the remote system used to access the Qlik Sense Management Console and Hub:

1. Open Microsoft Management Console (MMC) on the Qlik Sense server. Press Windows+R, type MMC, and press ENTER.
2. Add the Certificates snap-in using the computer account:
   1. Click File and select Add/Remove Snap-in. The Add or Remove Snap-ins window opens.
   2. Select Certificates and click Add.
   3. Select Computer account and click Next.
   4. Select Local computer (selected by default) and click Finish.
   5. Click OK. You now have a snap-in named Certificates (Local Computer) in MMC.
3. Export the Qlik Sense server certificate from MMC:
   1. Expand Certificates.
   2. Expand Trusted Root Certification Authorities and select the Certificates folder.
   3. Right-click the Qlik Sense server Root Certification Authority, and select All Tasks, Export. The Certificate Export Wizard opens.
   4. Select the following in the wizard: 
   5. Select Cryptographic Message Syntax Standard - PKCS #7 Certificates (.P7B).
   6. Select Include all certificates in the certification path if possible. 
   7. Click Next.
   8. Specify a file name.
   9. Click Next, Finish. This creates the file <chosen_filename>.p7b. 
   10. Copy <chosen_filename>.p7b to the remote system used to access the Qlik Sense Management console and Hub.
4. Install the certificate on the system using one of the following methods:
   1. Method 1 - Right-click the certificate file
      1. Right-click <chosen_filename>.p7b and select Install Certificate. The Certificate Import Wizard opens.
      2. Click Next.
      3. Select Place all certificates in the following store.
      4. Click Browse.
      5. Select Trusted Root Certification Authorities and click OK.
      6. Click Next, Finish.
   2. Method 2 - Import using Microsoft Internet Explorer
      1. Open Internet Explorer. 
      2. Select Tools, Internet options.
      3. Click the Content tab.
      4. Click Certificates.
      5. Select the Trusted Root Certification Authorities tab.
      6. Click Import. The Certificate Import Wizard opens.
      7. Click Next.
      8. Click Browse.
      9. Browse to and select the <chosen_filename>.p7b file.
      10. Click Next.
      11. Select Place all certificates in the following store and Trusted Root Certification Authorities.
      12. Click Next, Finish.

Related Content

Qlik Sense Hub and QMC with a custom SSL certificate
ERR_CERT_COMMON_NAME_INVALID when using 3rd party certificate  

End of Support for Qlik products follows Release Management Policy, as documented in the Product Terms found on the Qlik Site: On-Premise Products Release Management Policy.

For detailed information on end of life and release dates, see:

Qlik Replicate Product Lifecycle  

Some Qlik Sense actions, for example the update of new users, are failing. The Repository logs show this error message: "Sequence contains more than one element".

Environment

• Qlik Sense on Windows any versions

Resolution

The resolution requires some modifications on the database. This can require technical competence, so we recommend to contact Qlik Support and to provide a backup of the repository.

Cause

This issue is due to duplicated rows in a repository table. In most of the cases this occurs after an upgrade.

Internal Investigation ID(s)

QB-4618

Hi All, 

Can anyone help me how can I get User documents for a certain user alone in qlikview API. I have already searched method regarding this in QMS Api latest version. But still cannot come up with the solution. Is there any possibility to get user documents alone by passing the user and domain name with server id?

Suppose we have to compare two JSON objects and check for the key/values that are different in both objects, Compare Object block comes into use here. The output of compare object block might have null properties that means it can contain certain keys with null values. In order to get rid of these null properties we just use the 'Remove Empty Properties' formula available in the editor.

Usage : {removeemptyproperties: {$.compareObject}}

This would be useful when we are trying to update an endpoint based on the changes of source data with destination data where we will be comparing both and checking for the key/values that are different in both objects(source and destination). This will give an output object if there are different values for the same keys in both objects. There might be some fields that are missing in source data which would get listed out in the output of the compare object block. If you are trying to update an endpoint by checking if the output from compare object block is not empty that is updating an endpoint only if there is a difference between source and destination data this might cause an issue since compare object output will always list out null properties if there are missing fields in source data. In that case, add the 'Remove Empty Properties' formula to the output of compare object block. 

This article explains how in Blendr.io, variables can be shared between different templates in a bundle.

General idea

Store the variables in the CDP or in the Data Store and give them a unique identifier. It's best to use the {bundleguid} formula for this as it is unique for each installation of the bundle and can't be changed by a user.

When using the CDP, add variables using the "Upsert Custom Object By Key" block with {bundleguid} as a scope. This should be done during the setup or settings flow of a template. 

Storing variables to the Data Store is a bit more difficult as it needs to be created before any variables can be added. Create the Data Store in the setup flow of one of the templates inside the bundle. Then add new variables to it in the settings flow of the same or other templates. Use {bundleguid} as the name for the Data Store.

By implementing this, each bundle will have its own CDP/Data Store.

Use case: sharing trigger URLs between templates

When building bundles that contain triggered templates, the trigger URL of these templates will be different for each installation. So, hard coding it is not an option. (Triggered blends )

By storing the trigger URLs in the CDP (or Data Store), they can be accessed by other templates in the bundle. 
Once a URL is fetched, the corresponding template can be executed by using the Call URL block. 

1) Store the trigger URL by using the {url} formula:

2) Fetch the URL from the CDP/Data Store in a different template:

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.

Using Google as the IdP with the Qlik Sense Mobile (SaaS) app on either iOS or Android fails.

The following error is shown in the app:

Authorisation Error
Error 400: invalid_scope
Some requested scopes were invalid. {valid=[openid,
https://www.googleapis.com/auth/userinfo.profile,
https://www.googleapis.com/auth/userinfo.email],
invalid=[offline_access]}

Resolution

Set the Block_offline_access scope in your Google IdP Advanced settings in the Qlik Cloud console. 

Environment

Qlik Sense Mobile SaaS with Qlik Cloud 

Does Replicate support STARTTLS?

How to enable SSL for email notifications and set email with STARTTLS?

Environment:

Qlik Replicate version:  7.x
Qlik Enterprise Manager: 7.x

Currently, STARTTLS is not supported by Qlik Replicate.  We ask you to raise an enhancement request for this compatibility.

To submit a Feature Request, see Getting Started with Ideas.

Is there any way of putting explanation/details about table columns

Environment

• Qlik Sense Desktop, all versions
• Qlik Sense Enterprise, all versions

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.

Resolution

No it is not possible to add explanation/details in regular Qlik Sense charts. 

However, it is possible to add explanation/details in "Description" of Master items like below:

If adding details to regular Qlik Sense charts is necessary, please create custom extension or raise Feature request.