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 create a Support case in the Qlik Community Case Portal..

Here is a link to more information in the Support Knowledge Base:
https://community.qlik.com/t5/Knowledge/How-to-create-a-technical-case-in-the-support-case-portal/ta-p/1846171

1. To log a technical support case with Qlik, head to community.qlik.com and sign in.
   
   

    

   
   
   

    

   
   
   
2. Once logged in, you will have access to our Support Portal.
   
   Access it from the navigation ribbon at the top by clicking on Support.
   
   We’ll provide you with a direct link in the support martial for this video so that you can bookmark it. https://community.qlik.com/t5/Support/ct-p/qlikSupport

3. From here, we recommend to first search our Knowledge Base for known issues and resolutions for your query. If you still need assistance, click Create a Support Case.
   
   
   

    

   
   
   We’ll provide you with a direct link in the support martial for this video so that you can bookmark it: This link will open the support case overview https://community.qlik.com/t5/crmsupport/page
   
   
4. Begin by typing in a Title.
   
   Include a clear description of your issues. This will search our Community for you to provide suggestions and may already give you a solution!
   
   A clear description will also help our support agents begin work on your ticket sooner.
   
   

    

   
   
   
5. Type up a Description.
6. Since we are talking about technical cases today, choose Product Related from the Problem Type drop-down.
   
   

    

   
   
   
7. Choose the product category your issue is relevant to. Your choices are:
   
   

    

8. Choose the product
   
   

    

   
   
   
   
9. Choose a Severity
   
   

    

   
   
   
10. Depending on the product you’ve chosen, different forms will be displayed.
    
    Example: For SaaS related issues, an account will need to be provided, while client managed installation may ask for a product version number.
    
    Fill out the forms as detailed as possible to ensure quick handling when the case is initially received.
    
    
11. Attach log files and error message screenshots were where applicable.
    
    You can drag and drop the files directly into the provided space:
    
    

     

    
    
    
12. Click Create Case.

Transcript

This video will demonstrate how to create a Support case in the Qlik Community Case Portal.
Begin by signing in to Qlik Community

Once logged in, you will have access to our Case Portal.

Visit the Support space by clicking on Support at the top

From here, we recommend to first search our Knowledge Base for known issues and resolutions for your query.
If you still need assistance, click Create a Support Case.

Begin by typing in a Title.

Include a clear description of the issue you’re facing.
Specific error messages are recommended.
This will search our Community automatically and provide suggestions
As there may already be a solution available!

A clear description will help our support agents resolve your ticket sooner.

This should explain what was expected to happen,
what actually happened,
and anything that has already been attempted to resolve the issue.
Since this is about technical cases, choose Product Related from the Problem Type drop-down.

Choose the product category your issue is relevant to.
SaaS is for cloud based software deployments
Client Managed Data Analytics and Connectors is for On-premise installations like Qlik Sense, QlikView, NPrinting or related connectors
Client Managed Data Integration is for On-premise deployments like Qlik Replicate, Qlik Compose, Gold Client, etc.

Now select the product.

And choose a Severity based on the business impact of this problem
0 is for SaaS Outages
1 is for client managed products in production environments that are currently down.
2 is for severe business impacting issues
And severity 3 are for manageable disturbances that are manageable

Depending on the selected product, different forms will be displayed.

Example: For SaaS related issues, an account will need to be provided,
while client managed installation may ask for a product version number.

Complete the forms with as much detail as possible to ensure quick handling
Attach log files and error message screenshots if possible.

You can drag and drop the files directly into the provided space:

And finally, Click Create Case.
The new case will be visible in the Case Portal.
Here you can receive updates and communicate directly with the support agent investigating the case.

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 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

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 reviews prerequisites and demonstrates how to make a connection to a local database in Qlik Sense Business.

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

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

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 activate Qlik NPrinting using two methods: applying a license key and control number or with a LEF (License Enabler File) if there is no internet connectivity.

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

https://community.qlik.com/t5/Knowledge-Base/Qlik-NPrinting-Server-activation-using-16-digit-key-and-Offline/ta-p/1801099

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 activate QlikView Desktop using a license key & control number or using a LEF (License Enabler File) if there is no internet connectivity.

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

https://community.qlik.com/t5/Qlik-Support-Knowledge-Base/How-To-License-QlikView-Desktop-Client/ta-p/1712836

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 two methods of activating or "leasing a license" to your QlikView Desktop from QlikView Server.

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

https://community.qlik.com/t5/Qlik-Support-Knowledge-Base/How-To-Lease-License-From-QlikView-Server-To-QlikView-Desktop/ta-p/1710251

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 authenticate Qlik Sense Desktop using SaaS editions of Qlik Sense, including Qlik Sense Business and Qlik Sense Enterprise on Cloud services.

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

https://community.qlik.com/t5/Qlik-Support-Knowledge-Base/How-to-authenticate-Qlik-Sense-Desktop-against-SaaS-editions/ta-p/1723170

Video Transcript:

Hi and Welcome to Qlik Fix
This video will demonstrate how to authenticate Qlik Sense Desktop against SaaS editions of Qlik Sense.
Once you are logged on to your Cloud Hub tenant, in your user profile menu, go into your Profile Settings, and then into Tools.
Click on Download in order to download and install the latest Qlik Sense Desktop version.
If already downloaded and installed you can skip this step.
After Installing Qlik Sense Desktop, click on Authenticate.
This may cause a popup prompting for the user to allow QlikSenseBrowser to be opened.
The popup may be different for Firefox, and in Internet Explorer.
Click on Open or allow for Qlik Sense Desktop to open with the tenant authentication link button displayed.
Click on the link button and that will open the authentication page of the Identity Provider setup for your Qlik Sense tenant.
Next, insert your credentials and click login.
If Multi-factor authentication is enabled, you will be prompted for the code before Qlik Sense Desktop is fully authenticated.
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 YouTube 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.
Nailed it!

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

#QlikSupport