Techspert Talks is a free webinar held on a monthly basis, where you can hear directly from Qlik Techsperts on topics that are relevant to Customers and Partners today.
Experience the convenience of a smarter, more efficient file management system today!
We have introduced our new Enhanced File Management feature in Qlik Cloud—making organization effortless. Now you can seamlessly structure your uploaded and cloud-generated files into directories and subdirectories, giving you full control over your data.
With batch actions like move, copy, cut, and paste, managing multiple files has never been easier or faster. Streamline your workflow, reduce clutter, and stay organized with just a few clicks.
This feature has been rolled out in the following regions as per:
Oct 7th (Mon): SE+JP+UK - 14:00 CET/08:00 ET
Oct 9th (Wed): DE+SG+AP - 14:00 CET/08:00 ET
Oct 14th (Mon): US - 15:00 CET/09:00 ET
Oct 16th (Wed): EU 14:00 CET/08:00 ET
In this blog post we will cover:
Where to access the folder structureCreate folder hierarchies and organize files into themPerform bulk operations on files and foldersReference space folder structure in Sense app and script developmentLOAD statements in the load scriptStore statements Inserting QVS code Documentation
Where to access the folder structure
The new features are accessible in your Data filesmenu for each space.
First, navigate to your Spaceand clickSpace Details
ChooseData files
You'll now have access to additional options, such as creating, copying, or deleting folders
Create folder hierarchies and organize files into them
Each space (Personal, Shared, Managed, and Data) in Qlik Cloud Analytics contains its own structure of folders organized in a hierarchical fashion. Data files can be organized in nested folder structures. For example, within your personal space, you might want to have separate folders for Order Data and Budget Data.
The location of a file or folder within a space is shown in its path. The path uses / symbols to represent when a folder is nested within other folders.
For example, suppose within your personal space, you have separate folders for Order Data and Budget Data. If you have a data file named Orders_2024_December.QVD in your Order Data folder, this file would be located in the following folder path within your personal space:
Personal/Order Data
Perform bulk operations on files and folders
Files and folders can be moved to different spaces or locations within the same space. You can also move multiple items at a time using the Cut and Paste actions, either from the menu or through keyboard shortcuts (CTRL-C, CTRL-V, CTRL-X).
Reference space folder structure in Sense app and script development
LOAD statements in the load script
When you use files in spaces to add data to apps and scripts, the folder location in the space is referenced and required.
Examples: Reference to file at the top-level path of a space
This example loads the file orders.csv from a personal space. The file is not located within any specific folder but sits at the top-level path in the space.
LOAD * FROM [lib://DataFiles/orders.csv];
This example loads the file orders.csv from a shared, managed, or data space. The name of the space is TeamSharedSpace. The file is not located within any specific folder but sits at the top-level path in the space.
LOAD * FROM [lib://TeamSharedSpace:DataFiles/orders.csv];
Examples: References to specific folder path within a space
This example loads the file orders_Europe.csv from the folder Orders By Region within a personal space.
LOAD * FROM [lib://DataFiles/Orders By Region/orders_Europe.csv];
This example loads the file orders_Europe.csv from the folder Orders By Region within a shared, managed, or data space. The name of the space is SalesSpace.
LOAD * FROM [lib://SalesSpace:DataFiles/Orders By Region/orders_Europe.csv];
Store statements
When you add a Store statement to store data from a load script into Qlik Cloud Analytics, the folder location in the space is referenced and required.
Example: Storing file at the top-level path of a space
In this example, the entire table mytable is exported into Qlik Cloud Analytics as a file named myfile.qvd. The file is added to the shared space TeamSharedSpace. The file is not located within any specific folder but sits at the top-level path in the space.
Store * from mytable into [lib://TeamSharedSpace:DataFiles/myfile.qvd];
Example: Storing file to a specific folder path within a space
In this example, the entire table mytable is exported into Qlik Cloud Analytics as a file named myfile.qvd. The file is added to the folder SalesData within the space TeamSharedSpace.
Store * from mytable into [lib://TeamSharedSpace:DataFiles/SalesData/myfile.qvd];
Inserting QVS code
When inserting QVS code into a load script, the folder location in the space is referenced and required.
Example: Referencing QVS file at the top-level path of a space
In this example, the file test.qvs is referenced in the load script. The file is located in the space TeamSharedSpace. The file is not located within any specific folder but sits at the top-level path in the space.
$(Must_Include=lib://TeamSharedSpace:DataFiles/test.qvs)
Example: Referencing QVS file in a specific folder path within a space
In this example, the file test.qvs is referenced in the load script. The file is located in the folder SalesData within the space TeamSharedSpace.
$(Must_Include=lib://TeamSharedSpace:DataFiles/SalesData/test.qvs)
Documentation
The Qlik Cloud Documentation has been updated with comprehensive information about the new feature.
Managing data files
Adding datasets from local files
Inserting QVS code from spaces in Qlik Cloud Analytics
Storing files to spaces in Qlik Cloud Analytics
Loading files from spaces in Qlik Cloud Analytics
Thank you for choosing Qlik,Qlik Support
...View More
Qlik Customer Support now available on Stitch!
For our Stitch customers, Qlik Support is now seamlessly integrated within your product connecting you with expert assistance. Select the green chat bubble at the bottom right of your Stitch environment to start chatting with support.
With the introduction of our generative support chat, you can now receive immediate and reliable responses validated through Qlik’s expert-led documentation. If you need more in-depth help, our team of Support Engineers are available 24/5 to chat live and troubleshoot any issues you may encounter. This comprehensive support ensures you receive timely solutions, keeping your Qlik experience smooth and productive.
In addition to quick AI-generated answers, you’ll gain access to Qlik’s Customer Portal, to manage your support needs and explore a wealth of resources, including our library of knowledge articles. Stitch has the power of Qlik Global Support behind it, and we’re here to help you through your data journey.
For our Stitch-only customers without other Talend products in their data suite, a Qlik ID will need to be created to login to Qlik Customer Portal.
For those with both Stitch & Talend products, Talend customer accounts have been migrated to Qlik ID, and users should be able to access through their business emails. If you need help with access, please chatwith our support engineers.
Note: Now that Stitch support is fully integrated within Qlik Global support, stitchsupport@talend.com is no longer in use. Please leverage your in-product Support chat or contact us through the Customer Portal For Assistance.
...View More
Hello all,
This has been resolved as of 13:00 Central European Time, 2nd of October. Should you still experience issues, please do not hesitate to use our Chat and we'll be right with you. Thank you for your patience.
Due to a degradation in Salesforce service performance, users are currently unable to log in to the Qlik Customer Portal.
While we work on resolving the issue for you, please continue using ourChatto remain in contact with us.
Thank you for choosing Qlik,Qilk Support
...View More
Hello Qlik Admins and Developers,
The next majorQlik Sense Enterprise on Windows release is scheduled for November 2024.The update will introduce changes that will have an impact on the following add-ons:
Qlik Alerting (link)
Qlik Sense Mobile client-managed (link)
qlik-cli (link) Upgrade to v.2.25.0 or higher
qlik/api (link) Upgrade to v1.12.0 or higher
Qlik Sense .NET SDK (link) Upgrade to v16.8.0 or higher
The changes affecting the add-ons are:
Extended CSRF protection to Websocket requests
Adding support for CSRF to add-on products
New versions of all affected add-ons were made available before or in November of 2024.
Please plan your upgrade accordingly to prevent interruptions:
If you upgrade to Qlik Sense Enterprise on Windows November 2024, all listed add-onsmustbe upgraded as well.
Thank you for choosing Qlik,Qlik Support
...View More
Don't miss our previous Q&A with Qlik! Pull up a chair and hear from our panel of experts to help you get the most out of your Qlik experience.
WATCH RECORDING HERE
...View More
Edit 17th September 2024: Added Oracle-to-Oracle bidirectional tasks issueEdit 9th November 2024: Replaced expired links
A set of problems were identified in theQlik Replicate 2024.5 release and actively addressed.
If you are planning to upgrade or have already done so and are seeing unexpected behavior, please review the highlighted knowledge articles for details:
Qlik Replicate 2024.5 and DB2i Source Endpoint leads to conversion errors with NUMERIC Datatype
After an upgrade toQlik Replicate 2024.5, capturing changes (CDC) for a Table definedon aDB2i Sourceleads to conversion errors with theNUMERIC Datatypes with precision and scale greater than zero.To mitigate, upgrade to 2024.5 SP03(GA). Download it here(expires: 1/31/2025).
Read more here.
Qlik Replicate 2024.5 Upgrade SAP HANA Trigger Version 1 migrates to Version 3 CTS Mode
As a part of a Qlik Replicate upgrade to 2024.5,SAP HANA Source EndpointsusingVersion 1configuration are converted toVersion 3 CTS Mode.To mitigate, upgrade to 2024.5 SP03(GA). Download it here(expires: 1/31/2025).Read more about the available workaround here.
Qlik Replicate 2024.5 GA Build 144: Store Changes using the new use_manipulation_pk_for_apply Option
WithStore Changes(seeChange Processing)turned on for CDC tasks, Qlik Replicate tasks may crash or stop unexpectedly with the new featureuse_manipulation_pk_for_applyenabled.To mitigate, upgrade to 2024.5 SP03(GA). Download it here(expires: 1/31/2025).Read more about the available workaroundhere.
Qlik Replicate tasks crash due to changes to the redo log format after installing Oracle July 2024 patch on Oracle 19
Qlik Replicate tasks using Oracle as a Source Endpoint fail after installing the Oracle July 2024 patch. To mitigate, upgrade to 2024.5 SP03(GA). Download it here(expires: 1/31/2025).Read more about the issuehere.
Qlik Replicate 2024.05 and Oracle-to-Oracle: Bidirectional Tasks fail after upgrade
Oracle-to-Oraclebidirectional tasksfail after an upgrade to Qlik Replicate 2024.05.The tasks crash without an error or start failing with a duplicate constraint error on theattrep_loopback_preventiontable.
No workaround or solution is yet available. Qlik will provide a timeline for a patch at the end of September 2024.
Read more about the issuehere.
Don't hesitate to contact us if you have any questions or concerns about the upgrade. We will monitor this blog post for your queries.
Thank you for choosing Qlik,Qlik Support
...View More
Hi everyone, Want to stay a step ahead of important Qlik support issues? Then sign up for our monthly webinar series where you can get first-hand insights from Qlik experts.The Techspert Talks session from September looked at Qlik Cloud Administration 101.
But wait, what is it exactly?Techspert Talks is a free webinar held on a monthly basis, where you can hear directly from Qlik Techsperts on topics that are relevant to Customers and Partners today.
In this session we cover:
Important settings
Space and App management
Report and Alert configuration
Click on this link to see the presentation
...View More
Hello all,
The following patches for Qlik Sense Enterprise on Windows have been released today:
May 2024 Patch 4 (Release Notes)
February 2024 Patch 8(Release Notes)
and November 2023 Patch 11(Release Notes)
All installation files are available on our Downloadsite. Log in with your Qlik ID, apply your version's relevant filter, and download the new patch release.
Looking for product lifecycle information? See Qlik Sense Enterprise on Windows Product Lifecycle.Wondering why we have not seen an August 2024 major release? See Release Cadence Update: Qlik Sense Enterprise Client-Managed.
Thank you for choosing Qlik,Qlik Support
...View More
Hello all,
The Qlik Application Automation Google Sheets connector was modified to request a different set of scopes than it used to. This has an impact on new connections made in Qlik Application Automation to Google Sheets.
What does this mean?
Qlik Application Automation used to rely on the following scope in order to obtain a list of spreadsheet files: https://www.googleapis.com/auth/drive.
This scope has been replaced with a more limited scope:https://www.googleapis.com/auth/drive.file.
Why was the change done?
The change was motivated by Google’s modifications to which scopes are restricted. The new scope is limited to searching for files that have been created by the app itself, whereas the old scope was able to list all files available on a drive.
How does this affect me?
If you have an existing Google Sheets connector connected which was created beforeAugust 8th 2024: There is no change to your connector and all existing automations will remain working. Tokens obtained through our refresh token call will contain the same scopes as before.
Connections createdafterthe 8th of August 2024: The connector will have the updated scope. This means not all spreadsheets on your drive will be shown in any of the spreadsheet ID block or on the list spreadsheets block. The spreadsheet ID for spreadsheets not shown in the lookup will have to be manually provided and can be obtained from the browser bar in Google Sheets.
We are looking to mitigate Google's change and are working on bringing the connector's user experience back to it’s previous levels.
Thank you for choosing Qlik,Qlik Support
...View More
