This video is part of the Qlik Fix Video series. If you found this video useful, check out the other Qlik Fix Videos.

This video demonstrates how to install Qlik Replicate.

Video Transcript:

Hi and Welcome to Qlik Fix
This video will demonstrate how to install Qlik Replicate.
First, you can download the installer file by logging into the Qlik Product download site of Qlik Community.
Expand the compressed file, right-click the installer and Run as Administrator.
The installer requires Microsoft .NET 4.8, so the wizard will install that first.
Click Next on the Qlik Replicate Install wizard
Read and agree to the customer agreement.
Set the location for program files. This location must be a local drive.
Now the location for the data files. This will be the location for all of the task information and log files It’s recommended that this be a large location and CAN be a network drive.
Here you have the option to install a local Replicate Server or if you had already installed Replicate on a Linux box, you could set this up to connect to that Linux based Replicate server.
We’re doing a fresh installation on this Windows machine.
Review the current settings and start to install.
Now, once it’s finished, I’ll check those newly installed Windows services:
The Qlik Replicate Server and Qlik Replicate UI server services. Both are running.
These services are by default set to run as Local System, but if you require that the services be run by a user account, that account must be a local administrator on this machine.
One tip, the data folder locations that we set during the installation for both the program files and the data files can be reviewed here.
To access the Qlik Replicate console, it can be found from the start menu.
This server has a self signed certificate, that why we’re seeing this warning.
Login using the service account that we used during the installation.
The first thing to do is to click on Register to enter the license for activation.
This should be a text file that was sent from Qlik. You can Open that text file and copy the contents and paste it in here OR
You can click on Load and navigate to that same file, and click on Register License.
That creates a communication with the Qlik licensing server, and now the Replicate server is registered.
To review the registered license from the Replicate console,
Click on the drop down menu, select Server
Click on License on the left, that here you can see the details of the registered license, like the expiration date. If you have an update to the license, you can always click on the Register License button from here and register a new or updated license.
Now Qlik Replicate is ready and you can begin to setup the specific end points you want to use.

I hope this helps.

This video is part of the Qlik Fix Video series. If you found this video useful, check out the other Qlik Fix Videos.

Environment

• Qlik Enterprise Manager
• Qlik Replicate

This video is part of the Qlik Fix Video series. If you found this video useful, check out the other Qlik Fix Videos.

Environment

• Qlik Compose

This video is part of the Qlik Fix Video series. If you found this video useful, check out the other Qlik Fix Videos.

Environment

• Qlik Replicate

This video demonstrates how to Restart a Qlik Replicate task from the Log Sequence Number or LSN for a Postgres source.

Attached is a downloadable .mp4 video file for those who cannot view YouTube videos.

Transcript

This video is part of the Qlik Fix Video series. If you found this video useful, check out the other Qlik Fix Videos.

This video demonstrates how to publish an app from Qlik Sense Enterprise on Windows to Qlik Cloud as a part of Qlik’s multi-cloud SaaS offering.

For more information:

https://help.qlik.com/en-US/sense-admin/May2021/Subsystems/DeployAdministerQSE/Content/Sense_DeployAdminister/Multi-Cloud/distributing-apps-QSEoW-to-QCS.htm

Attached is a downloadable .mp4 video file for those who cannot view YouTube videos.

Transcript:

