Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Here you'll find the recordings of our Qlik Fix video series.
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
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 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 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 demonstrates how to reload data after migrating a QlikView document to Qlik Sense using the QlikView Converter tool in DevHub.
Here is a link to more information in the Support Knowledge Base:
How to reload data after using the QlikView Converter tool
Video Transcript:
Hi and Welcome to Qlik Fix
This video demonstrates how to reload a recently converted QlikView document in Qlik Sense.
When converting a QlikView document to a Qlik Sense app using the QlikView Converter tool, the load script connection string remains unchanged.
The connection string format is specific to QlikView load script, which allows for absolute and relative paths as well as for connection string parameters to be stated directly in the script.
So when attempting to reload the app with the original connection string, the error seen here will be displayed:
"CONNECTs other than LIB CONNECT are not available in this script mode"
In Qlik Sense, Legacy (QlikView) mode can be enabled by disabling Standard mode under the Engine's configuration in QMC.
However, this is not a recommended practice due to security considerations.
Also, Legacy mode is not supported in Qlik Sense SaaS editions.
In Qlik Sense, connection string information is stored in the Qlik Sense Reporsitory postgres database (QSR). These connections are then listed in the QMC under Data Connections.
In this example, we see that the QlikView ODBC Connector Package SQL driver is used to connect to a SQL database.
However, this issue is observed regardless of the source database type, and even if Windows ODBC Data Sources Names (DSN) are used.
In order to correct the issue a new Data Connection record that contains this connection string information needs to be created and used instead.
The Qlik Sense Installation includes by default the QVOdbcConnectorPackage drivers so the Microsoft SQL Connector can be selected.
In another scenario where an ODBC DSN is used instead, the first step would be to create an ODBC System DSN using the Windows ODBC Data Source Administrator on all Qlik Sense Server nodes used for reloading the data.
Then, select this new DSN when creating the new ODBC Data Connection.
Next, simply click on the "Insert connection string" button for the Data Connection created
Make sure to remove or comment out the old connection string.
You can alternatively re-select the data that is needed by the app and then insert the Load script.
The reload of the app should now succeed and future reloads may be scheduled via Tasks.
If the app is uploaded to Qlik Sense SaaS, a new connection will need to be created as well accordingly.
Note that in SaaS, the Data Connections are stored within Spaces.
If the application is moved to another Space, and the user scheduling or running app reloads does not have access to the original Space, then re-creating the Data Connection in the new Space is necessary.
Under the Space Data Sources click on "Add connection" and configure the connection.
Thanks for watching!
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 enable automatic user group creation when using Auth0 and Okta Identity Providers in Qlik Sense Enterprise SaaS.
Here is a link to more information in the Support Knowledge Base:
How to Enable User Groups in Qlik Sense Enterprise SaaS
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 use Spaces to manage access to published QlikView documents and links in Qlik Sense Enterprise SaaS.
Here is a link to more information in the Support Knowledge Base:
How to Manage Access to QlikView documents and links in Qlik Sense Enterprise SaaS
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 configure QlikView Cloud Deployment and publish a document to Qlik Sense Enterprise SaaS
Here is a link to more information in the Support Knowledge Base:
How to configure QlikView Multi-Cloud deployment and App distribution
Attached is a downloadable .mp4 video file for those who cannot view YouTube videos.
#QlikSupport