Hi and Welcome to Qlik Fix.
This video will demonstrate how to publish an app from Qlik Sense Enterprise on Windows
to Qlik Cloud as a part of Qlik’s multi-cloud SaaS offering.
Start by verifying that the license being used in Qlik Sense Enterprise on Windows
is a Signed License Key. License Key plus control number method of licensing is not compatible with Multi-Cloud deployments.
This Signed License Key should also be the same one applied to our Tennant in Qlik Cloud.
To check, go to this license overview address.
And verify that the license key being used here is the same as on Qlik Sense on Windows.
Now to set up the Multi-Cloud Deployment
Go to the Cloud Distribution settings
And click on Set Up New Deployment at the bottom
We’ll give it a name. This will be referenced again later.
The API end point is your Tenant URL
Copy that
I’m going to use a local token to connect Qlik Sense on Windows with the Cloud deployment
And with the Qlik Cloud Services Format checked, copy the token
Now back to the Cloud Management Console
Identity Provider at the bottom
And Create New
Select – Multi-Cloud
And paste in the Local Bearer Token that we just copied from Qlik Sense on Windows.
And Create
To test the connection, go to Cloud Distribution in the QMC,
Deployment Setup, and click on Test Connection.
Now we need to create a custom property that will be used when publishing apps from Windows to the Cloud deployment.
This will be attached to applications that will be pushed to the cloud.
Click on Apps
And the value should match the deployment name that we entered before in the Multi-Cloud Setup Console.
Now for the apps that we want to publish,
Go into the app,
Edit,
and in Customer Properties
Specify the deployment we just setup, so that the setting is added to the app
The next step is to create a distribution policy
Create new
Let’s use a template for distribution
Add a name
Set the value to use the custom property
And Apply
Now let’s verify that the distribution happened by
Going back to the Cloud Hub
Refresh
And there it is. That has just been published from Qlik Sense Enterprise on Windows to the Qlik Cloud Hub.
This app is currently only accessible by one person.
To change this, go into Administration
Notice the alert about some apps in Staging Mode
Select the app
Click “Set Space”
And assign the app to a managed space so that other users can use the app.
Now back to the hub, in the details,
we can verify that the app is in the managed space.
Access to this space can be adjusted in the space settings.
Now let’s do this with a new app,
Let’s Import and example app to Qlik Sense on Windows.
Select the app, edit
Add the customer property
Apply
Now let’s publish the app.
Let’s publish it to a Stream on Windows
The publishing task applies the distribution policy
and the app will appear in both the Windows Hub Stream
and the Cloud Hub as a staged app.

I hope this helped.
If you'd like more information

Take advantage of the expertise of peers, product experts, Community MVPs and technical support engineers
by asking a question in a Qlik Product Forum.

Hiding in plain sight is the Search tool.
This engine allows you to search Qlik Knowledge Base Articles,
Qlik Community forums,
Help dot Qlik dot com, Qlik Gallery,
multiple Qlik YouTube channels and more, all from one place.

There’s also the Support space.
We recommend you subscribe to the Support Updates Blog,
And learn from Qlik experts via a webinar, like Techspert Talks or Q&A with Qlik.
Thanks for watching.
(music)
Nailed it!

This video is part of the Qlik Fix Video series. If you found this video useful, check out the other Qlik Fix Videos.

This video demonstrates how to view a License Enabler File or LEF and Control Number.

The instructions apply to obtaining your control number and LEF. Signed License Keys (SLK) are sent by email and need to be requested from Qlik Support.

1. Login to the Support Portal with your username and password.
   
             *If you do not have a Qlik account (username and password) please see the article How to Register for a Qlik Account
   
   
2. Click on License Information at the top of the page and select View My Licenses. 
   
   
   
   
3. Choose the appropriate license/s.
   
   
4. Click Request Control Number" or "Download LEF"
   
   For LEF downloads note that Pop-Up should be enabled on your browser to allow the above page to be shown.
   
   
   
   Clicking Download LEF provides the LEF immediately. 
   Request Control Number triggers an email that will arrive in a few minutes.  

Note:

If the authentication fails an error will appear. In this case, contact Qlik Support, providing the affected license key/s in the description that you wish to receive a control number for.

Related Content: 

The Signed License Key (SLK) and the License Enabler File (LEF)
How to license a QlikView or Qlik Sense server without Internet access
 

Transcript

This video will demonstrate how to view a license Enabler File or LEF and Control Number.

If you are looking for a Signed License Key,
this has been sent via email.
If you can’t find your Signed License Key, contact Support.
 
First visit Qliksupport.force.com/QS_Logininfo and login with your QlikID email address and password.

Click on License Information at the top of the page
and verify the account.

You will be shown a list of Active and Expired Licenses.

You can use the filter to search for a specific license.
Click the checkbox next to the license.
Then click on Request Control Number" or "Download LEF"

Clicking Download LEF provides the LEF immediately. 
Make sure that no pop up blockers are enabled that prevent the pop up from showing.

Request Control Number triggers an email that will arrive in a few minutes.  

I hope this helped.

If you'd like more information

Take advantage of the expertise of peers, product experts, Community MVPs and technical support engineers
by asking a question in a Qlik Product Forum.

Hiding in plain sight is perhaps the most powerful feature on the Community:
the Search tool.
This engine allows you to search Qlik Knowledge Base Articles,
Or across the Qlik Community,
Help dot Qlik dot com, Qlik Gallery,
multiple Qlik YouTube channels and more, all from one place.

There’s also the Support space.
We recommend you subscribe to the Support Updates Blog,
And learn directly from Qlik experts via a Support webinar, like Techspert Talks or Q&A with Qlik.

Nialed it.

This video is part of the Qlik Fix Video series. If you found this video useful, check out the other Qlik Fix Videos.

This video demonstrates how to restore the Qlik Sense Repository Database or QRS from a backup.

Here is a link to more information in the Support Knowledge Base:

How to backup or restore the PostgreSQL database in Qlik Sense

Attached is a downloadable .mp4 video file for those who cannot view YouTube videos.

#QlikSupport

Video Transcript:

Hi and welcome to Qlik Fix.

This video will demonstrate how to restore the Qlik Sense Repository database or QRS from a backup.

First, verify that only the Qlik Sense Repository database service is running on the machine.

The existing database will need to be removed prior to restoring the QRS backup.

This can be done using PG Admin – a standard database utility.

Open up PG Admin

Create a connection to the server machine hosting the Qlik Sense Repository database.

Port 4432

Postgres user and password.

Here you can see all of the tables where Qlik Sense stores data in the current database that will be dropped.

In PG Admin you could do this with the Delete/Drop option.

I’ll be using these commands copied from the Qlik help site.

Open a command prompt with Administrator privileges from the PostgreSQL 9.6 bin folder.

Copy and paste in the command

Connecting locally,

On port 4432

With the postgres user defined while installing

And dropping the current QSR database.

No other tasks should be running in parallel, so I’ll disconnect PG Admin.

Enter the password

And back to PG Admin to verify that the database has been removed.

You can see that QSR is gone.

Now, copy the Create DataBase command from the Documentation.

The Template0 will create a basic schema, but there will be no tables.

Copy

Paste and run the command

Done.

Back to PG Admin to illustrate.

The QSR has been created with a public schema, but with no tables.

Now we’re finally to the step of restoring from the backup.

This could be done in PG Admin via the Restore command,

Point to the backup tarball, hit restore,

But again, this is a demo of the manual method.

Copy the restore command.

You can see a variable here to the path to the backup file

Copy everything up to that point

Navigate to the QSR backup on an accessible shared drive folder.

Copy the backup locally.

This folder has been created on the local C drive called QSRBackup

An easy way to get the file path is to press Shift and right click,

then select “Copy as path”

Paste it at the end of the command

I recommend adding a “-V” to the command line so that you can actually see some more verbosity to what is happening.

Again, close any tasks or open connections to the database.

Enter the password

And there it goes.

To verify that the data is actually there,

Back to PG Admin one more time.

In the QSR database under tables, now there is all the content.

The QSR has been fully restored.

I hope this helped.

If you'd like more information

Search for answers using the Unified Search

tool on the Support Portal.

it searches across the Support Knowledge Base,

Qlik Community, Qlik Help site and Qlik YouTube channels.

Take advantage of the expertise of peers, product experts and technical support engineers

by asking a question in a Qlik product forum on Qlik Community

And don't forget to subscribe to the Support Updates Blog.

Thanks for watching!

Nailed it!

This video is part of the Qlik Fix Video series. If you found this video useful, check out the other Qlik Fix Videos.

This video demonstrates how to load an Excel file stored on SharePoint into Qlik Sense using the Qlik Office 365 SharePoint Connector found using Qlik Web Connectors.

Here is a link to more information in the Support Knowledge Base:

How to load an Excel file from sharePoint to Qlik Using Qlik Web Connectors

Here is more information on Qlik Web Connectors: Qlik Web Connectors

Attached is a downloadable .mp4 video file for those who cannot view YouTube videos.

#QlikSupport

This video is part of the Qlik Fix Video series. If you found this video useful, check out the other Qlik Fix Videos.

his video demonstrates how to create a new app in Qlik Sense Enterprise SaaS.

Here is a link to more information in the Support Knowledge Base:

Article - How to Create an App in Qlik Sense Enterprise SaaS

Related Content

Managing spaces in Qlik Sense Enterprise SaaS

Top 5 Things to Know When Using Qlik Sense Enterprise SaaS

Attached is a downloadable .mp4 video file for those who cannot view YouTube videos.

Video Transcript:

Hi and welcome to Qlik Fix.

This video will demonstrate how to create a new app in Qlik Sense SaaS.

First, login to your Qlik Sense SaaS tenant.

Logging in will redirect you to the tenant hub, on the home tab.

To create an app, click on the Add New button at the top.

Select New Analytics App.

Enter a name, select the space, there’s a link below to a video which discussed more about spaces.

A description and tags can also be added to help organize your apps.

And there it is. Click on the app to open.

First, you need to add some data. You can drag and drop or go into the script editor.

I’ll click the first option,

The Data Files location is available by default. You can see, there are some files that have already been added here in the past.

Select a file to add,

Qlik recognizes the format as an excel file.

Select the sheets, I’ll do all three in the file since the data is all inter-related.

Next.

This is the data manager. This is where connection between tables can be created.

You can see that the insight adviser is providing some recommendations automatically based on the data. I agree with that analysis and select Apply All.

The tables are connected

 And then press the  Load the Data button to load this data into memory.

Now you can use the insight advisor to create some visualizations, go to sheet to create them manually or continue in the Data Manager.

I’m going to Sheets.

Here are the data fields that have been loaded.

I’ll start with a simple bar chart. Drag that to the sheet.

It prompts to add a dimension and measure.

Add the dimension City, and the measure Sales, sum of Sales.

This chart now shows the sum of sales by city.

Click on the ‘Done editing’ button.

And now you can start to explore and analyze the data.

I hope this helps.

If you’d like more information,

Take advantage of the expertise of peers, product experts, and technical support engineers

by asking a question in a Qlik Product Forum on Qlik Community.

Or search for answers using the new SearchUnify tool.

It searches across our Knowledge Base, Qlik Help, Qlik Community, Qlik You Tube channels and more, all from one place.

Also check out the Support Programs space.

Here you can learn directly from Qlik experts via a Support webinar, like Techspert Thursdays.

And don’t forget to subscribe to the Support Updates Blog.

Thanks for watching.

This video is part of the Qlik Fix Video series. If you found this video useful, check out the other Qlik Fix Videos.

This video demonstrates how to find two different types of Qlik Connector log files: the Connector logs themselves, and the Driver logs.

Here is a link to more information in the Support Knowledge Base:

Article - How To Collect Logs From Qlik ODBC Connector Package

Attached is a downloadable .mp4 video file for those who cannot view YouTube videos.

#QlikSupport

Video Transcript:

Hi and welcome to Qlik Fix.
This video will demonstrate how to find the two different types of Qlik Connector log files, the Connector logs themselves, and the Driver logs.
Both types of log files will be necessary when investigating a Qlik Connector related issue.
The default location for Qlik Connector logs is on the C: drive
Program Data, Qlik, Custom Data.
There is a separate folder for each connector or connector package.
In this example, we’re be looking for an error with a connection to Microsoft SQL server, which is part of the ODBC Connector package.
The name of the log file begins with the name of the server machine where the Qlik Connector is installed.
Opening the log file, and scrolling to find the error message I’m interested in,
There was an error at this time, and it was a ‘Login failed’ error.
The connector log indicates the specific driver that was used for this connection,
in this case it’s MS SQL server, mssql.
That will be useful for the next step of turning on Driver logging.
By default, Driver logs are disabled.
To enable them while troubleshooting, Open the registry editor,
Locate the registry entries under Local Machine, Software, Qlik.
This folder contains subfolders for every driver that comes bundled with the ODBC connector package.
We want to look at the MS SQL Server, so locate this.
All of the subfolders have the same structure and similar registry settings.
Adjust the Log Level and Log Path settings.
The log level can be a value from 1 to 6, with 6 being the highest level of logging.
For troubleshooting connections, set this to 6.
It’s recommended to use the same path as the connector logs, just to make it easier to find all connector logs.
Copy that folder path.
Paste in the registry value for Log Path.
Save.
The next time the connection is attempted, the driver log file will be generated.
The file is called Qlik Server ODBC Driver.
There is a lot of information and tracing date in these files.
Be aware when driver logging is enabled, and disable them once troubleshooting and log file collection has been done.
The file size for these logs even when everything is working fine is quite large and will affect performance in a production environment if left on.

I hope this helped.

If you’d like more information,
Take advantage of the expertise of peers, product experts, and technical support engineers
by asking a question in a Qlik Product Forum on Qlik Community.
Or check out the Support Programs space.
Here you can search for answers in the Support Knowledge Base,
Learn directly from Qlik experts via a Support webinar, like Techspert Thursdays.
And don’t forget to subscribe to the Support Updates Blog.
Thanks for watching.

Nailed it!

This video is part of the Qlik Fix Video series. If you found this video useful, check out the other Qlik Fix Videos.

This video demonstrates how to install Qlik CLI, a tool to make API calls to Qlik Sense.

Here is a link to more information in the Support Knowledge Base:

Article - How to Install Qlik CLI

Attached is a downloadable .mp4 video file for those who cannot view YouTube videos.

#QlikSupport

Video Transcript:

Hi and welcome to Qlik Fix.
This video will demonstrate how to install Qlik CLI, a tool to make API calls to Qlik Sense.
It allows you to perform most of the same configuration changes that can be done in the QMC,
but via commands in PowerShell instead.
The Qlik CLI installer can be downloaded from GitHub. The link is below.
You’ll need to run the installation command from PowerShell 4.0 or newer.
The commands can be found on GitHub along with the installer.
First, download the installer files from here.
They will need to be unzipped to this folder under Program Files, Windows PowerShell, Modules.
Next, Open the PowerShell console with Administrator rights.
The first command is to Set the Execution Policy.
Next, be sure to run the install commands from the Qlik CLI folder.
And run the list of commands as documented to import the Qlik CLI module
Yes to all.
The installation has completed.
To verify the installation was successful, from the View menu, set PowerShell to Show Command Add-ons.
In the drop down, Qlik CLI should be an option now.
There is the Qlik CLI module.
All of the Qlik CLI commands are listed here.
From here you can copy the commands, or
You can even search for commands, like to see all of the tasks or run a task
I hope this helped.

If you’d like more information,
Take advantage of the expertise of peers, product experts, and technical support engineers
by asking a question in a Qlik Product Forum on Qlik Community.
Or check out the Support Programs space.
Here you can search for answers in the Support Knowledge Base,
Learn directly from Qlik experts via a Support webinar, like Techspert Thursdays.
And don’t forget to subscribe to the Support Updates Blog.
Thanks for watching.

Nailed it!

This video is part of the Qlik Fix Video series. If you found this video useful, check out the other Qlik Fix Videos.

This video demonstrates how to find important Qlik Connector details on Qlik Sense Enterprise SaaS.

Here is a link to more information in the Support Knowledge Base:

Article - How to Find Qlik Connector Details / Version

Attached is a downloadable .mp4 video file for those who cannot view YouTube videos.

#QlikSupport

Video Transcript:

Hi and welcome to Qlik Fix.
This video will demonstrate how to find important Qlik Connector details on Qlik Sense Enterprise SaaS.
However, the process is almost exactly the same in Qlik Sense Enterprise on Windows.

First open an app from the hub.
On the Prepare tab at the top, select the Data load editor
In the Data Connections panel, you can view the existing connections
Or clicking on Create a New Connection opens the wizard, and displays several available connection types
Select the type of connection that you’re interested in
And click on the Information icon
This displays the package and version of this specific connector.
The Amazon Redshift connector is part of the ODBC connector package.
Qlik Sense SaaS will always have the latest version available.
However, if you’re running Qlik Sense Enterprise on Windows, the version details can be important.
Just to show another example,
The Bitly connector,
Show the details.
This connector is part of the Qlik Web Connectors package.
If you have a support case open with Qlik investigating a data connection, please provide a screen shot of this windows or these details to help.

If you’d like more information,
Take advantage of the expertise of peers, product experts, and technical support engineers
by asking a question in a Qlik Product Forum on Qlik Community.
Or check out the Support Programs space.
Here you can search for answers in the Support Knowledge Base,
Learn directly from Qlik experts via a Support webinar, like Techspert Thursdays.
And don’t forget to subscribe to the Support Updates Blog.
Thanks for watching.

Nailed it!

This video is part of the Qlik Fix Video series. If you found this video useful, check out the other Qlik Fix Videos.

This video demonstrates how to generate API Keys in Qlik Sense Enterprise SaaS using APIs.

Here is a link to more information in the Support Knowledge Base:

Article - How to Generate API Keys with APIs in Qlik Sense Enterprise SaaS

Qlik.Dev: Generate Your First API Key

Help.Qlik.Com: API Key Documentation

Attached is a downloadable .mp4 video file for those who cannot view YouTube videos.

#QlikSupport

Video Transcript:

Hi and welcome to Qlik Fix.
This video will demonstrate how to setup API Keys in Qlik Sense Enterprise SaaS using APIs.

For this example, I’ll be using PowerShell to send requests to a Qlik Sense Enterprise tenant.
These will be the same actions that could be performed via the user interface in the Hub,
but will be done via APIs instead.
Here is a simple script that will allow you to generate an API key.
More details can be found on Qlik.Dev, under Tutorials, and Generate Your First API Key.
But I’ll show you how to find the same commands using browser developer tools.

First, in the tenant Management Console, under Integration,
API Keys should be enabled here.
You can find more information about this step on Qlik.Dev.
The link is below.
Set the max token expiration in days, and the number of API keys per user.
These settings help maintain system security.

To generate an API key,
From the Hub, in the profile menu, select Settings.
Then API Keys.
To see the API code to use, you can open Browser Developer tools in Chrome via F12 or
In the browser menu under more tools and Developer Tools.
Click on the Network tab.
Then perform the action of getting a new API key by clicking the Generate New Key button.
Give it a name, generate.
Here’s the key.
Now in the dev tools, the request for that command is shown.
You can copy that.
And pasting it here in the Powershell script, you can see that nothing has changed. So it’s the same script found in the tutorial on Qlik.Dev.
Scrolling a little further down in the body, you can see name and expiry time.
Run the command,
And here is the current API key that’s about to expire,
And here is the new API key.
you would need to run this command before the API Key expires to get a new Key
and update your code with the newer API Key.
This is a handy method for renewing API keys that are about to expire, because you only need to visit the user interface the first time.

To demonstrate what it looks like when something goes wrong,
I’ll use the wrong format in the Expiry field.
First, it’s showing that the maximum number of API keys has been reached.
To resolve that issue, I will delete an expired API key.
Back to PowerShell and try again.
This time, an “Invalid Property Value – 400” Error is given.
That’s just showing that the wrong format is being used. And you can always find the correct code to be used by performing the action in the UI and copying the code from the developer tools.

I hope this helped.

If you'd like more information
Search for answers using the Unified Search
tool on the Support Portal.
It searches across the Support Knowledge Base,
Qlik Community, Qlik Help site and Qlik YouTube channels.
Take advantage of the expertise of peers, product experts and technical support engineers
by asking a question in a Qlik product forum on Qlik Community
And don't forget to subscribe to the Support Updates Blog.
Thanks for watching!

Nailed it!

This video is part of the Qlik Fix Video series. If you found this video useful, check out the other Qlik Fix Videos.

This video will demonstrate the configuration steps necessary to start using iFrames or Mashups with Qlik Sense Enterprise for Windows.

Here is a link to more information in the Support Knowledge Base:

Qlik Sense for Windows: All you need to know to start using iFrames/Mashups

Attached is a downloadable .mp4 video file for those who cannot view YouTube videos.

#QlikSupport

Video Transcript:

This video will demonstrate the configuration steps necessary to start using iFrames or Mashups with Qlik Sense Enterprise for Windows.

To begin with, Qlik Sense installs a self-signed certificate by default. This will only be recognized as trusted on the Qlik Sense server itself. Opening the hub from another machine will present a warning.

For this reason, it’s recommended to use a 3rd party certificate on the proxy.

Here in the QMC, proxy settings, in security.

Paste the certificate thumbprint here.

For testing purposes, you can install the root certificate of Qlik Sense directly on the machine you want to test from.

The root certificate from the server machine will need to be installed on the testing machine in the Personal certificates folder.

You can find the thumbprint of that certificate by double-clicking on the certificate,

Go to the details tab, scroll down

And there you will find the thumbprint.

Copy that,

And paste it into the proxy security settings in the QMC

And apply.

Secondly, a decision should be made about the type of Authentication to use for mashups or iFrame in Qlik Sense.

The recommended method would be Ticket Authentication. It’s a simple process of calling the proxy API to get a ticket and band it to the URL to create a session with Qlik Sense.

JWT, SAML and Header are also good methods of authentication to use, but some considerations apply for each.

Windows authentication is not recommended in the context of iFrame or mashups because changes to security and domain policies can severely impact functionality and also it will not work on non-Windows devices.

The decision depends on your needs. Here is chart outlining those options and providing links to more detailed information.

Next, there is an attribute called SameSite on the cookie settings for modern browsers.

If this is not configured correctly, the browser will reject the cookie for the intended iFrame or mashup.

In the QMC, under Virtual Proxies

A new virtual proxy setting should be created.

Under Advanced,

The HTTPS attribute must be enabled. This setting will not work with insecure HTTP connections.

And here, it’s recommended to select None, as this will allow the parent website to be from a different domain.

By default this SameSite attribute is set to Lax, which means that the parent website must be on the same domain to be accepted.

Setting this to Strict will prevent mashups or iFrame from working.

If you are running a version of Qlik Sense Enterprise earlier than April 2020,

These attributes must be manually set on the proxy config file, if running one of the earlier releases on this list.

That proxy config file found

under program files > Qlik > Sense > Proxy and the proxy.exe.config file.

The next important setting is the Host White list.

Click to add a new value.

This should be the server that is hosting the new mashup or iFrame.

And apply.

If this is  not set, you might see a 400 Bad Request error in the browser, and the

“Http request Host is not allowed” warning message in the logs.

Finally, when using a multi-page mash-up, moving from one page to another, by default this action will close the session. This would result in losing selections when moving to a different page.

To change this behavior,

First, stop the Qlik Sense Engine Service.

Then open the Settings.ini file with administrator privileges, located in

ProgramData > Qlik > Sense > Engine

Add the EnableTTL=1 setting

And the Session preservation time is recommended to be set to 30 seconds.

Also, as with any setting change, a carriage return must be added after the last line.

I hope this helped.

If you'd like more information

Search for answers using the Unified Search

tool on the Support Portal.

It searches across the Support Knowledge Base,

Qlik Community, Qlik Help site and Qlik YouTube channels.

Take advantage of the expertise of peers, product experts and technical support engineers

by asking a question in a Qlik product forum on Qlik Community

And don't forget to subscribe to the Support Updates Blog.

Thanks for watching!

Nailed it!

This video is part of the Qlik Fix Video series. If you found this video useful, check out the other Qlik Fix Videos.

This video demonstrates how to find and sort Event logs from the Qlik Sense SaaS Management Console and reload logs from the hub.

Here is a link to more information in the Support Knowledge Base:

Qlik Cloud Services logs - Qlik SaaS solutions - QSEoCS - Qlik Sense Business - QSEoK

Managing Events - Help.Qlik.com

Attached is a downloadable .mp4 video file for those who cannot view YouTube videos.

#QlikSupport

Video Transcript:

Hi and welcome to Qlik Fix!

This video will demonstrate how to find and sort Event logs

from the Qlik Sense SaaS management console and reload logs from the hub.

First, if a reload task has failed. The easiest way to learn more is

From the hub, click on the three dots to see the available options with the app,

And select details.

From here, you can quickly see that last modified time.

Click on the reload history to see more.

Here you can identify the task in question

and review it from here or download it to investigate further.

It’s worth noting that the logs you see here are generated by manually triggering a reload or from scheduled reloads.

Loading the data from the script editor does not generate a log file.

From the Management Console, more logged activity can viewed.

In the Governance section under Events

Activities on the tenant are logged and can be reviewed from here.

The events can be filtered by the source,

By the event type to help you narrow your search.

Events are archived after 90 days.

If you need to review event information that has been archived,

There are instructions on Help.Qlik.Com for retrieving those archived events using the Qlik Audit API.

I hope this helped.

If you'd like more information

Search for answers using the Unified Search

tool on the Support Portal.

It searches across the Support Knowledge Base,

Qlik Community, Qlik Help site and Qlik YouTube channels.

Take advantage of the expertise of peers, product experts and technical support engineers

by asking a question in a Qlik product forum on Qlik Community

And don't forget to subscribe to the Support Updates Blog.

Thanks for watching!

Nailed it!

This video is part of the Qlik Fix Video series. If you found this video useful, check out the other Qlik Fix Videos.

This video will demonstrate how to embed a chart in an iFrame from Qlik Sense Enterprise SaaS using APIs.

Here is a link to more information in the Support Knowledge Base:
Qlik Cloud Services: How to embed a chart in an iFrame - Article

Video transcript:

Hi and welcome to Qlik Fix!

This video will demonstrate how to embed a chart in an iFrame from Qlik Sense Enterprise SaaS using APIs.

First, from your Qlik tenant management console, in the Integration settings

Under Web, click on Create New to start the web integration setup.

Enter the name of the WebServer. In this case, this is the name of my IIS server.

Add that name address as an allowed origin.

This is the Web Integration ID that will be used later.

Also, create the content Security Policy.

In this example, the same name is used.

Select Frame Ancestors

Add.

This setting allows embedding only from the parent website listed here.

Next, copy the script from example in this article on Qlik Community,

Paste it into a new file using Visual Studio Code.

Save it with the html extension.

Next, replace “YourTenant” with the actual name of your Qlik Sense SaaS tenant.

Cntrl F will open this find replace window.

Then copy the Web Integration ID that was just created.

Paste it into the script here.

Now the link to the Qlik app object you want to embed is needed.

This example will use the demo app “Consumer Sales”.

This app is available for download from Demos dot Qlik dot com

I’ll fetch this map object here.

Just right click.

Choose “Share”

And then “Embed”

Here is the iFrame link. Just click on the Copy button.

And replace this whole block here by pasting in the link.

Save the file.

Now place the file where the webservice can read it.

This is the IIS root folder.

I will run chrome as a different user to show how this sample code will redirect to your identify provider.

I’m adding a new person in Chrome.

Now, enter the name of the IIS webserver and the page that was just created.

The IDP or Identify provider in this case is Auth 0

The iFrame is loaded.

And Qlik map object can be seen and interacted with.

I hope this helped.

Attached is a downloadable .mp4 video file for those who cannot view YouTube videos.

#QlikSupport

This video is part of the Qlik Fix Video series. If you found this video useful, check out the other Qlik Fix Videos.

This video demonstrates how to backup the Qlik Sense Repository Database.

Here is a link to more information in the Support Knowledge Base:

How to backup or restore the PostgreSQL database in Qlik Sense 

Attached is a downloadable .mp4 video file for those who cannot view YouTube videos.

#QlikSupport

Video Transcript:

Hi and welcome to Qlik Fix!

This video will demonstrate how to backup the Qlik Sense Repository database.

These instructions are found on Help.Qlik.com in the “backing up a Qlik Sense Site “ documentation.

First, you need to stop all of the Qlik Sense Services

EXCEPT the Qlik Sense Repository Database on every node in your deployment.

Next, open a command prompt with administrator privileges on the machine hosting the database

This should be done from the PostgreSQL 9.6 bin folder

Copy, this command from the documentation and paste it in the command line.

PG_DUMP is a built-in command for Postgres utilities that comes with the Qlik Sense installation

The host, LocalHost means this machine has the repository.

The port

The database user defined when installing

The destination path of the backup.

I’m saving this to a new shared folder I’ve made on this machine.

And the target database, QSR – this is required.

I recommend adding a “-V” to add some verbosity so that you can actually see the backup taking place.

Enter

And enter the postgres user password

And done.

Now, just verifying that the back-up has been made.

There it is.

I hope this helped.

If you'd like more information

Search for answers using the Unified Search

tool on the Support Portal.

it searches across the Support Knowledge Base,

Qlik Community, Qlik Help site and Qlik YouTube channels.

Take advantage of the expertise of peers, product experts and technical support engineers

by asking a question in a Qlik product forum on Qlik Community

And don't forget to subscribe to the Support Updates Blog.

Thanks for watching!

Nailed it!

This video is part of the Qlik Fix Video series. If you found this video useful, check out the other Qlik Fix Videos.

This video demonstrates how to upload QlikView documents to your Qlik Sense hub on Qlik Sense Enterprise SaaS.

Here is a link to more information in the Support Knowledge Base:

https://support.qlik.com/articles/000109693

Attached is a downloadable .mp4 video file for those who cannot view YouTube videos.

#QlikSupport