What's new in Qlik Cloud
Learn about new features and improvements. Filter the news items to see what's new in specific product areas and time periods.
Learn about new features and improvements. Filter the news items to see what's new in specific product areas and time periods.
The relative importance analysis is now available in Analyses. Relative importance shows the size of dimension values that contribute to the whole. It can also be used to perform Pareto or 80-20 contribution analysis.
Today we introduce the new Qlik Answers connector as the latest addition to Qlik Application Automation. This connector unlocks new powerful use cases like indexing new data "on the fly" and taking your action-oriented automations to the next level by including unstructured insights.
For more information, see How to get started with the Qlik Answers connector in Qlik Application Automation
Qlik Talend Cloud pipelines introduces two new features to build open lakehouses with Snowflake. These features can be used independently or in combination.
Lake-landing ingestion for Snowflake pipelines
The lake-landing task allows to replicate data to your cloud storage of choice in low latency. The downstream Snowflake storage layer can be scheduled to consume the ingested data at a slower pace. This capability reduces warehouse compute uptime requirements.
Support for Snowflake-managed Iceberg tables
Storage, Transform and Data mart tasks can be configured to store data on an external cloud storage (Amazon S3, Azure Data Lake Storage, or Google Cloud Storage) as Snowflake-managed Iceberg tables. Iceberg tables are managed by Snowflake and can be synchronized with Snowflake Open Catalog (previously called Snowflake Polaris) for full interoperability with any Iceberg-compatible engine.
Direct Access gateway 1.7.1 introduces new capabilities and resolves several issues. To benefit from the enhancements and resolved issues, customers are encouraged to upgrade at the earliest opportunity. For upgrade instructions and a list of resolved issues, see Upgrading the Direct Access gateway installation
REST Connector
The new REST (via Direct Access gateway) connector provides secure access to private REST API endpoints via Direct Access gateway, allowing you to stream data directly into your Qlik Sense app.
For more information, see REST data sources.
The REST (via Direct Access gateway) connector will be rolled out to Qlik Cloud regions in four phases, with phase 4 scheduled to be completed by February 17th.
Phase 3: US (United States) and Qlik Cloud Government
Overriding the default chunks cache directory
For each reload operation, Direct Access gateway can cache data chunks in memory and offload them to disk (when the size allocated for caching is exceeded). You can override the default chunks cache directory (C:\ProgramData\Qlik\Gateway\tmp) directory if you do not have enough disk space on the system drive.
For more information, see Overriding the default chunks cache directory.
Overriding the default number of tables retrieved when working with the ODBC (via Direct Access gateway) Connector
By default, 10,000 tables are retrieved for selection, which might not be enough when working with very large databases. This version introduce the ability to override the default by increasing the ODBC_TABLES_LIMIT_FOR_GENERICODBC property in the Direct Access gateway configuration.properties file.
For more information, see Select and load data from an ODBC data source.
Multiple catalog support with the Google BigQuery (via Direct Access gateway) Connector
The Google BigQuery (via Direct Access gateway) Connector now supports accessing multiple catalogs (the equivalent of Google BigQuery projects) in a single connection.
For more information, see Create a Google BigQuery Connection.
Support for Unity Catalog with the Databricks (via Direct Access gateway) Connector
The Databricks (via Direct Access gateway) Connector now supports accessing data in Unity Catalog on Databricks.
For more information, see Create a Databricks connection.
Mitigating data errors caused by the ODBC driver when using the ODBC (via Direct Access gateway) connector
Sometimes, due to an issue with the vendor ODBC driver's handling of source data types, either an error will occur during the reload or incorrect data will be loaded to Qlik Cloud. In such cases, you can override the Qlik Cloud data type or its specification (scale or precision, for example).
For more information, see Overriding default the Qlik Cloud data type when working with the ODBC (via Direct Access gateway) connector.
The very popular custom menu is getting updates based on customer feedback:
Hover menu is off by default
Sheet title expression now used if present
Drawer panel option to place to the right
Separate items mode, now with more space, border, shadow and divider options
Padding and margin adjustments
Icon and group symbols use label color
Scripting topics covering color and null functions have been improved with new examples.
With the latest update to Qlik Talend Cloud, users can now track data freshness in real time based on the data sources with the new Freshness Indicator.
High-quality data begins with trust. Expanding on the proven foundation of Talend Trust Score™, Qlik Cloud introduces the Qlik Trust Score™ to streamline data quality assessments and provide immediate visibility into the trustworthiness of data assets across the organization. With an intuitive numeric score ranging from 0 to 5, the Qlik Trust Score™ offers a clear and actionable way to evaluate the quality of data products. The score is calculated by aggregating multiple dimensions and allows for flexible tuning of dimension weights to align with specific use cases.
Key benefits of Qlik Trust Score™
Customizable: Configure the Qlik Trust Score™ to align with your specific data quality objectives by enabling or disabling specific dimensions and adjusting their weight.
Actionable insights: Get in-depth metrics across different data quality dimensions such as validity, completeness, discoverability, and usage to identify quality gaps effectively.
Enhanced transparency: Track dataset freshness and usage metrics, fostering trust and collaboration across teams.
This feature is available for Qlik Talend Cloud Enterprise.
Scripting topics covering inter-record and aggregation chart functions have been improved with new examples.
To simplify pipeline management and cross-team collaboration, pipelines in Qlik Talend Cloud can now be composed of multiple projects.
This gives data teams flexibility as they design their pipelines, and allow them to break up a complex pipeline of ingestion and transformation tasks into multiple projects. In particular, cross-project references can be used to segregate a pipeline by data domain, enabling Data Mesh design principles.
To get started, when creating a new project, select the Use data from existing project option.
You can now download review feedback in from Review in Qlik Answers assistants as a CSV file.
Downloading conversation data for review
Qlik Answers knowledge bases now support Google Drive and OneDrive connections as data sources.
Sheets and Bookmarks have been re-added as items in the default configuration of the app toolbar. This setting can be configured by opening the app settings, and selecting UI settings.
Today we introduce the concept of third-party runs in Qlik Application Automation. This is the first step towards a shift in our packaging that focuses on third-party runs only, while standard runs will become free of charge.
For more information, see Packaging shift to third-party runs for Qlik Application Automation
We’re thrilled to introduce Custom Groups, a powerful new capability designed to give enterprise customers greater flexibility and control over user and group management.
With Custom Groups, organizations that do not rely on Identity Provider (IdP) groups for access control can now create and maintain user-to-group relationships directly in Qlik Cloud. This enables seamless group-based provisioning for both administrative access and product feature controls.
Use cases solved:
Public Sector Flexibility: Manage group memberships within Qlik Cloud to streamline resource access without relying on IdP-provided groups, simplifying integration with third-party applications.
Enterprise Autonomy: Gain full control over user and group assignments without being tied to IT-managed Active Directory groups, empowering teams to adapt quickly to evolving needs.
Embedded Analytics: With qlik-embed and OAuth2 Machine-to-Machine impersonation, use Custom Groups to handle user group membership using only REST APIs and the qlik-api framework, reducing complexity.
Custom Groups offer enhanced usability and autonomy, making access management easier and more aligned with your unique organizational structure.
A new details panel is now available in applications, helping users find the relevant app metadata, such as owner, updated, and created. It also provides valuable actions within the app, such as editing the reload schedule, and moving the app.
Qlik Cloud Analytics is introducing Data Flow, a native no-code capability to simplify the last mile of data preparation for analytics, machine learning, and AI. Data Flow offers intuitive drag-and-drop interfaces for visually combining and shaping datasets, balancing self-service functionality with proper governance. This approach aims to democratize data preparation while maintaining data integrity and security.
Key features:
Visual editor: An intuitive drag-and-drop experience for creating data preparation flows. Load data from your catalog or connection sources and output files in formats such as QVD and PARQUET, ready for analytics and AutoML applications.
No-code processors: A rich palette of processors allows you to cleanse and shape your data, including data manipulation operations such as string, number, date and cleansing functions, and re-structuring capabilities such as joining, aggregating, and filtering data.
Data preview: Preview a sample of the actual data output at each step of your flow, ensuring accuracy and full visibility throughout the process.
Script generation: Automatically generates Qlik script that you can preview for transparency and to familiarize yourself with the syntax. For more advanced use cases, include custom scripts with the “Qlik script” processor or script expressions using the “Calculate fields” processor. You can also convert a data flow into an editable script for further customization.
Platform integration: Data flow is a fully integrated asset available in Analytics activity centers, leveraging spaces, lineage, and impact analysis to support collaboration and governance. Like scripts or analytics apps, data flows can be run and scheduled to streamline your end-to-end analytics workflows.
You can now change the owner of a project to transfer control of all tasks and related datasets in the data project to another user. This is for example useful if there are projects that are owned by a user that was deleted.
The AI processor in transformation flows now supports Snowflake Cortex AI functions. The Snowflake implementation of the AI processor includes four state-of-the-art generative AI functions:
Sentiment analysis
Data classification
Text summary
Translation
The assets panel in the advanced edit mode has been updated with a new look and feel.
Qlik Cloud Analytics now includes native support for regular expressions (regex) in both load scripts and chart expressions, enabling users to enhance data preparation and analytics workflows with advanced text pattern matching, extraction, and transformation. Regular expressions offer advanced and flexible options for processing text-based data, supporting use cases such as identifying email addresses, validating formats, and standardizing data based on defined patterns.
Working with regular expressions in load scripts and chart expressions
The Snowflake target connector for data replication and data pipelines now supports configuration of advanced (additional) connection properties. This allows users to have fine-grained control over connection definitions beyond standard parameters, including adding properties such as Role, Secondary Role, and more. While this release introduces support for the Snowflake target connector, more connectors are planned to follow.
Additional connection properties
In AutoML, improvements have been made to the user experience for generating batch predictions from ML deployments.
Creating predictions on datasets
Direct Access gateway 1.7.0 introduces new capabilities and resolves several issues. To benefit from the enhancements and resolved issues, customers are encouraged to upgrade at the earliest opportunity. For upgrade instructions and a list of resolved issues, see Upgrading the Direct Access gateway installation
File connector
The new File (via Direct Access gateway) connector provides secure file system access via Direct Access gateway, allowing you to stream data directly into your Qlik Sense app.
For more information, see File (via Direct Access gateway).
Improved performance with async command support
Async command support increases efficiency by enabling Direct Access gateway to handle multiple commands simultaneously, as opposed to one at a time.
The File connector and Improved performance with async command support will be generally available in Qlik Cloud tenants during the second half of January, as part of a phased rollout by region, per the following schedule:
Qlik Cloud Region |
Region Code |
Enabled |
---|---|---|
Europe (London) |
eu-west-2 |
January 14 |
Europe (Sweden) |
eu-north-1 |
|
Japan (Tokyo) |
ap-northeast-1 |
|
Europe (Frankfurt) |
eu-central-1 |
January 15 |
Asia-Pacific (Singapore) |
ap-southeast-1 |
|
Asia-Pacific (Sidney) |
ap-southeast-2 |
|
India (Mumbai) |
ap-south-1 |
January 21
|
US East (North Virginia) |
us-east-1 |
|
Europe (Ireland) |
eu-west-1 |
January 28 |
Qlik Talend Cloud lets users accelerate their documentation tasks by leveraging generative AI to describe a dataset. Based on the dataset and columns names, the description will be populated leveraging generative AI with a description that can be accepted, rejected, or modified.
Data movement in Qlik Talend Cloud has supported loading multiple tables in parallel for Replication, Landing and Lake Landing tasks. From this release, parallel load definitions are now also supported for individual tables during the full load of data into a target data platform. This helps to significantly improve task performance with the ability to split a source table into ‘segments’ which are then loaded in parallel.
These 'segments' are configurable by data ranges for one or more columns* (for example date ranges, PK segmentation etc.). If the source table is partitioned, in a source which supports the parallel load feature, then the segments can be automatically interpreted by source table partitions, or by sub-partitions. Parallel Load is supported for Replication, Landing and Lake Landing tasks.
To learn more including the supported sources and targets for parallel load and any limitations see Loading dataset segments in parallel.
The Machine Learning API is a new public API that has been introduced to allow users to train, deploy, and predict with machine learning models with Qlik AutoML. You can use this API to integrate the power of Qlik AutoML and predictive analytics into your own software applications.
The existing real-time predictions API is being deprecated and replaced by the real-time prediction endpoint in the Machine Learning API. The functionality itself is not deprecated. For future real-time predictions, use the real-time prediction endpoint in the Machine Learning API.
Automated machine learning tutorial
Users can now add custom logos to the app navigation bar in their analytic apps. Additionally, the media library in apps has been updated with a new look and feel.
App settings now include options to toggle individual items and buttons in the app navigation bar, toolbar and sheet header, allowing greater customization of the end user experience.
Hiding toolbar, sheet header, and app navigation bar options
The updated view of an assistant's Review page provides a better experience to view questions and assistant responses. You can now sort or filter on the columns to review the highest priority conversations.
Use this to fix existing content or add more content to your knowledge bases so that future responses are accurate.
The button action Execute automation can now be used to send custom parameters directly to your automations without requiring a temporary bookmark. This is useful for creating writeback solutions in a large app as creating and applying bookmarks can take longer in large apps.
Qlik Answers is now supported in the following regions:
Europe (London)
Asia-Pacific (Singapore)
Japan (Tokyo)
India (Mumbai)
A new Dates processor is now available as part of transformation flows in Qlik Talend Cloud.
The Dates processor makes it easy to manipulate date and time data. It offers various functions to convert from and to date data types, as well as calculation functions such as adding time or getting the time difference between dates.
As requested by customers, you can now add shortcut buttons to Sheets and Bookmarks in the toolbars of your analytic apps. These buttons open the assets panel to either Sheets or Bookmarks. You can add these buttons from UI settings in your app settings.
The Qlik Cloud Analytics activity center now includes mini-homes. Mini-homes provide a selection of alternate home pages aimed at specific analytic purposes. Each mini-home provides creation options related to that activity. The following mini-homes have been added:
Visualize and analyze
Prepare data
Predict
Answer
You can now control at the variable level whether or not a variable's current state is included in bookmarks and reports.
Report developers can now configure their tabular or PixelPerfect report tasks to cycle over dimensions to produce a report per dimension value for each recipient.
Report developers now have greater visibility into their report task executions. With report task history, report developers can now see 90 days of task execution history. The history shows task metadata and where there are errors, error descriptions are available to allow the report developer to begin troubleshooting. If you cannot resolve the error, a trace ID is available to expedite any required call to Qlik Support.
Viewing execution history for report tasks
Subscriptions to sheets just got easier with a Preview button so that a user can check what the output of their subscription will be before scheduling it (e.g. validate sheet order, or selections applied). A secondary benefit is that it could be used as an ad-hoc multi-sheet download, which the user can subsequently decide to schedule if they like the output.
Scripting topics for string functions have been improved. New examples have been added to the documentation.
The new straight table gets support for mini charts. Add a second dimension and display the measure with sparklines, bars, or dots. Perfect for showing the trends and providing more context to make the measure more comprehensible.
The values in the variable dialog now change as changes are made in the app, such as by the variable input control.
Version control empowers developers to work concurrently on different aspects of a project in Qlik Talend Cloud pipelines.
Thanks to a branching strategy, developers can isolate a feature and edit a project without affecting the main branch. Using GitHub, projects can be shared across branches, spaces and tenants.
For each branch, users have the option to customize the schema prefix to be added to all datasets in the branch to avoid conflicts. Once changes are made on their branches, users can synchronize changes with a remote repository, and commit and push their changes. They can also create pull requests from GitHub, where team members can review and approve the code before it is merged back into the main project.
Version control allows team members to sync their changes and collaborate efficiently while avoiding conflicts and ensuring pipeline integrity.
Version control is available from Qlik Talend Cloud Standard edition and upwards.
Set up GitHub configuration.
Connect a project to version control.
For more information, see Manage your projects with version control.
More support for cyclic dimensions in the new straight and the pivot table. Column now includes a dropdown for quick access of cyclic group fields.
Selecting active fields from cyclic dimensions in straight tables
Selecting active fields from cyclic dimensions in pivot tables
Qlik Sense adds a GetUserAttr function that is similar to the GetSysAttr function and allows developers and self-service users to leverage metadata from outside the app to drive in-app experiences. GetUserAttr provides information about the user accessing the app, which can then be used to create more advanced customization by applying per-user or per-group controls in the app.
Developers can leverage the users’ groups, email, or subject information to do actions such as:
Apply specific locale or language settings based on email domain or groups. For example, apply French language translations for dimensions, measures, and titles to those users whose email domain is x@mydomain.fr or who are members of the group Qlik-French.
Customize layouts to fit different user personas by applying show/hide settings on objects, dimensions or measures in objects, or sheets (note that this function does not restrict access to data, therefore, it is recommended that you still leverage section access for data reduction).
With PixelPerfect report authoring in Qlik Cloud Analytics, it is now possible to create visually stunning, highly customized reports with pixel-level precision. With its intuitive interface, PixelPerfect gives you precise control over every element of your design, so you can create branded reports that perfectly align with your company’s presentation standards — and deliver them via burst report delivery or on-demand end user customized download.
Designing PixelPerfect report templates
Videos: Designing PixelPerfect report templates
You can now add monitored charts to shared and managed spaces, streamlining analytics consumption by displaying key visualizations directly on the Insights activity center homepage. This ensures all users within your tenant can easily access and benefit from important insights.
ML deployments will now offer monitoring capabilities to review the number of predictions made and the feature drift. This will be available on new deployments if you use an add-on Qlik AutoML tier.
Monitoring performance and usage of deployed models
The new Straight table in the bundle is getting indicators. Add icons and colors based on thresholds, quick and easy on any measure.
The new Pivot table in the bundle gets another presentation mode: choose indent row dimensions for a more compact view. Indent rows are intended for text hence images and links are not supported.
The selections tool gets an upgrade and is improved to also handle calculated dimensions.
Qlik now provides a new cloud region in India to support the growing demand for customers to rapidly innovate with data and technology for analytics in the Asia Pacific (APAC) region. This new region based in Mumbai, is the fourth Qlik Cloud region in APAC and the ninth globally. Organizations based in India and the APAC region can now store and deploy data for analytics locally at scale, ensuring optimal operational performance, regulatory compliance across finance, banking, public sector and healthcare, while providing Advanced AI capabilities with the inherent cost savings of the cloud. Storing data in a local cloud allows customers to effectively meet the analytics needs of their users across the region, with faster access and lower latency.
Select your region from the list during tenant setup.
Allowlisting domain names and IP addresses
Creating and configuring the tenant
With the latest update to Qlik Talend Data Integration, users can now compute data quality in pull-up mode for QVDs, in addition to the previously supported dataset types. This extended support enables data product teams to maintain trusted, consistent data across diverse sources and formats, enhancing reliability for various business needs across Qlik Talend Cloud platform.
Key Features with this update, Qlik Talend Data Integration strengthens its integrated data management offering with extended data quality profiling for:
SQL databases, allowing pull-up computation for any registered datasets.
File-based sources, including QVDs, CSV, XLS, and XLSX files, enabling teams to profile and ensure data quality across structured data formats.
Continued support for Snowflake datasets with push-down computations.
Schema evolution has been supported in Qlik Talend Cloud replication tasks, and with this update we have extended the capability to also support data lake landing tasks and pipeline projects for landing and storage tasks.
Qlik Talend Cloud supports schema evolution to easily detect structural changes, aka schema drift, to multiple relational data sources and automatically apply the changes to your pipeline. You can configure how each type of DDL operation captured is applied to the target.
Notifications of schema changes are also supported to assist ETL engineers adjusting downstream pipelines, as required. Notifications can be enabled when automatic schema evolution is enabled or disabled for any data movement task, including Replication,data lake landing, and landing tasks.
For more details, see:
Today we are launching a preview mode for new functionality, the switch is visible in the asset panel in edit mode. The first feature for preview is the new design of the tabs for Fields, Master items, Charts, Custom objects, Application navigation and Dynamic views. The Fields tab also allows for selections in edit mode and has got the histogram from simplified authoring. The new asset panel will be turned on for all users in January.
A new release of Qlik DataTransfer is now available, November 2024 (version 10.4.0).
This version is required since the current release of Qlik DataTransfer, from November 2022 (version 10.1.0), will stop working after November 28, 2024, due to an unforeseen expiration of the embedded version of the Qlik Engine.
To continue uploading data from on-premises data sources to your Qlik Cloud tenant, you must update Qlik DataTransfer to the latest release, November 2024 (version 10.4.0), now available on the Qlik Download site.
For upgrade instructions, see Upgrading Qlik DataTransfer.
As an alternative to creating visualizations by selecting a chart and then adding your data, analyses allow you to build visualizations by picking the analysis type you want to create and then adding your data to it. The analyses then build visualizations based on your fields and selected analysis type. You can customize your analyses as well as convert them into charts for more customization options.
Give your users a more personalized experience by customizing your Qlik Answers assistants. You can now customize the avatar and in-chat error messages through the assistant settings page.
Intelligent model optimization will assess each feature to identify anomalies that may cause impact on training. These values will be weighted to reduce the impact of outliers on trained model performance.
A big part of the app experience is the navigation between sheets. With our new navigation menu, you can style it as you prefer. Set to a top menu, a side panel, or as a pop up drawer. Pick any colors and choose the font that you desire.
The new tab container is an improvement the old container object with a new name and styling settings for labels, tabs and icons. Key features include:
Label font styling: Family, size, color, alignment.
Label icon size, color and alignment.
Tab background, selected, and hover color settings. Color by fixed colors or by expression.
Styling for labels, tabs and icons, both for the whole container and per tab.
Support for label width by pixel or percent.
Support for longer labels.
Settings for vertical or horizontal tabs.
Improved menu experience.
This week includes the following enhancements:
Chart exploration in the new straight table is now supported in layout container and the new tab container. The new straight table also gets word wrap of headers and content.
The new pivot table gets range selection.
The layout container is now supported in custom tooltips.
Holding shift while resizing the layout container will keep charts in same place and size.
Scatter plot gets options for bubble outline color and support for reference lines with slope.
The processing and training workflow for intelligent model optimization has been enhanced with new capabilities. Intelligent model optimization is activated by default in new ML experiments, and offers automated refinement of machine learning models created with AutoML.
Continuous numeric features will be binned into buckets to re-balance the distribution of data. This new feature will be tested to see if the quality of the model is impacted with and without the transformation.
For numeric features that are identified as skewed, the values will have a power transform applied to generate new features for model training.
Intelligent model optimization
We have lifted restrictions when it comes to deleting projects. You can now delete projects and their included tasks in one click, provided the tasks are not currently running.
Qlik Sense now supports direct native loading and parsing of JSON data files without the REST connector, enabling easier, more flexible, and complex JSON data handling for use cases including IoT data ingestion, modern web applications, and more.
Key capabilities include:
Direct JSON file loading: Supports loading .json files directly into Qlik Sense without additional connectors, and interrogation of JSON within a single field, for example out of a database.
Wildcard and multi-file loading: Use wildcard loading to combine multiple JSON files, even if file structures differ.
Dynamic model creation: Qlik Sense will dynamically model and accommodate all data found across source files.
Field selection options: Load specific fields or all fields from JSON arrays with field selection parameters.
Large file support: Enables loading of large, complex JSON files.
Enhanced data load wizard: Improved user interface for JSON loading with wizard-driven steps to simplify setup.
Catalog profiling support: JSON files are now supported in Qlik Cloud datafiles, and in the Qlik Cloud catalog for data profiling and management.
Transformation flows are now supported in data pipeline projects using Amazon Redshift as target. Users can now develop graphical transformations alongside the custom SQL based transformations to support complex requirements for reshaping data.
Direct Access gateway 1.6.9 introduces new capabilities and resolves several issues. To benefit from the enhancements and resolved issues, customers are encouraged to upgrade at the earliest opportunity. For upgrade instructions and a list of resolved issues, see Upgrading the Direct Access gateway installation
Process isolation is now turned on by default
In previous versions, process isolation mode was turned off by default. From Direct Access gateway 1.6.9, it will be turned on by default, but only with a clean installation. If you are upgrading, your existing process isolation configuration will be preserved (off or on, depending on what it was before the upgrade).
To learn more about process isolation, see Mitigating connector crashes during reload
Removed configuration.properties file
To prevent customers mistakenly modifying the wrong configuration.properties file, the configuration.properties template file has been removed from the Direct Access gateway installation folder. Now, there will be only one configuration.properties file, located in C:\ProgramData\Qlik\Gateway.
The selection bar can now be styled using custom themes.
The button got an another action for controlling cyclic dimensions. Use Set active field to go to a specific field in the group.
With the latest update to Qlik Talend Cloud Enterprise edition, users can now track data freshness in real time with the new Freshness Indicator. Sent by Qlik Talend Data Integration whenever there's an update to the data pipeline, this feature helps users quickly assess the timeliness and reliability of their datasets. The freshness is determined either by the date of the pipeline run or by the date of changes in the data source (for Change Data Capture scenarios). The indicator is available from the dataset overview, accessible through Qlik Cloud Data Catalog or Data Products Marketplace.
The new style settings include:
Background color and image
Font styling for header, dimension, measure and totals with font family, weight, size, foreground and background color
Grid styling with height, border and divider color and hover color options.
Null value font styling with font weight, foreground and background color
We have introduced the Get Chart Image block in the Qlik Reporting connector. This new feature allows users to generate chart images directly within their automation workflows, streamlining the process of sharing visual insights.
Qlik Community - The latest addition to Application Automation
Sending a chart image through email using Qlik Application Automation
The latest Qlik Cloud Catalog update brings customizable data quality capabilities, allowing users to tailor data quality compute, and offering enhanced flexibility to better align data quality processes with business needs while optimizing resource usage.
Key features:
Configurable sample size: Choose the number of rows or a percentage of your dataset to calculate data quality, enabling precise control over the scope of data to be checked.
Processing mode options: With the ability to select between two processing modes - Pushdown mode (leveraging Snowflake’s power) or Pullup mode (utilizing Qlik Cloud’s engine) - businesses can optimize processing based on their infrastructure and goals.
Qlik Application Automation now supports the renewal of the execution token of a triggered automation. This can be done from the Start block in the automation editor.
Users with training data that is sensitive to changes over time can optionally choose to use a date as their test-train split parameter when configuring an ML experiment version.
Chart background by URL may seem small but offers huge potential to style and build up a highly dynamic and stylish app.
Useful for:
Linking images from external sources.
Building up dynamic images using an expression with inline SVG as a Data URI.
Fetching images from the media library with an expression and the API.
Image by URL can be used in:
Chart backgrounds
Straight table cells
Pivot table cells
Map point layer icons
Map chart background layers
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.
Managing data files for tenant and analytics administrators
Organizing data files in a hierarchical folder structure in Qlik Cloud
“Qlik Anonymous Access” simplifies engagement with analytics content by eliminating the need for user accounts and complex authentication. This can be used with embedded content (qlik-embed) as well as with a full link to a Qlik Sense application. It allows you to broaden access to external partners, clients, and stakeholders, promoting collaboration and knowledge sharing. And it helps you to easily scale to meet changing user demands without the need to manage user accounts.
Qlik Anonymous Access subscriptions
Sharing app content with anonymous access
Qlik Anonymous Access subscriptions are not available in Qlik Cloud Government.
You can now generate a public-private key pair when provisioning an OIDC-based Identity Provider. This enables your Identity Provider to send user ID tokens to Qlik Cloud in a cryptographically secure manner during user authentication.
Several issues have been resolved. If you are using Data Movement gateway, upgrade to the latest version to benefit from the resolved issues. For a list of resolved issues as well upgrade instructions (for Data Movement gateway), see Upgrading the Data Movement gateway installation.
We are continuing to expand the connectivity of Qlik Talend Cloud with the addition of more insurance- and security-related applications that can now be used as a data source. By eliminating the need to develop custom connectors to access these sources, these connectors will help companies streamline their insurance workflows and accelerate their ability to fully assess security risks and compliance. The new connectors are:
With the latest update to Qlik Talend Data Integration, users can now compute data quality in pull-up for datasets registered from SQL sources, as well as from files like CSV, XLS, and XLSX, in addition to the previously supported datasets stored in Snowflake. This expanded support empowers data product teams to ensure high-quality data across an even wider range of sources, delivering trusted, consistent data for various business use cases.
Key Features with this update, Qlik Talend Data Integration strengthens its integrated data management offering with expanded data quality profiling for:
SQL databases, allowing pull-up computation for any registered datasets.
File-based sources, including CSV, XLS, and XLSX files, enabling teams to profile and ensure data quality across structured data formats.
Continued support for Snowflake datasets with push-down computations.
This enhancement ensures broader, more flexible data quality management, helping organizations gain more value from their data products, regardless of the source.
Datasets used for testing while training models can now be exported to a space for further analysis.
Embedded analytics is now localized to the user's chosen UI language.
We have made improvements to the way labels work in the selection. If the user has provided a label to a master dimension, then that label will be used rather than the field name in the underlying data model. This will improve usability and make it easier to create multilingual applications.
You now have the option to display labels on stacked measure segments.
Key/pair provides a more robust authentication method than user/password for connecting to Snowflake with your service accounts. This approach is recommended for workloads such as data loading (replication or landing tasks) and transformations.
The new pivot table is now getting support for download as image and PDF, storytelling, subscriptions, and monitoring. We know many have been waiting for this and we're glad to announce general availability. The new tables are rolled out with new features incrementally and will soon be moved from the visualization bundle to the native chart section
A new processor has been introduced in transformation flows to make it easy to leverage your Databricks platform's AI capabilities. The AI processor includes seven state-of-the-art generative AI functions:
sentiment analysis
grammar issues fix
translation
text summary
string similarity
data masking
classification.
Direct Access gateway 1.6.8 introduces new capabilities and resolves several issues. To benefit from the enhancements and resolved issues, customers are encouraged to upgrade at the earliest opportunity. For upgrade instructions and a list of resolved issues, see Upgrading the Direct Access gateway installation
Data chunks recovery mechanism
This version introduces support for sending missing or corrupted data chunks. To control the size in memory of the reloaded data chunks, a new property has been added to the configuration.properties file: RELOAD_CACHE_MEMORY_MB
To learn how to set this property, see Caching data for reload in the event of a problem
.NET 6.0.x no longer required
From this version, running Direct Access gateway no longer requires .NET 6.0.x. Prior to installing Direct Access gateway, new customers should install .NET 4.8 (needed for the installation) as well as .NET 8.0 and ASP.NET Core Runtime (for working with Direct Access gateway) only.
For more information about Direct Access gateway prerequisites, see System prerequisites
Improved batch operations for dependent processes
From this version, dependent processes will be checked in parallel instead of sequentially, thereby avoiding exceptions due to modification of the process list during runtime.
For more information on process isolation, see Mitigating connector crashes during reload
Improved troubleshooting
More context (for example such as "process ID" and "commit size") was added to the resource usage warnings in the logs.
As announced on July 9th, the new platform navigation was released as an opt-in for a limited time. Today, it has become a default for all tenants without an opt-out.
This change brings significant user-experience improvements, such as more ease of navigation and finding your way around the platform, with a common anchor point in the waffle menu in the top-left corner throughout the whole platform.
This also includes the introduction of Activity Centers, with areas focused on consuming analytic insights and creating analytics with a new Insight Advisor Chat experience.
Qlik Cloud Analytics activity centers
Qlik Talend Data Integration activity center
With Qlik Talend Cloud, users can unlock data value through data products, a unique product-centric approach to streamlining end-to-end data management.
Data products are valuable because data product teams can quickly produce high-quality, curated, domain-centric data assets, that can be easily accessed by data consumers and leveraged in several business use cases across the organization. This closes the gap between what data producers are putting together and what data consumers need. Just like real products, data products are built iteratively and have a lifecycle - from creating a data product to managing the quality of the data product, activating it into the data marketplace, and deactivating it when they are no longer needed.
Qlik Talend Cloud brings together an integrated data management experience – from data integration to transformation, data quality, and governance. The data product catalog in Qlik Talend Cloud offers several key capabilities to manage the data product lifecycle end-to-end.
Model Approval Workflow enables customers to "opt-in" for greater control over the activation of machine learning models when they are deployed on Qlik Cloud. This is enabled through the control of custom security roles.
In previous versions, refreshing the metadata on an existing dataset or a newly added dataset would sometimes fail with an error. This enhancement ensures that metadata can be retrieved from multiple tables in parallel without any issue.
Based on feedback from our customers we're improving the combo chart and adding labels to markers and a setting to toggle the grid.
Now when the transition to the new sheet navigation is complete, the Sheets button is going away. Use the Assets button on the left side instead.
In some cases, a change in the source data might require the target tables to be recreated (for example, if you need to change the target schema). Qlik Talend Cloud pipelines provide the ability to recreate the target datasets through the Recreate tables option. Previously, executing a recreate would also require tables in downstream data tasks to be recreated. This behavior has changed to allow recreation of tables in a data pipeline without needing to recreate tables in the downstream task. When recreating a table, the downstream task will react as if a truncate and reload action occurred on the source datasets.
To make pipeline design more flexible, we are introducing a new dataset model for transform and data mart tasks: the target-based model.
With this new model, dataset metadata is now decoupled from source metadata changes. Transform and data mart tasks are more self-contained, letting you control the effect of source metadata changes.
Target datasets are now explicitly mapped from the source datasets. If a column is added from the source, or removed, it is not automatically propagated to the next downstream task anymore. Instead, you will be able to adjust the mappings according to your needs. You can also change the column order and replace the data source as needed.
Ingestion-type tasks, such as landing and storage, remain on the source-based dataset model.
A new view is now available for transform tasks, providing visible lineage.
This view lets you see the full dataset lineage, including transformation flows with multiple output datasets. Filters and display options are also available to adjust the view to your needs.
Charts are now highlighted in the container when they are selected in the list in the property panel.
You can now have expressions in field labels for drill-down and cyclic dimensions. This lets you for example enable translation of labels in multi-language apps.
Users can now search and replace text within the expression editor in Qlik Sense apps, just as they can already do in the script editor and data load editor. This includes a "replace all" option, allowing for quick bulk edits within a single complex expression.
The usability of the expression editor has also been improved by adding a confirmation dialog when closing with unsaved changes.
An optimization has been introduced to allow a template to be connected to the source app at time of upload. Previously, it had to be done by creating the connection in the Qlik add-in for Microsoft Excel. For example, if a report developer knows that a template is compatible with an app, and a copy of that app is available in another space or tenant, the report developer can upload the template used in the source app directly to the alternate version of the app and the connection will be created during the upload.
Working with report templates in the Qlik Sense app
Previously, when a metadata change occurred, all tables would be dropped and recreated even if the metadata change did not affect all tables. Now, only the changed tables will be dropped and recreated, thereby improving performance.
Qlik Cloud Government now supports the following Qlik Application Automation connector:
Amazon DynamoDB
Qlik Application Automation connectors
The remaining charts in the visualization and the dashboard bundle are getting general styling including font styling of titles, background color and image options and border and shadow settings.
The charts impacted by this change are
Multi KPI
Network
PL Pivot
Radar
Trellis
Variance waterfall
Word cloud
Animator
Date range picker
Variable input
Video player
In-app subscriptions are now more powerful with the use of bookmark capabilities, allowing for dynamic expressions to be used in report creation! When creating and sharing subscriptions, use expression search to filter the data at report generation time based on date expressions, calculated values, and more… allowing for more accurate reports!
With the launch of Qlik Talend Cloud we introduced the Starter edition to simplify the experience of creating connections and projects for straightforward replication tasks. As part of this improved experience a data space, called Default_Data_Space, is automatically created in every tenant.
This feature is extended to all editions of Qlik Talend Cloud: Starter, Standard, Premium and Enterprise.
The owner of Default_Data_Space will be the first admin to enter the tenant, and all users of the tenant will be automatically granted with the following permissions:
Can view
Can consume data
Can edit
Can manage
Can operate
The following improvements require Qlik Data Gateway - Data Movement 2024.5.7 or later. For upgrade instructions and a list of resolved issues, see Upgrading the Data Movement gateway installation.
Support for automatic loading of new tables in replication tasks
Tables created in the source database during the replication data task that match the include pattern, will now be automatically captured during CDC (Change data capture).
Microsoft SQL Server (MS-CDC) source enhancements
Timestamp and transaction ID preservation
Previously, when reading multiple transactions from Microsoft SQL Server (MS-CDC), Qlik Talend Data Integration would preserve the transaction ID and timestamp of the first transaction only. On the target, this gave the appearance of the records being part of a single transaction. Now, Qlik Talend Data Integration will preserve the original transaction ID and timestamp for each individual record. This benefits customers who wish to leverage the Transaction ID and Timestamp header columns in Change tables.
Transaction ID bytes order
Previously, the bytes in the transaction ID were encoded in reverse order. From this version, the bytes will be encoded in the correct order. Information Customers who would rather preserve the existing behavior can do so using internal parameters. For details, please contact Qlik Support.
Support for caching SHA-2 pluggable authentication with MySQL
Qlik Talend Data Integration now supports caching SHA-2 pluggable authentication (caching_sha2_password) when working with MySQL sources or targets, either on-premises or in the cloud. In previous versions, only Native Pluggable Authentication (mysql_native_password) was supported.
Amazon Redshift data type mapping changes
BYTES and BLOB data types will now be mapped to VARBYTE on Amazon Redshift instead of VARCHAR.
Data sources
PostgreSQL 16.x
Target platforms
Drivers
Support for the following database versions has been discontinued:
Transformation flows are now supported in data pipeline projects using Microsoft SQL Server as target. Users can now develop graphical transformations alongside the custom SQL based transformations to support complex requirements for reshaping data.
With Qlik Answers, users can unlock the potential of unstructured data through a plug-and-play assistant using Large Language Models (LLMs).
Qlik Answers creates an end-to-end RAG solution with two major components.
Knowledge Bases
Create a repository of knowledge using 8 types of connectors. Use filters and regular expression to define how you want to add data to a knowledge base.
Connectors: Qlik Catalog, Amazon S3 and S3 V2, Dropbox, Sharepoint, Azure Storage, Google Cloud Storage, SFTP
Accepted files: PDF, DOCX, PPTX, TXT, MD, HTML, ODT, RFT
Index data sources, in which unstructured data is stored in a vector databases that will be used in the assistants. Users can also set a daily indexing schedule, discover changes in a data source, and view a history of indexed documents.
Knowledge base access control simplifies the management of which users can ask and view data from different sources.
Assistants
Ask questions about information in connected knowledge bases and give feedback on answer quality.
Customize your assistant with a welcome message and conversation starters which are one-click questions that guide end users towards their first questions.
Review all threads as an Audit Admin and view which threads are marked with positive or negative feedback. If the source content is inaccurate, fix it so that future answers are accurate.
PDF files produced from tabular reporting can now respect locale formatting of dates and numbers. The following capabilities have been introduced:
For report tasks, the report developer can define the locale to be used for dates and numbers during task execution when the PDF format is selected.
For on-demand tabular reports to be produced in PDF format, the user's Qlik Cloudlocale will determine the formatting of any dates and numbers in the report.
When generating a preview in PDF format from the Qlik add-in for Microsoft Excel, the user's Microsoft Excel locale will determine the formatting of any dates and numbers in the report.
SQL Expression processor is now available as part of Transformation flows in Qlik Cloud Data Integration. The SQL Expression processor lets you write simple or complex SQL expressions to process data in a new column of your source dataset.
Qlik Talend Cloud now supports automated ALTER of tables when making changes to the data type of columns in your data pipelines, avoiding the need to drop and recreate tables. This enables a simpler metadata change experience and offers the ability to retain historical data when adjusting data types.
Direct Access gateway 1.6.7 introduces new capabilities and resolves several issues, including security vulnerabilities.
Support for automatic port allocation when working with process isolation
Previously, it was not possible to set the [ODBC|SAPBW|SAPSQL|SAPPACKAGE]_MAX_PROCESS_COUNT value higher than 10 when using the default port number and range settings. From this version, ports will be allocated automatically, allowing the number of concurrent reload processes to be greater than 10.
Enhanced metadata paging when working with the SAP SQL (via Direct Access gateway) connector
With this enhancement, when 10,000 tables or more are retrieved, the tables will be retrieved in batches of 10,000 to prevent timeouts.
To benefit from the enhancements and resolved issues, customers are encouraged to upgrade at the earliest opportunity. For upgrade instructions and a list of resolved issues, see Upgrading the Direct Access gateway installation
Qlik AutoML has an enhanced user experience and improved capabilities.
A tabbed interface allows you to navigate between various processes in your model training experience. The various tabs, as well as the experiment configuration panel, allow you to perform numerous tasks to help you train and optimize your model.
Navigating the experiment interface
Intelligent model optimization provides automatic refinement of the models you train in an experiment. With intelligent model optimization, features that can negatively affect model performance are automatically excluded from model training. With a well-prepared training dataset that includes all relevant features, you can expect intelligent model optimization to train ready-to-deploy models within a single version.
Intelligent model optimization
Enhanced capabilities for model analysis have been added to Qlik AutoML:
In the Compare tab of the experiment, you can view all model scores and hyperparameters for the models you train.
In the Analyze tab of the experiment, you can focus on a single model for in-depth analysis of its predictive performance.
The new Starter edition introduces a streamlined user experience with an intuitive user interface that eliminates the need to learn about more advanced options. As its name suggests, the Starter edition is aimed at getting you started with your data projects as quickly as possible, effortlessly building simple, linear data replication pipelines with proven value, at speed.
Refreshing metadata provides the ability to manually trigger a refresh the metadata of a dataset when the dataset is based on a source object. This will detect new and removed columns, changes to existing columns such as data type changes, and renamed columns.
For example, in a Landing task you can refresh the metadata for TABLEA from its data source to add, alter, or understand which columns that have been removed.
You can trigger a metadata refresh for individual datasets or complete tasks in:
Replication tasks (Replication project)
Lake landing tasks (Replication project)
Landing tasks (Pipeline project)
Registered data tasks (Pipeline project)
In pipeline projects with transformations, columns will not be automatically deleted. This is to ensure that downstream transformations will continue to work if columns are removed in the source.
We are pleased to introduce a new data loader capability that doesn’t require you to install a gateway or any drivers. This new gateway-less data loader is designed for SaaS based cloud sources and some database sources. It is available as an option in Qlik Talend Data Integration and included in all editions: Starter (required), Standard, Premium and Enterprise.
The new landing page combines the Getting Started and Home pages into a single starting point. The getting started section at the top highlights key actions to get value from Qlik Talend Data Integration. Once familiar, you can hide the Getting Started section, keeping the page as your launchpad for data integration.
Shortcuts on the new home page surface the actions you need to take based on your role. They guide you through data integration tasks effortlessly, making your experience more intuitive and efficient. We have also added components for recently modified items and notifications. They provide quick access to what you are working on, and ensure you don't miss any significant updates in your account.
With Qlik Talend Cloud, users can unlock data value through data products, a unique product-centric approach to streamlining end-to-end data management.
Data products are valuable because data product teams can quickly produce high-quality, curated, domain-centric data assets, that can be easily accessed by data consumers and leveraged in several business use cases across the organization. This closes the gap between what data producers are putting together and what data consumers need. Just like real products, data products are built iteratively and have a lifecycle - from creating a data product to managing the quality of the data product, activating it into the data marketplace, and deactivating it when they are no longer needed.
Qlik Talend Cloud brings together an integrated data management experience – from data integration to transformation, data quality, and governance. The data product catalog in Qlik Talend Cloud offers several key capabilities to manage the data product lifecycle end-to-end.
Qlik Data Integration Marketplace
In conjunction with the release of new data loading capabilities, we’ve greatly expanded the number of SaaS applications that Qlik Talend Cloud can connect with. From Accelo (Professional Services Automation) to Zift (channel marketing & management), you can now use Qlik Talend Cloud to access data in 100 more applications that are focused on CRM & Sales, Communication & Messaging, E-Commerce, Finance & Accounting, Marketing & Advertising, Project Management & Collaboration, Social Media and more.
Qlik’s Capacity-based pricing model, which was initially launched in 2023 for Qlik Cloud, has now been extended to cover the Qlik Talend Cloud set of offerings as well. Qlik Talend Cloud comes in four editions: Starter, Standard, Premium and Enterprise.
For more information on these editions, please visit our new pricing page at Data Integration and Quality Pricing.
Customers can choose an edition based on the capabilities they need and commit to the required capacity for that edition. The primary value metrics relevant to Qlik Talend Cloud include Data Moved, Job Executions and Job Duration. Customers subscribing to one of these editions will have the option to monitor their entitlements and corresponding usage through the Data Capacity Reporting App.
The Qlik add-in for Microsoft Excel has an optimized connection update flow to guide users through moments where there is a need to reconnect a template to a copy of an app or to an app in a different space or tenant. This is particularly handy for the managed space reconnection situations where you can now easily select the desired space and application from a selection list.
Getting started with the Qlik add-in for Microsoft Excel
The new straight table in the Visualization bundle gets two enhancements. First is text styling by expression: set the dimension or measure to any combination of bold, italic, underline, and strikethrough using a second expression with tags <b>,<i>,<u> and<s>. Second is modifiers: turn your measure into an accumulation, a moving average, a difference, or a relative number with a single drop down.
Qlik Application Automation now supports the following connector:
Amazon DynamoDB
Qlik Application Automation connectors
The new Qlik Marketo connector provides seamless access to data stored in a Marketo database. This connector has all general configuration options directly in the connection definition user interface, and it supports authentication using either username/password or OAuth.
The previous JDBC-based Qlik Marketo connector will continue to be supported until end of July 2024.
SQL Assistant is now available as part of Qlik Cloud Data Integration. SQL Assistant is a co-pilot feature that makes it easier to write SQL queries.
SQL Assistant in a SQL transformation
SQL Assistant, available as part of the SQL transformation capability, allows you to describe what you want to achieve in natural language. Based on this prompt, the AI SQL Assistant will generate a SQL query to use as part of your transformation.
At launch, SQL Assistant is available for the US East, Ireland, Frankfurt and Sydney regions.
Generating a SQL transformation from a text prompt
Major changes have been made to navigation across the platform with the introduction of Activity Centers. These provide a common anchor point with the waffle menu in the top-left corner throughout the whole platform, and more generally make it easier to navigate, with areas focused on consuming insights and creating analytics, and get started creating new content. These changes also allow administrators to curate content and insights for consumers, and let all users interact with Insight Advisor Chat and browse content in parallel.
Three great additions to sheets and the asset panel!
The sheet navigation has moved to the left asset panel for easier navigation, alongside Bookmarks and Notes.
Grouping of sheets makes sheets easier to organize and find.
Pinning and resizing of the left asset panel makes the panel more readable and flexible.
The new straight table in the visualization bundle gets two enhancements. First is text styling by expression: set the dimension or measure to any combination of bold, italic, underline, and strikethrough using a second expression with tags <b>,<i>,<u> and<s>. Second is modifiers: turn your measure into an accumulation, a moving average, a difference, or a relative number with a single drop down.
Introducing a new Context menu for visualizations toggle in Qlik Cloud, enhancing app customization and user experience by allowing flexible control over the context menu visibility within app properties.
The following improvements require Qlik Data Gateway - Data Movement 2023.11.23 or later. For information about how to upgrade, see Upgrading the Data Movement gateway installation.
Snowflake metadata schema
From this version, the Snowflake metadata schema (for staged files) will be created if it does not exist.
After a change was made to a Rename dataset rule (that concatenated the table name with the schema name) and a View was added to the landing task, the Prepare operation would fail with the following error:
QRI SQL error not implemented.
When moving data from SQL Server, a missing column name in the table definitions would cause an infinite notification loop in the repsrv.log file, with the following message:
mssql_resolve_sqlserver_table_column_attributes(...) failed to find column
When we first introduced the replication use case in Qlik Cloud Data Integration projects, we started with supporting database targets such as Microsoft SQL Server, Oracle, MySQL, and others. As part of our continued commitment to support a wide range of targets with this use case, we are pleased to announce that we have added support for cloud data warehouse targets.
When creating a data replication task it is now possible to select cloud data warehouse targets including Snowflake, Databricks, Microsoft Fabric and Google BigQuery.
Make your highly formatted tabular reports available to in-app users so they can set their preferred data selections and download the file to their desktop immediately. This is especially useful if your users need to:
Generate standardized documents for printing.
Produce complex, dimensionally driven worksheets of tabular data for downstream analysis.
Users simply need to make selections during analysis, and then download a tabular report to their desktop using the assets panel.
The new project level data view streamlines troubleshooting for complex data pipelines as it allows users to view dataset metadata and sample data for tasks from the pipeline perspective without having to enter each task. This capability is secured by the Can View Data role to ensure only users with explicitly granted permissions can view data in the data platform.
The new pivot is getting a quality of life improvement, find copy cell value in the context menu.
Users can now enable or disable autocomplete hints when writing Qlik script in the script editor, data load editor, and expression editor.
Qlik Cloud Government now supports the following Qlik Application Automation connector:
OAuth 2
Qlik Application Automation connectors
Create and manage automation connections in shared spaces and allow other users in your tenant to use these connections in their automations.
More information can be found on Qlik Community: Shared automation connections
Beginning today, the event com.qlik.v1.analytics.analytics-app-client.sheet-view.opened will begin appearing in the Events section of the Management Console and Audits API. This event logs each time a sheet is viewed in an app. With this information, you can track sheet usage within your analytics applications.
Images can now be embedded in the new straight table and pivot table in the visualization bundle. The images can be sourced from the media library or from a URL.
The script editing experience has been improved in the Data load editor and now offers the same functionality as the Script editor.
The editor now includes a data preview feature, allowing Qlik Cloud users to get better insight when writing script to load data. Visual wizards have been added to easily write Store statements or include QVS files. The editor also adds usability improvements such as resizable panels and the possibility to preview the content of the included QVS files.
Using the ServiceNow (via Direct Access gateway) connector, customers can now securely access firewalled ServiceNow data sources over a strictly outbound, encrypted, and mutually authenticated connection.
The following improvements require Qlik Data Gateway - Data Movement 2023.11.11 or later. For information about how to upgrade, see Upgrading the Data Movement gateway installation.
Parallel metadata retrieval
Added support for concurrently retrieving the metadata for multiple tables.
Improved monitoring performance
The monitoring information for landing and replication tasks will now be updated every 10 seconds (instead of every 60 seconds), providing a more precise indication of their current status.
Newly supported region
Japan is now supported as a Qlik Cloud tenant region.
Tasks with a MySQL source would sometimes fail with the following error during CDC:
Read next binary log event failed; mariadb_rpl_fetch error 0 Error reading binary log.
When the source table contained CLOB columns and the "Limit LOB size" value exceeded 10240, replication to Snowflake would fail with the following error:
Invalid character length: 0
Using the ServiceNow (via Direct Access gateway) connector, customers can now securely access firewalled ServiceNow data sources over a strictly outbound, encrypted, and mutually authenticated connection.
You can now create a link to a specific sheet as an asset in the Catalog. This allows you to promote specific sheets from apps to public collections and further on a custom home page, helping your analytic consumer to find relevant content faster.
Qlik is removing the `com.qlik.user-identity.impersonation` from the audits service in Qlik Cloud. Events of this type will no longer appear in the Events panel in your tenant's management console and responses from the audits API will no longer include this event.
This change is a result of analysis to improve the performance of the audits service. Analysis showed this event is not widely consumed by customers, therefore, the decision has been taken to remove it. In addition, this change will make it possible to surface more usage events to customers through this service.
This change will take effect on July 13, 2024, sixty days from May 14, 2024.
Direct Access gateway 1.6.6 introduces new functionality as well as enhancements to existing functionality.
New features and enhancements
Direct Access gateway 1.6.6 introduces the following features and enhancements:
Support for accessing ServiceNow via Direct Access gateway
This version introduces support for the ServiceNow (via Direct Access gateway) connector, allowing customers to securely access firewalled ServiceNow data sources over a strictly outbound, encrypted, and mutually authenticated connection.
Support for new authentication methods when using the following Direct Access gateway connectors:
Enhanced metadata paging when working with ODBC connectors
With this enhancement, when 10,000 tables or more are retrieved, the tables will be retrieved in batches of 10,000 to prevent timeouts.
.NET 8.x requirement
From this version, customers will be required to install both .NET 6 and .NET 8.x in order to work with Direct Access gateway. During installation or upgrade, setup will install them automatically if they are not already installed.
Improved supportability
To aid troubleshooting, additional logging has been added that measures the duration of Direct Access gateway requests.
To benefit from the enhancements and resolved issues, customers are encouraged to upgrade at the earliest opportunity. For upgrade instructions and a list of resolved issues, see Upgrading the Direct Access gateway installation
.Cyclic master dimensions introduce a novel dimension type, empowering users to select dimensions from a group and seamlessly switch them across the entire application. Unlike drill-down groups, cyclic dimensions lack a hierarchical structure, yet they resemble alternative dimensions, extending their influence app-wide.
By employing cyclic dimensions, valuable app and screen space is conserved, allowing a series of charts to offer multifaceted analyses. For instance, transitioning from temporal to geographical or product category-based measures is effortless. Toggling the dimension is facilitated either through a button action or axis label.
Additionally, with cyclic dimensions, naming the levels within cyclic and drill-down groups becomes possible. Engine functions exist to query the group's state, aiding in the creation of dimension-dependent measures or indicating the state through labels.
A Qlik Cloud tenant can now use an OAuth 2.0 connection to a Microsoft 365 email provider to enable Qlik Cloud email notifications and report delivery.
Before configuring, please review Configuring a Microsoft 365 email provider using OAuth2.
Qlik Cloud now supports the ability to upload, view, and include QVS files in load scripts. Better support and improved usability of QVS files promotes scripting best practices, such as script reuse and modularity. Once uploaded to Catalog, Qlik Cloud users can view QVS file content using the new QVS viewer. QVS files may include reusable content such as subroutines, variables, color palettes, or calendars. QVS files can be included across apps and scripts within Data load editor and Script editor.
The new Qlik DynamoDB connector provides seamless access to data stored in a DynamoDB database. This connector has all general configuration options directly in the connection definition user interface, and it supports authentication using AWS IAM credentials (access key & secret key) or a credentials file.
The previous JDBC-based Qlik DynamoDB connector will continue to be supported until end of July 2024.
The button gets a new setting so expressions can be evaluated in runtime. This allows for values set in an action to be carried forward to future actions in the chain.
When creating a tabular reporting task, you could previously add a maximum of 100 recipients to the task. This task maximum has been altered to allow for 100 unique reports to be generated from a task.
We're thrilled to announce a significant enhancement to the performance evaluator in Qlik Cloud. Now, you'll receive reports when sub-parts of an object encounter issues or cannot be evaluated. This includes scenarios such as:
Calculation conditions applied to measures or dimensions within an object.
Instances where a reference to a measure or dimension has been removed from the master item library, affecting object functionality.
Situations where expressions are disabled due to various reasons, ensuring you're aware of any potential impact on your analytics.
The Qlik Cloud documentation has been updated with a new overview of how to create inline loads in your apps and scripts. Inline loads are a powerful way to manually add data for use in analytics. The new guide provides use cases, detailed syntax descriptions, and examples.
We are pleased to announce that the no-code transformation designer is now part of Qlik Talend Data Integration. The simple drag-and-drop interface makes creating visual transformation flows easy for both data engineers and non-SQL experts alike. You can use transformation flows as an alternative to custom SQL code as part of your ELT data pipelines.
Transformation Flow designer
The transformation flow designer offers a palette of various data transformation processors to cleanse and shape your datasets. Transformation processors offer various data manipulation operations such as string and number functions, cleansing, and hashing, and re-structuring capabilities such as joining, aggregating, and filtering data.
Qlik Talend Data Integration converts transformation flows to SQL statements, orchestrates them, and pushes them to your data platform of choice for runtime execution. Snowflake, Databricks, Google BigQuery, Azure Synapse Analytics and Microsoft Fabric are supported data platforms.
Finally, transformation flows support all automated SQL-based transformation capabilities, including materialization, incremental processing, and type 2 history tracking.
We have now added support for Claude 3 Sonnet and Haiku in the Anthropic (Amazon Bedrock) analytic connector within Qlik Cloud.
Qlik Cloud Government now supports the following Qlik Application Automation connectors:
Amazon SNS
GitHub (including GitHub Government)
Qlik Application Automation connectors
The Resource Center is now supported in Qlik Cloud Government. From there, you can access in-product announcements, onboarding resources, in-product help, videos, survey and feedback options, and industry walkthrough options.
The Resource Center is available from the main toolbar almost anywhere in Qlik Cloud except Qlik Sense apps.
Exciting news! Qlik is introducing a much-anticipated feature: custom security roles.
What can custom security roles accomplish? These roles offer precise management over data export and access permissions within Qlik apps. This empowers you to customize permissions according to your unique requirements, bolstering data security and compliance.
Our initial release includes the ability to regulate content export permissions. Following this, we'll be rolling out further capabilities, such as control over data connection creation, report generation, and more. Stay tuned for these enhancements!
We continue to improve on the new Straight table and Pivot table. The Straight table columns can now become more narrow and the new Pivot table gets measure formatting, text alignment and dimension limits.
Qlik Talend Data Integration provides multiple methods of capturing data from your SAP system. This release enhances existing capture methods with support for SAP ODP. The ODP connector provides connectivity to the SAP ODP framework, enabling data capture from multiple types of data artifacts such as Extractors, CDS views, BW objects, and SAP HANA Information views.
Replication tasks provide support for handling DDL changes (schema evolution). When using PostgreSQL or Microsoft SQL Server (using MS-CDC) as your data source, the task will create DDL artifacts in the source databases to enable DDL changes to be captured. You can also define a specific schema to hold those objects, which allows users to isolate Qlik Cloud created objects from source data objects.
Qlik Talend Data Integration now includes support for SAP HANA as a backend database for the SAP Application connector. SAP HANA continues to be supported for direct access using the SAP HANA connector. This release adds the SAP Application connector functionality where you are running SAP on HANA and provides business group management capabilities. Business groups allow SAP users to create groups of tables that are recognized by Data Movement gateway, providing additional context when selecting data artifacts to be replicated..
Direct Access gateway 1.6.5 introduces new functionality as well as enhancements to existing functionality.
New features and enhancements
Direct Access gateway 1.6.5 introduces the following features and enhancements:
Support for the SAP ODP connector
This version introduces the ability to access a SAP ODP source via Direct Access gateway. To facilitate this, a new Data gateway field has been added to the SAP ODP connector. The new field allows customers to choose which gateway to use to access their SAP ODP source.
See also: SAP ODP Connector
Extended logging capabilities
This version introduces a new logger that Qlik Support can use to troubleshoot issues with specific gateway components.
Newly supported region
Japan is now supported as a Qlik Cloud tenant region.
Performance enhancement
Improved memory allocations for encrypted sessions.
Resolved issues
Direct Access gateway 1.6.5 resolves the following issues:
Security vulnerability
Secrets would be written to the DCAAS log when working with the ODBC connector.
Process isolation performance
Processes would take a long time to start under heavy load.
Incorrect installation path
Installing Direct Access gateway would always set Qlik as the root folder, even if the user chose a different folder in the setup wizard.
To benefit from the enhancements and resolved issues, customers are encouraged to upgrade at the earliest opportunity. For upgrade instructions, see Upgrading the Direct Access gateway installation.
The Qlik Cloud Analytics hub experience can now be customized by creating a custom home page for all users in a tenant. This feature lets you promote relevant content to users by populating the page with curated public collections containing the content of your choice, such as apps, datafiles, and links.
Customizing tenant-wide home pages for the Qlik Cloud Analytics hub
You can now format dimension columns to display values as clickable links in the Straight table and the Pivot table, both in the Visualization bundle.
SCIM (System for Cross-Identity Management) is an open standard for automating the exchange of user identity information between identity providers and enterprise applications.
Qlik Cloud now supports SCIM, which can:
Simplify user management
Improve security
Ensure that user information is consistent across all systems, reducing the likelihood of errors or discrepancies
Improve the user experience by making it easier for users to access the resources they need by providing a consistent experience across different systems.
Qlik Cloud supports SCIM connectors that work with Microsoft Azure Active Directory (Azure AD) and is compatible with SCIM 2.0
Provisioning users and groups using SCIM
The color picker gets an opacity control to make it easy to adjust the transparency of the color with a slider. This is convenient for making the sheet background shine through, or make stacked charts more elegant. As a bonus, you can now also paste a hex color code with or without #.
You can now manually reload selected tables from most data tasks, including transform and data mart tasks. This is useful when you need to recover tables with a data error, or if you simply want to refresh the table content. All data task types now offer the ability to execute a reload operation on selected datasets without needing to recreate the task. Datasets in current and downstream data tasks will be reloaded the next time they are run.
Tabular reporting tasks can now be developed and configured against Qlik Cloud applications published in managed spaces. The Qlik add-in for Microsoft Excel now allows for connection to apps located in managed spaces for report template authoring, if required. Published apps will carry forward any distribution list definitions in the load script and will use managed space data source configurations for distribution list update. All other task elements of the reporting task can be created in the managed space to allow for app/space specific configurations.
Tabular reporting in managed spaces
Tabular reporting in managed spaces
In Qlik Cloud, OAuth impersonation tokens enable web applications to create access tokens on behalf of users within the tenant where the OAuth client is registered.
Administrators assigning the admin.apps scope to OAuth machine-to-machine tokens can use APIs to manage all the metadata in Qlik Cloud applications.
When hiding the sheet title, the sheet navigation buttons will be available in the selection bar instead of being hidden.
Triggered & web hook automations will be stored in the queue for a maximum of 14 days. After this period, if the automation still hasn't run, it will be removed from the queue and its status will be set to failed. Automations that contained a payload can be retried manually by clicking the retry button in the automation's history view.
We’re continuing to expand the connectivity of Qlik Talend Data Integration with a new group of connectors that just got released. These connectors will enable you to gather business data from more applications that focus on finance, advertising, and human resources as well as other subjects. By eliminating the need for custom connectors to access these sources, Data Engineer productivity is increased and Data Consumer’s time to insight is decreased.
ADP
Enverus OpenInvoice
Google AdMob
Google AdSense
Google Business Profile
Google Play
Google Workspace
Infor Data Lake
PagerDuty
SAP Employee Central Payroll
RingCentral
TikTok
UKG Pro Workforce Management (formerly Dimensions)
We’ve added more capabilities as well as consolidated all connectors into one common interface. This means that regardless of whether it’s a source, target or application, users will have a similar, streamlined interaction. This includes improved searching and filtering capabilities along with displaying all recently selected connectors.
Improved create connection interface
In this release we have added support for DDL propagation (also referred to as schema evolution) in data Replication tasks.
When setting up Replication projects it is now possible to configure data replication tasks to automatically synch DDL operations that occur on the source system with the target. Apply DDL changes to target table can be enabled for events such as;
adding new or altering existing columns
adding new tables based on a wildcard pattern for table selection.
In addition, we have also added two new options for using strings to customize table names and column names when storing changes in Change Tables.
Suffix – You can specify a string to use as a suffix for all Change Table names e.g. add the default value “_ct” to the target table called “HR” (HR_ct)
Header column prefix – You can also specify a string to use as prefix in all of the new tables columns. E.g. add the default value “header_” to the column “timestamp” (header_timestamp)
Qlik Cloud Government now supports the following Qlik Application Automation connectors:
Azure Blob
FTP
MySQL
Postgres
Sagemaker
SFTP
Qlik Application Automation connectors
Users who create data gateways in the Management Console can now receive a notification whenever a new data gateway version becomes available for download. The "New data gateway version is available" notification can be found in the Management Console under Profile settings > Notifications > Data gateways.
AutoML now enables users to change or refresh a dataset used for an experiment version from the catalog. This allows for changes in the feature list between versions and for updated rows to be used for training such as for retaining a model following evidence of drift.
With the new space role Can Operate, it is possible now to control who can reload data / apps in Managed Spaces or create or manage scheduled reloads at a more fine grain level. Users do no longer have to be assigned to the existing space role Can Manage for being able to reload data.
Managed space permissions for users with Professional or Full User entitlement
You can now view the underlying physical objects that constitute your datasets without leaving Qlik Talend Data Integration. You also have the ability to view data samples of datasets’ physical objects. Data samples can be filtered and sorted. This feature make it easy to see and validate the shape of your data as you are designing your pipelines.
Physical objects and view data
In addition, you can also preview the result of a SQL transformation directly in Qlik Talend Data Integration. It allows you to easily validate your SQL transformation without the need to prepare and run the transform task and without leaving Qlik Talend Data Integration.
The following improvements require Qlik Data Gateway - Data Movement 2023.11.4 or later. For information about how to upgrade, see Upgrading the Data Movement gateway installation.
Customers can now install Data Movement gateway on Red Hat 9.x or on any corresponding and compatible Linux distribution.
Setting up Data Movement gateway
The commands for stopping, starting and checking the status of the Data Movement gateway service have changed.
Data Movement gateway service commands
This section lists the newly supported databases, database versions, and driver versions.
Newly supported data source versions and editions
The following data source versions are now supported:
Newly supported target data platforms and editions
The following data target versions are now supported:
Newly supported SAP HANA driver version
Customers with a SAP HANA source who want to install Data Movement gateway on Red Hat Linux 9.x, must install SAP HANA ODBC 64-bit Driver version 2.0.19 or later.
This section provides information about end-of-support database versions.
Support for the following data source versions has been discontinued:
Direct Access gateway 1.6.4 introduces new functionality as well as enhancements to existing functionality.
New features and enhancements
Support for viewing and downloading log files from the Administration activity center
This version introduces the ability to view Direct Access gateway log files in the Administration activity center and share them with Qlik Support if needed. Under normal circumstances, there is no reason to view the log files, but should you experience repeated failures or other issues, the log files will often help pinpoint the cause.
See also: Viewing and downloading log files
Support for installing Direct Access gateway silently
Customers can now install Direct Access gateway silently, which is useful if you need to install Direct Access gateway on several machines throughout your organization.
Improved session continuity
When a reload session expired, a DirectAccess-1012 error would sometimes occur. Now, Direct Access gateway will try to keep the reload session alive by pinging Qlik Cloud more frequently.
Resolved issues
Direct Access gateway 1.6.4 resolves the following issues:
Incorrect parameter name in the configuration.properties file
When performing a new installation of Direct Access gateway, the EXTEND_FIRST_REQUEST_TIMEOUT parameter name in the C:\ProgramData\Qlik\Gateway\configuration.properties file would incorrectly be called FIRST_REQUEST_TIME_EXTENSION.
Reload pod availability
When multiple reloads shared the same reload ID, the number of reload pods in QCS would reach the maximum.
To benefit from the enhancements and resolved issues, customers are encouraged to upgrade at the earliest opportunity. For upgrade instructions, see Upgrading the Direct Access gateway installation.
When storing a single table to Parquet format, it now requires opt in to use nested data using the delimiter is option. This ensures backwards compatibility with store commands which do not intend to trigger nested formatting.
Qlik Cloud now offer peak values of your consumption, which makes it easier to fetch the capacity used per day in monitoring apps as well as showing consistent charts in the Management Console. One example where this is used is your "Large App capacity" consumption.
Qlik Sense applications running in Qlik Cloud rely on Analytics Data Connections to load data from external sources. The first API to support the creation of these connections was the Data Connectivity as a Service (DCaaS) API released in September 2023, and this and additional capabilities have now been merged into the data-connections API.
This release of the data-connections API supports creation of direct analytics connections, as well as connections via the direct access gateway, to all analytics data sources.
Managing data connections: Overview
Support for SAML identity providers is now available in Qlik Cloud. Customers can configure their corporate identity provider to authenticate users to tenants using the SAML protocol. Please review the help documentation to follow the steps to set up SAML in your tenant.
Creating a new interactive SAML IdP configuration
When using tabular reports, report developers can configure the report file output to be PDF. This configuration can be done in the report task, and users of the Qlik Add-in for Microsoft Excel can also preview a report output in PDF file format as well. This expands the capability of tabular reporting to support multi-page, highly formatted, read-only (PDF) report creation and distribution.
Tabular reporting with Qlik Cloud Analytics
ML Deployments now supports generating Coordinate SHAP datasets for Multiclass Classification models.
Generating SHAP datasets during predictions
We have expanded our support for SAP with a new SAP ODP Connector for Qlik Cloud Analytics. This connector provides connectivity to the SAP Operational Data Provisioning (ODP) framework which includes many benefits to SAP users vs. previous, existing SAP connectors including:
Simplified access to CDS Views and HANA Views
Access to Extractors, without the use of standalone network service
Usable with a SAP Runtime license
Does not require any separate Qlik SAP Connector license
No need for an SAP transport installation, particularly useful with an SAP managed cloud system
Up to 25% faster performance vs. Qlik’s existing SAP connectors
Qlik Cloud Analytics – SAP ODP Connector
Qlik Application Automation now supports the following Qlik Application Automation connectors:
Basic Authorization
Amazon Lambda
Amazon Redshift
Amazon S3
Azure OpenAI
Application Automation Connectors
Direct Access gateway 1.6.3 includes the following enhancements and bug fixes:
Data loss prevention
In previous versions, to prevent potential data loss, Direct Access gateway did not automatically reconnect to the data source during a reload. From this version, Direct Access gateway will now automatically reconnect to the data source as needed. To prevent data loss, the completed reload summary will be verified before reconnecting. If data loss is detected, the reload will fail.
Timeout for reload sessions
In rare scenarios, the reload session would stay alive indefinitely. To prevent such occurrences, this version introduces a three-hour timeout for reload sessions.
Timeout extension for load requests
Reloads would sometimes fail with the following errors:
Connector error: The session does not exist (DirectAccess-1509)
Connector error: The stream session expired for the load data request (DirectAccess-1012)
To mitigate this issue, an EXTEND_FIRST_REQUEST_TIMEOUT parameter (for extending the load request timeout) was added to the C:\ProgramData\Qlik\Gateway\configuration.properties file. The unit of measurement for the parameter value is minutes. Customers who frequently encounter these errors should try setting the value to 5-10 minutes.
For detailed instructions, see Troubleshooting Direct Access gateway
Support for detailed connection error messages
Added support for viewing detailed connection error messages when using ODBC-based via Direct Access gateway connectors. Customers can now set the ShowErrorDetailMessage parameter in the Advanced connector settings to "true" to see the full error returned by the ODBC driver. The detailed error message will be show in the Data load editor.
Handling multiple reloads with the same reload ID
From this version, the engine session ID will be used to distinguish between multiple reloads with the same reload ID. This will prevent potential conflicts, resulting in reloads failing with the following error:
Connector error: data loading error (DirectAccess-4008
To benefit from the enhancements and resolved issues, customers are encouraged to upgrade at the earliest opportunity. For upgrade instructions, see Upgrading the Direct Access gateway installation.
The Button gets a new navigation option for Go to sheet: specify chart. This is useful for jumping to content or back to top and can be used within an app or on a single sheet.
Adding a button to navigate to a sheet with a specific chart highlighted
Qlik has achieved the following updated or new certifications:
ISO 27001:2022 (Updated)
ISO 27017:2015 (New)
ISO 27018:2019 (New)
IRAP Protected (New)
For more information about these Qlik Cloud certifications and attestations, see:
Customer Managed Keys (CMK), now supports and uses AWS Multi-Region Keys:
AWS Multi-region keys allow you to continue to access and process encrypted data when a primary region is experiencing an outage. By creating a replica of the key, you can decrypt data in the backup region, and any data encrypted in the backup can later be decrypted in the primary region once it is restored.
Transitioning from Single Region Keys to Multi-Region Keys:
Qlik recommends migrating from Single Region Keys to Multi-Region Keys in order to seamlessly maintain tenant access in case of a disaster outage event in your primary region.
All new CMK Keys will use Multi-Region Keys starting immediately.
If you use a new key during key rotation, you will be forced to use a Multi-Region Key setup.
Qlik associative engine now includes support for loading and storing to nested fields with a parquet file. This support is available when loading and string data using Qlik Sense and the script editor.
Using the Source type filter, it is now possible to create monitor views filtered on tasks with specific source technologies (e.g. SAP and SQL Server landing or replication tasks).
Using the Data gateway filter, it is now possible to create a monitor view to see all tasks that rely on the selected Data Movement gateway. This helps to simplify operations of tasks on a specific gateway such as upgrading. From the monitor view it is possible to stop all tasks on the gateway prior to upgrading, after the upgrade is complete you can then review the tasks to ensure they are all operational.
Qlik Cloud Data Integration landing tasks are the first step of transferring data into your cloud data warehouse, or of landing data directly into your data lake. This release provides additional configuration options to control the behavior of the landing task and improve performance, including:
Control tables
Control tables provide additional status information in the target data platform such as the landing status, suspended tables and the task history, including the number and volume of records processing during landing.
Error handling policies
Error handling policies allow you to select what you want to happen when a data truncation or other data errors occur, such as Ignore errors, Suspend table or Stop the task.
We have also made changes to a few of the existing options within the landing and replication settings to help make them more intuitive.
Renamed tabs
The Runtime tab has been renamed to SaaS application to reflect the fact that its settings are only relevant when moving data from a SaaS application source. For Replication projects, the Replication mode tab has been renamed to Task modes and now has two sub-headings: Replication mode and Apply changes mode.
Relocated and renamed settings
The following changes apply to landing tasks only:
The following changes apply to both landing tasks and "Land data in data lake" tasks:
You now have a new menu choice for copying style settings from one chart to another. This quality of life improvement makes it easier to style and work with charts. Especially now when all charts has many more styling settings.
The Qlik add-in for Microsoft Excel has been updated to support an action to change the template connection. The report templates produced from the Qlik add-in are linked via meta data to the Qlik Sense app they were authored against. This capability allows a template author to reconnect a template with a copy of an app or app/tenant combination. This will be useful for report developers authoring against App A and using the template against App B or moving/sharing app/template samples within a development community.
Changing the connected Qlik Sense app
Qlik Cloud now supports 2 new user roles to allow more control over which users can access AutoML.
Automl Experiment Contributor - controls who can create and contribute to ML Experiments and deploy ML models.
Automl Deployment Contributor - controls who can manage ML Deployments and predictions
Further UI controls are in place to allow read-only views of AutoML assets for those with view permissions in a space.
Space Owner and users with the "Can Manage" role, can now export Qlik Cloud apps from Managed Spaces. These apps can only be exported without data.
This possibility allows you to re-establish a parent - child relation of your source and published apps, in case the source app was accidentally deleted.
The already existing and embedded capability to run a performance evaluation can now help you focus even better on individual app object results. The overview now separates the result in sections which makes it easy to understand what kind of information you should focus on.
Direct Access gateway 1.6.3 includes the following enhancements and bug fixes:
Data loss prevention
In previous versions, to prevent potential data loss, Direct Access gateway did not automatically reconnect to the data source during a reload. From this version, Direct Access gateway will now automatically reconnect to the data source as needed. To prevent data loss, the completed reload summary will be verified before reconnecting. If data loss is detected, the reload will fail.
Timeout for reload sessions
In rare scenarios, the reload session would stay alive indefinitely. To prevent such occurrences, this version introduces a three-hour timeout for reload sessions.
Timeout extension for load requests
Reloads would sometimes fail with the following errors:
Connector error: The session does not exist (DirectAccess-1509)
Connector error: The stream session expired for the load data request (DirectAccess-1012)
To mitigate this issue, an EXTEND_FIRST_REQUEST_TIMEOUT parameter (for extending the load request timeout) was added to the C:\ProgramData\Qlik\Gateway\configuration.properties file. The unit of measurement for the parameter value is minutes. Customers who frequently encounter these errors should try setting the value to 5-10 minutes.
For detailed instructions, see Troubleshooting Direct Access gateway
Support for detailed connection error messages
Added support for viewing detailed connection error messages when using ODBC-based via Direct Access gateway connectors. Customers can now set the ShowErrorDetailMessage parameter in the Advanced connector settings to "true" to see the full error returned by the ODBC driver. The detailed error message will be show in the Data load editor.
Handling multiple reloads with the same reload ID
From this version, the engine session ID will be used to distinguish between multiple reloads with the same reload ID. This will prevent potential conflicts, resulting in reloads failing with the following error:
Connector error: data loading error (DirectAccess-4008
To benefit from the enhancements and resolved issues, customers are encouraged to upgrade at the earliest opportunity. For upgrade instructions, see Upgrading the Direct Access gateway installation.
When configuring Landing task settings, you can now fine-tune performance by controlling the frequency and the conditions under which changes will be applied to your target cloud data warehouses.
We are continuing to expand the supported targets for the Replication project in Qlik Cloud Data Integration, in addition to Amazon S3, you can now choose Azure Data Lake Storage (ADLS) and Google Cloud Storage (GCS) for data lake delivery, as Parquet, JSON or CSV file formats.
This release adds support for entering database names manually to the following connectors:
Source connectors:
Target connectors:
This enhancement is especially useful for customers with SQL Server based platforms as it eliminates the need to create the user on the master database (a requirement for selecting from a list).
In the coming weeks, this capability will be gradually extended to the other connectors.
Key Driver Analysis is a new capability in Qlik Cloud that leverages the power of Qlik AutoML to help people easily understand the most influential factors that are driving the outcomes in their analytics. Users can simply right click on any object to initiate a key driver analysis, specify a target measure and, and if desired, specific features they want to include. The AutoML engine will then generate an analysis that shows the fields in your data model that are most effecting the target measure, complete with visualizations and NLG.
You can see the key drivers ranked by importance, and can further select each one to get a breakdown and distribution of the values and their influence. With key drivers, users can better understand the reasons for historical results, not just the what but the why, providing deeper insight and supporting more meaningful action.
Uncovering the key influencers behind your data using key driver analysis
Custom SQL in Direct Query is a new feature that many customers have been asking for. The custom SQL statements are added in the load script and can be combined with variables and dollar expansion. Custom SQL opens up a lot of possibilities, we can now utilize database specific features like time travel, create inline tables, do type-in SQL in the UI, emulate calculated dimensions, do cascaded filtering, and much more.
In addition to being able to reload individual tables it is now possible to reload the target for the entire Landing Task in the event of a critical failure, such as failure in reading/parsing a source database for Change Data Capture (CDC). Or if critical issues occur with log-based CDC like missing transaction/archive logs in a source database. Reloading the entire Landing Task will also automatically restart the CDC process, if enabled, and additional downstream storage tasks will correct the storage data on the next execution, ensuring changes are tracked for historical management (Type 2 data).
See also: Running a landing task with Change data capture (CDC) and Running a landing data task with Reload and compare.
Direct Access gateway 1.6.2 resolves an issue that would sometimes cause the Connector Agent to crash when working in process isolation mode.
For upgrade instructions, see The upgrade procedure.
Qlik Cloud Government now supports the Qlik Platform Operations connector.
Qlik Application Automation connectors
Microsoft Fabric joins the ever-expanding list of data warehouses that can be used as targets in data pipeline projects.
Direct Access gateway 1.6.1 introduces several important features and enhancements, improving overall stability and performance.
Support for spreading reloads across multiple connector processes
Connector process isolation has been added to Direct Access gateway. This is an opt-in feature, meaning that it is off by default. Process isolation allows administrators with direct access to the gateway server operating system to control how many processes are available for reloads per connector type. Spreading reloads across multiple connector processes increases the level of isolation by reducing the number of reloads running concurrently on each connector process. This in turn can improve overall Direct Access gateway stability in cases where connector crashes have occurred.
Added the ability to disable chunking when working with the SAP BW (via Direct Access gateway) connector
This version introduces the BEX_ONE_CHUNK application parameter for the SAP BW (via Direct Access gateway) connector. When accessing SAP BW directly from Qlik Cloud (that is, not via Direct access gateway), to optimize performance, the result set is divided into chunks in the SAP backend and read as separate threads. However, when accessing SAP BW via Direct Access gateway, dividing the result set into chunks has no real advantage. On the contrary, it consumes more of the shared memory in SAP as it requires an additional temp table to be created for the duration of the data transfer. It's possible (though usually not required) to start chunking by setting BEX_ONE_CHUNK:false in the appsettings.json file, which is located in the SAP connector binaries folder.
Diagnostics improvements for SAP BW (via Direct Access gateway) and SAP SQL (via Direct Access gateway) connectors
For SAP BW (via Direct Access gateway) and SAP SQL (via Direct Access gateway) connector logs, a _port suffix was added before the log file name extension, and a ProcessID=### message was added to the connector's log files in order to distinguish between events from new instances of the connector listening on the same port.
Reconnection improvements
The reconnection mechanism during reload has been improved so that Direct Access gateway no longer needs to connect to the pod that started the reload (as was previously the case). Now, instead of repeatedly trying to connect to the pod that started the reload (which often resulted in reload failures), it will connect to the first available pod.
For information about resolved issues, see Direct Access gateway version history.
For information about how to upgrade, see The upgrade procedure.
Now Qlik Cloud customers can address common, centrally managed, tabular report distribution requirements. Report developers can create custom, highly formatted, XLS documents from Qlik data and Qlik visualizations. Governed Report Tasks can burst reports to any stakeholder ensuring that the Qlik platform is the source for operational decisions, customer communications and more.
Tabular reporting with Qlik Cloud Analytics
The new Pivot table is here with a set of new features:
Dimension headers
Null value custom symbol, foreground and background color
Grid styling with width and color
Font styling for size, color and family for headers and cell contents
Totals styling and placement options: above or below
Column width options, set to auto, in pixels or with percentage
Scrollbars outside chart
Interactive sort of dimensions
All of the above are designed and added based on feedback from our users. The new Pivot table is launched in the Visualization bundle and will replace native pivot next year when additional features are added.
The Grid chart, Funnel chart, and the Sankey chart have been upgraded with the new property panel for styling. The styling includes general settings for title, subtitle, footnote, background, border and shadow and chart specific settings for axis and value labels.
Grid chart (Visualization bundle)
The Filter pane now gets more properties for styling: General settings for title font styling, background, border and shadow. Chart specific styling for header and content font styling, color settings for selection state, background color and image.
The Layout container is a new component in the Dashboard bundle. In the Layout container, charts can be placed in a freeform manner with or without a snapping grid. Charts can overlap, be stacked, and controlled with show conditions. The Layout container is highly versatile but especially useful for:
Grouping charts together
Combining charts into new visualizations
Creating composite KPIs
Grouping and reusing user controls and buttons
Creating aesthetic pleasing dashboards
To get the most out the layout container, follow best practices, check out Bruno Calver's talk at Techspert Visualization Day on Qlik Community.
As of today, most charts receive settings for borders and shadows. Charts inherit the border setting from the theme but the border width and color setting can now be overridden and customized per chart. The border can play a big role in how your dashboard is perceived, use it wisely to achieve your goals.
Chart shadow is a new property on charts, providing a shadow contour around the chart, with options for size and color. Shadows create a depth effect and can be used to highlight and make certain elements stand out.
Borders and shadows works very well in the Layout container where charts can overlap and be stacked.
We’re continuing to expand the connectivity of Qlik Talend Data Integration with a new group of connectors that just got released. These connectors will enable you to gather business data from more applications that focus on the supply chain, ERP, CRM, and finance:
Acumatica ERP
GitHub
QuickBooks
SAP Ariba
SAP Cloud for Customer
SAP Fieldglass
SAP SuccessFactors Payroll
Stripe
Zoho Books
Zoho CRM
Zoho Expense
Zoho Inventory
We also updated the existing Oracle OPERA connector to support change data capture.
Similar to our previous connector releases, these connectors are Generally Available (GA), covered by our standard support policies and are tagged as Preview. If you haven’t already done so, you will need to contact your local support representative to activate the feature flag that enables all of these connectors in your tenant. The preview tag and feature flag are there because these connectors do not cover all use cases and we want to make sure you have the best experience possible.
We have expanded the Export / Import project capability to support the new Replication projects. This adds the ability to move projects between different environments such as DTAP processes, as you could already do for Pipeline projects.
We have now added the ability to create Qlik scripts directly from the hub, using a new and improved script editor. Users can now build and deploy Qlik scripts upstream of analytics apps, which can be executed and result in output files in formats such as QVD and PARQUET. These files can be stored in the hub and used for analytics and AutoML applications.
The script editor also now includes a data preview feature, allowing users to get better insight when developing scripts. This provides our customers with an improved workflow for preparing data, while setting the stage for future enhancements to analytics data prep capabilities
Loading and transforming data with scripting: Using script editor
Customers are now able to set the access control for Qlik Cloud OAuth clients, whereas previously, all OAuth machine-to-machine clients were assigned the tenant administrator role. Customers can now regulate the permissions of OAuth clients by enhancing security around any sensitive data and restricting the permissible capabilities and actions of end-users.
If you have an existing OAuth client, it will have the user_default and admin_classic scopes assigned to maintain backward compatibility. You may choose to update the OAuth client to have the scopes you want tokens to possess if you want them to be more restrictive.
Scopes set for existing OAuth clients
For new OAuth clients, you will need to select the scopes tokens will possess so they perform only the actions you want them to.
Select scopes for new OAuth clients
When users access applications with a Qlik Cloud OAuth client for the first time, they will need to grant the OAuth application permission to access the data the scopes allow. The scopes set for the OAuth client will appear in a consent screen users can accept.
Qlik Talend Data Integration users can now seamlessly bring in data landed by Stitch into Qlik data projects and utilize Qlik data transformation services on this data. New UI options allow Qlik users to choose settings such as the watermark column and soft deletions when registering incremental data ingested by Stitch. These settings tweak the generated SQL based on the choices selected and optimize transformation processing time and cost.
Qlik has achieved the following certifications:
State Risk and Authorization Management Program (StateRAMP) Moderate Authorized status.
Texas Risk and Authorization Management Program (TX-RAMP) Level 2 Authorization.
United States International Traffic in Arms Regulations (ITAR)
Qlik Cloud Government supports compliance with ITAR, allowing qualified companies to use Qlik Cloud Government to transmit, process and store protected articles and data subject to US Export Control and ITAR restrictions.
For more information about Qlik Cloud Government, see:
With the new Qlik app for Microsoft Teams, you can easily chat with Insight Advisor, Qlik's intelligent AI assistant, to explore data using natural language directly within Microsoft Teams. Insight Advisor Chat
You can now ask questions through individual or group chat and Qlik will respond with AI-generated data visualizations and insights, using data from across your Qlik apps. And because it's Microsoft Teams, you can collaborate with others in real-time, collectively making decisions using the insights generated by Qlik. Insight Advisor within Microsoft Teams provides a powerful new way to help more people find the right answers, make better decisions and collaborate together where and how they work.
Look for the Qlik app in the Teams App Store to get started.
Exploring app content with conversational analytics in Microsoft Teams
Accessing Insight Advisor Chat through Microsoft Teams
Quickly and easily select and connect to a menu of foundational LLMs hosted by BedRock, Amazon’s fully managed service that supports foundation models.
With this capability, users can take advantage of the rich content offered by generative AI in a variety of ways, such as:
augmenting analytics with natural language insights
synthesizing and combining third-party data into existing data models
allowing users to ask questions in real-time using data from Qlik
The following Amazon Bedrock connectors have been added:
AI21 Labs
Amazon Titan
Anthropic
Cohere
Monitor views now provides more granular views into tasks. You now have the ability to filter tasks within a data pipeline, based on impact analysis or pipeline lineage.
Lineage filtering: allows you to select a task and automatically include any related upstream tasks. For example you could select a Data Mart task and see all the upstream tasks that impact the health of that data mart.
Impact filtering: allows you to select a task and see all downstream tasks in the Monitor View. For example, you could select an SAP Landing task and see all other tasks impacted by the SAP landing task.
These filters can be saved as part of a Monitor view definition. Within these filtered views, it is possible to do further filtering by errors as an example, to analyze how a task error impacts upstream or downstream data pipeline components.
Last week, we launched the ability to replicate data directly from supported data sources to an on-premises or cloud-based SQL Server.
This release extends that capability by introducing support for three new targets:
Setting up connectivity to MySQL target
The Qlik Cloud Monitoring apps are a set of community supported Qlik Sense apps which give customers insights into their tenants. Two new automation templates now automate the process of installing and maintaining these apps, helping you stay up to date and on top of the App Analyzer, Entitlement Analyzer, Reload Analyzer, and Access Evaluator.
Where customers embed Qlik Analytics for their end users, they can now assign a new embedded user role to restrict those users from accessing any Qlik Cloud interface other than the analytics app. This helps to further secure customer deployments in embedded scenarios.
A new flexible text object is now available via the Dashboard bundle. You can now style text with advanced settings, add measures, and also insert tables.
The new Chat Completion block in the OpenAI connector in Qlik Application Automation brings support for OpenAI's powerful GPT models which you can now use to run prompts against. You can use this block when distributing email reports to generate custom messages that are tailored to the recipient and certain KPIs from the app that are shown in the report.
The Amazon Bedrock connector in Qlik Application Automation enables your automation to interact with any of the text and image models from Bedrock and send the model's output to any other automation connector or use it as input for another Bedrock model. You can for example use the text models to process support incidents from tools like ServiceNow or Salesforce and generate tailored responses which you can then surface to your support team by writing them back to the respective support tool or sending them directly to your support team over Slack or Microsoft Teams.
A private connection can be used to ensure your data traffic remains secure and compliant. It simplifies both network management and security of your VPC (Virtual Private Cloud) without the need to open inbound firewalls ports, proxy devices or routing tables. Qlik Cloud Data Integration already supports private connections to Snowflake, Microsoft SQL Server and Amazon S3 data pipeline targets. With this release, customers can additionally utilize private connections when moving data to Databricks, Microsoft Azure Synapse, Google BigQuery, and Amazon Redshift.
We take a cloud-first approach that enables rapid innovation and adoption. However, that does not mean that we are cloud-only. As part of our continued commitment to improving the long-term value for our customers, we are pleased to announce the release of a new use case for Replication when creating data projects. The new Replication use case is in addition to the existing ability to create data pipelines for all your data integration needs, such as Data Warehouse modernization.
The Replication project supports real-time data replication from supported data sources to a supported target.
Starting with this latest release, the first target that supports replicating data in real time, is Microsoft SQL Server. In addition to supporting Microsoft SQL Server on-premises, the following cloud providers are also supported:
Replication projects also provide support for landing data in a data lake with the addition of a new "Land data in data lake" task. The process of landing data delivers a full load to the data lake from your selected data source, while automatically delivering change data as new data in files in the lake.
Lake Landing supports delivery from any supported data sources (whether RDBMS or SaaS applications) to the data lake as either CSV, JSON or PARQUET formatted files.
Starting with this release, the first target that supports Lake Landing in real time, is Amazon S3, with more cloud object stores to follow.
This is the first of many target endpoints to support replication, stay tuned for further announcements, coming soon.
With this latest release, Qlik Cloud Catalog now automatically provides dataset and field lineage within the context of a Data Integration pipeline, bringing more transparency and enhancing trust in data-driven outcomes for data and analytic users. Additionally, impact analysis on the data pipeline artifacts facilitates proactive exploration of what-if scenarios, allowing for a comprehensive assessment of how changes in the source system may impact downstream data pipelines and transformations. This proactive approach aids in the prevention of potential issues before they have a chance to arise.
Working with lineage and impact analysis in Data Integration
The following improvements require Qlik Data Gateway - Data Movement 2023.5.10 or later. For information about how to upgrade, see Upgrading the Data Movement gateway installation.
Expanded Support for Private Connections
A private connection can be used to ensure your data traffic remains secure and compliant. It simplifies both network management and security of your VPC (Virtual Private Cloud) without the need to open inbound firewalls ports, proxy devices or routing tables. Qlik Cloud Data Integration already supports private connections to Snowflake, Microsoft SQL Server and Amazon S3 data pipeline targets. With this release, customers can additionally utilize private connections when moving data to Databricks, Microsoft Azure Synapse, Google BigQuery, and Amazon Redshift.
PostgreSQL-based data sources
All PostgreSQL-based data sources - Multirange data type support: The following multirange data types are now supported with all PostgreSQL-based data sources (on-premises and cloud).
Microsoft Azure SQL (MS-CDC) data source: Geo-replication support
Customers moving data from a Microsoft Azure SQL (MS-CDC) data source can now use a Geo Replica database.
Oracle data source: HSM (Hardware Security Module) support
Qlik Cloud Data Integration now supports reading data from Oracle encrypted tablespaces and encrypted columns during CDC.
New regions support
Qlik Cloud Data Integration now supports tenants in DE and UK regions.
Newly supported versions and third-party software
This section lists newly supported database and driver versions.
Newly supported data source versions. The following data source versions are now supported:
Newly supported target data platform versions. The following data target versions are now supported:
Driver versions. The following ODBC driver versions are now supported:
Microsoft SQL Server driver - Required upgrade
Customers moving data to or from Microsoft SQL Server need to upgrade their SQL Server ODBC driver version to 18.x or later. Note that continuing to use SQL Server ODBC Driver 17.x might result in data errors. Upgrading the driver can be done using either the driver installation utility or manually. For instructions, see Driver setup.
End-of-support database versions
This section provides information about end-of-support database versions.
End-of-support data source versions. Support for the following data source versions has been discontinued:
End-of-support target data platform versions. Support for the following data target versions has been discontinued:
There is now an updated version of the Qlik Cloud migration tools. In addition, three use cases have been added for importing Qlik Sense Client-Managed apps to Qlik Cloud.
Customers with Qlik Cloud and Talend Cloud tenants can now switch between tenants with ease by enabling a link that will be accessible through the launcher menu for all users in the tenant. Watch the video and find instructions here on how to configure your tenants today.
Linking Qlik Cloud and Talend Cloud
The Qlik Reporting connector in Qlik Application Automation has been expanded to allow for the composition of reports that include charts via the Add Chart to Report and Add Chart to Multi App Report blocks. This allows report developers to achieve compositions that include both charts and sheets.
Tenant admins can now seamlessly monitor automations and across all users of a tenant, all within the intuitive Management Console. Now with advanced filtering, tenant admins can easily get an overview of all automations running at a given moment in time, view scheduled automations, or get a list of all failed automation runs in any given time period.
Your tenant level admin can now:
Enable/Disable Automation
Delete Automation
Change Automation Owner
Keep things organized with efficient sorting options:
In the Automations tab, sort by "Automation name," "Last run status," "Last run," "Created," or "Last update."
In the Runs tab, sort by "Automation name," "Run status," and now, "Duration."
And for precise control, utilize our filtering options:
On the Automations tab, filter by "Automation name," "Last run status," "Run mode," or the new "Owner" field.
Over on the Runs tab, filter by "Automation name," "Last run status," "Start time," the new "Owner" field, and even "Automation ID(s)."
The filter pane now has a setting to opt out confirmation, which is especially nice if in grid mode and the filter pane act as a button bar.
Customer Managed Keys (CMK), has now the ability to support more customers by:
Converting a tenant with existing data from Qlik Internal KMS to AWS KMS
Converting a tenant with existing data from AWS KMS to Qlik Internal KMS
Converting a tenant with existing data from AWS KMS to another AWS KMS Key (key rotation)
Public CMK APIs that allow for lifecycle management of provider entries within Qlik Cloud
These enhancements are complemented by:
Qlik Application Automation connector for AWS KMS
Key blocks added to Qlik Application Automation connector for Qlik Cloud and Platform Operations allowing management of AWS KMS Encryption Keys
For more information, see Tenant encryption
The new straight table extension now have a much wanted feature: multi-page PDF output, the ability to download more than the just the current view of the table. You can now download up to 50 pages.
Adapting to ever-changing industry regulations, shifting business needs, and advancements in technology, necessitate regular updates to the organization's business glossary.
Continuously keeping the glossary up to date enables the organization to align its terminology and definitions with the latest industry standards, maintain compliance, and optimize its processes effectively.
Typically, the manual import and export of these values can be repetitive and time-consuming, often involving manually copying data between different systems, which is not only tedious but also prone to human errors.
Qlik Application Automation has introduced new connectors that can automatically handle updates for Qlik Cloud Business Glossary, making it easier and more efficient to manage data vocabulary across the organization.
Direct Access gateway 1.5.3 resolves the following issues:
Microsoft SQL Server (via Direct Access gateway) connector: When attempting to establish a connection to a SQL Server hosted on older Windows Server versions, the connection would fail due to a TLS compatibility issue and the following error would be returned:
Please check the values for Username‚ Password‚ Host and other properties. Description: Client unable to establish connection - ERROR [08001] [Qlik][SqlServer] Problem establishing connection to the server.
The SQL Server driver has been updated to correct the problem.
SAP SQL (via Direct Access gateway) connector: When attempting to preview a table, the following error would sometimes occur:
Exception of Type System.OutOfMemoryException
SAP SQL (via Direct Access gateway) connector: Attempting to preview a table would sometimes time out after a few minutes with the following error:
Request could not be completed.
For upgrade instructions, see Upgrading the Direct Access gateway installation.
You could already import glossary terms and descriptions from external glossaries into the Qlik Cloud Business Glossary.
The import capability is now enhanced so you can synchronize these imports and keep track of any changes.
You can now read about how Qlik handles deletion of Qlik Cloud tenants when trials, evaluations, or paid subscriptions expire.
The Natural Language Insights object has been updated to offer better functionality, improved insights, and native support for all Qlik Cloud features.
In addition to manually configuring the context with dimensions and measures, you can now directly select a desired chart and insights will automatically reflect it, providing an easy way to add readouts and interpretations for a visualization.
The object now fully supports the Qlik Cloud UI in multiple languages, accessibility requirements, and reporting / exporting, and has been moved to the standard charts pane.
With Natural Language Insights, you can boost data literacy by helping users better understand the most important takeaways from their visualizations and analytics, driving better decisions at all levels.
The handling of fonts has been improved. You now a get a preview of the font in the drop down. Open-source fonts are bundled, so that fonts are rendered the same everywhere: on screen, in printing and in image downloads.
Old dashboards will still look the same, new fonts are only engaged if the app developer is actively going in and changing. You can use your own fonts, make a custom theme and include your font.
Centralized monitoring views provide users the ability to define, save and share filters for operational views to support monitoring data tasks.
It supports monitoring data pipelines across projects by providing Monitoring as a top-level capability in the Data Integration home.
You can now export a data project to a file that contains everything required to reconstruct the data project. The exported JSON file can be imported on the same tenant, or on another tenant. You can use this, for example, to move data projects from one tenant to another, or to make backup copies of data projects.
Exporting and importing data projects
You can now manually reload selected tables from the source in landing data tasks. This is useful when you want to recover single tables with error.
Qlik Cloud Government now supports the following Qlik Application Automation connectors:
API Key
Databricks
Qlik AutoML
Qlik Application Automation connectors
Operators can now recover suspended or failed loads at a table level within the Landing area of the pipeline, with any follow-on tasks reacting automatically to bring the whole pipeline back into sync.
More granular control is available to select one or more specific tables to be reloaded, without having to do a full reload of all the tables, bringing greater efficiencies in error handling.
Continuing our commitment to improving pipeline performance with automation, when a reload occurs, Storage will automatically run a compare job for you to ensure history is tracked.
Qlik Data Gateway - Direct Access 1.5.2 provides support for the new ODBC (via Direct Access gateway) connector as well as improving overall stability and performance.
New features and enhancements:
Provides support for the new ODBC (via Direct Access gateway) connector.
Resolved issues:
For upgrade instructions, see Upgrading the Direct Access gateway installation.
With the introduction of the ODBC (via Direct Access gateway) connector, customers can now access ODBC data stores from within their Qlik apps, using standard ODBC drivers. As well as providing greater flexibility, the ability to use standard ODBC drivers is especially useful for customers who need to access data stores that are currently not part of Qlik's extensive offering of built-in connectors.
Like existing connectors, this new connector empowers organizations with hybrid data landscapes to securely access, query, and analyze data residing both in the cloud and on local servers.
As we expand the breadth and depth of our Insight Advisor AI-assistant capabilities, we now offer auto-generated expressions in the expression editor driven by natural language processing. Users seeking to create analytics expressions, including complex set analysis, can simply describe what they want to calculate and Insight Advisor will generate the expression to use. This powerful capability delivers on the promise of AI, making the complex simple and allowing more people to expand their data literacy.
The new line object gives users the ability to draw simple lines on sheets to add more customization and detail to sheets. The line object can be used to separate or group content within a sheet and to create bespoke dashboards. It also includes several customization capabilities, including the ability to adjust the design, width and color of the lines.
The OpenAI embeddings connector allows customers to use OpenAI to convert text into a set of numeric values (knows as an embedding) for a variety of use cases such as search, similarity scores, etc. The connector allows Qlik customers to generate this data directly through Qlik Sense.
Customers can now perform complex calculations on their data tables in the Qlik load script to perform aggregation on different partitions without losing the granularity of their data.
This functionality is commonly used in SQL and with many ML data preparation use cases.
Connector Factory launches more Qlik Cloud Data Integration connectors with an emphasis on health information technology and digital advertising applications:
Cerner Millennium
Epic on FHIR
Facebook Ads
Facebook Pages
Google Ads
Instagram Ads
Oracle OPERA
Salesforce Pardot
SAP Commerce Cloud
UKG Pro
Zendesk
Similar to last month’s release, these new connectors are Generally Available (GA) and covered by our standard support policies but are tagged as Preview because many initially cover a specific use case. Once these capabilities are expanded to cover multiple use cases, the Preview label will be removed.
These connectors are available to all Qlik Talend Data Integration customers upon request, to ensure that Qlik can work with you to maximize the experience using these connectors. To access application connections, contact your Qlik Customer Success Manager or Qlik Support.
Connecting to SaaS applications
Customers can connect to OpenAI directly through Azure, to more easily take advantage of generative AI.
We now offer feature engineering for date fields in Qlik AutoML, building on existing automated capabilities around data ingestion and preparation. Date feature engineering automatically breaks down date fields into a series of usable elements, such as year, month, day, etc. that can be easily factored into ML models for analysis.
We are pleased to introduce public collections, which let Tenant and Analytics admins create collations of content from one or more spaces for their users. These collections provide a simple, yet powerful way to group content into more logical buckets for your end users, which is especially valuable when content that's regularly used by specific business teams or roles are spread across multiple spaces.
As public collections respect spaces access control, users will automatically see collections if they have access to at least one piece of content in that collection via space membership. They will only see content in the collection that they have permission to see. Content can be added to one or many collections.
Enable incremental pipelines for complex, custom SQL in support of near real-time analytics and data engineering use cases. Custom SQL supports a broad set of use cases and persona's from analytics engineers to data engineers. Macros provide the ability to customize initial and incremental load jobs to support a variety of use cases including:
Filter support to define a filter and reduce data processed during incremental load jobs
Adjusting joins or column mappings for initial v incremental loads
Union legacy data into an initial load process for the purpose of migrations
To provide finer granularity we have made additional log types available and introduced a log viewer, so you can now view and download log files related to Data Movement gateway processes. In most cases you should not need to view these log files; however, should you encounter an issue that you are unable to resolve on your own, Qlik Support will advise what logs to provide in order to resolve the root cause.
For more information, please visit Troubleshooting Data Movement gateway.
New blocks have been added to the Stitch connector in Qlik Application Automation:
Start a replication job
Obtain logs from a replication job
Getting started with the Stitch connector in Qlik Application Automation
A new, simplified, and flexible Pricing and Packaging model is being introduced for Qlik Cloud, now including Analytics. Our Capacity model has Data and Users at the core for the three editions: Standard, Premium and Enterprise. For more information on our tiers, visit our new pricing page on Qlik.com: Qlik Pricing
Customers can pick an edition based on how much data they have and how much they are planning to bring into Qlik Cloud. Customers subscribing to one of these editions will have the option to monitor their entitlements and corresponding usage through the Data Capacity Reporting App. For more details, view the video Data Capacity Detailed Application - Brief Demonstration.
The unit of measure for Qlik Cloud capacity and limits is represented by GB (gigabytes) in the user interface, documentation, and product description. Each GB (in binary) represents a GiB (1,073,741,824 bytes).
Qlik Cloud Government now supports the following Qlik Application Automation connectors:
AWS KMS
PagerDuty
OpenAI
SugarCRM
Qlik Application Automation connectors
Dedicated Capacity and Expanded Apps have been replaced with Large Apps. Large Apps make it easier to scale your system and improve your spaces configurations. This can simplify how your organization works with larger data sets and apps. For more information, see Large app support.
We’ve added a new script function that makes it easier to leverage variables for enhanced monitoring across apps and tenants without the need to manually enter Tenant IDs, Tenant Names, or the URLs into the script.
For the programmatic deployments, the spaceId and spaceName are also important.
The new script and expression function:
Dual GetSysAttr(VariableName)
Variables accessible in this scope:
tenantId
tenantName
tenantUrl
tenantUrlAlias
tenantRegion
spaceId
spaceName
spaceType
GetSysAttr - script and chart function
The following improvements and bug fixes require Qlik Data Gateway - Data Movement 2022.11.74 or later. For information about how to upgrade, see Upgrading the Data Movement gateway installation.
Replication support
We take a cloud-first approach that enables rapid innovation and adoption. However, that does not mean that we are cloud-only. As part of our continued commitment to improving the long-term value for our customers, we are pleased to announce the release of a new use case for Replication when creating data projects. The new Replication use case is in addition to the existing ability to create data pipelines for all your data integration needs, such as Data Warehouse modernization.
The Replication project supports real-time data replication from supported data sources to a supported target.
Starting with this latest release, the first target that supports replicating data in real time, is Microsoft SQL Server. In addition to supporting Microsoft SQL Server on-premises, the following cloud providers are also supported:
Microsoft Azure Synapse Analytics target - Required driver upgrade
Customers moving data to Microsoft Azure Synapse Analytics need to upgrade their SQL Server ODBC driver version to 18.x or later. Note that continuing to use SQL Server ODBC Driver 17.x might result in data errors. Upgrading the driver can be done using either the driver installation utility or manually. For instructions, see Driver setup.
New "Load data from source" option for SaaS application sources
A new Load data from source option was introduced, which allows customers to read their data directly from the source during Full Load, instead of using the cached data.
For more information on this option including use cases, see Landing settings.
Updated CA certificates
Data Movement gateway 2022.11.74 includes updated CA certificates, which are needed for authenticating the Qlik Cloud tenant. The updated CA certificates also provide support for the Ireland and Frankfurt regions. Therefore, customers with Qlik Cloud tenants in Ireland or Frankfurt who want to use Qlik Cloud Data Integration must upgrade to this version.
Resolved issue
Tasks landing data from an Oracle source would sometimes fail when a wide table contained unused or unsupported columns, or LOB columns that were not replicated.
Qlik Talend Data Integration users can share the same target schema in the destination, as long as they use unique prefixes for tables generated by those tasks.
Qlik Cloud now supports an AWS Key Management Service (AWS KMS) connector to help you manage the lifecycle of cryptographic keys that are used to protect the data in your tenant.
The following blocks are included in the connector:
New blocks have been added to the Qlik Cloud connector to support the automation of CMK encryption key lifecycle tasks using Qlik Cloud management APIs.
The following blocks have been added to the connector:
New blocks have been added to the Qlik Platform Operations connector to support the automation of CMK encryption key lifecycle tasks using Qlik Cloud management APIs.
The following blocks have been added to the connector:
For more information, see Qlik Platform Operations connector overview on the Qlik Cloud Developer site.
Customers can connect to OpenAI directly through Azure, to more easily take advantage of generative AI.
New line chart options have been added, allowing application developers to enable toggling across different dimensions or measures within the same chart. The ability to add a simple toggle switch using the show condition expression gives developers more control, improves customization, and saves space. Users will appreciate significant time savings with the ability to toggle across the variables associated with their line chart data.
Showing or hiding dimensions and measures depending on a condition
Showing or hiding dimensions and measures depending on a condition
Qlik Cloud Government now supports the following Qlik Application Automation connectors:
Snowflake
UIPath
Qlik Application Automation connectors
The Qlik Cloud Analyticsconnector for Twitter was deprecated after Twitter changed the structure for the available API access levels and removed the broader access to analytics via Twitter API v1.1. Twitter API v2 is now required, which is not supported in the current connector for Twitter. A new connector for Twitter is intended to be released later this year.
For more details, see Qlik Analytics connectors: Twitter connector to be updated in the Qlik Support Community.
Qlik Talend Data Integration introduces more than 20 new connectors that gather full and incremental data from some of the most-used and popular SaaS applications.
As there are an ever-growing number of cloud application sources, Qlik is creating these and any future SaaS application connectors using standard APIs and generative AI technology to streamline the development process while still adhering to Qlik’s data integrity, security, and reliability guidelines.
These new connectors are Generally Available (GA) and covered by our standard support policies but are tagged as Preview because many initially cover a specific use case. Once these capabilities are expanded to cover multiple use cases, the Preview label will be removed.
These connectors are available to all Qlik Talend Data Integration customers upon request, to ensure that Qlik can work with you to maximize the experience using these connectors. To access application connections, contact your Qlik Customer Success Manager or Qlik Support.
This release includes the following new Qlik Talend Data Integration connectors:
Adobe Analytics
Adobe Marketo Engage
Coupa
Google Analytics 4
Jira
Microsoft Dynamic 365 CRM
Microsoft Azure Active Directory
Oracle Netsuite
Pendo
Percipio Reporting Services
Qualtrics
Salesforce
SAP Concur
ServiceNow
Shopify
SuccessFactors
Sugar CRM
SurveyMonkey
WorkDay
Zuora
Connecting to SaaS applications
Walkthrough: Cloud Application Sources - Qlik Cloud Data Integration
SaaS in 60 - New Cloud Application Sources in Qlik Cloud Data Integration
Webhooks are available now to set conditions when reloads fail. Simplify troubleshooting and awareness of failed reloads by sending alerts, reports, and more!
More styling options are now available for the KPI Object, which include Name and Value labels. Adding flexibility and customization, options include font family, color, and style (bold, underline, italicize).
Essential for usability of the new Nebula-based straight table, you can now take snapshots, download as an image, download as a PDF, monitor in the hub, and subscribe.
The Qlik Cloud documentation has been updated with new content detailing how to style text, customize the background, and adjust other properties in visualizations. Content has been added for all visualizations supporting newly added customization options. For more information, see:
To provide finer granularity we have made additional log types available and introduced a log viewer, so you can now view and download log files related to Data Movement gateway processes. In most cases you should not need to view these log files; however, should you encounter an issue that you are unable to resolve on your own, Qlik Support will advise what logs to provide in order to resolve the root cause.
For more information, please visit Troubleshooting Data Movement gateway.
Microsoft SQL Server 2012 and earlier are not supported by Microsoft (see SQL Server lifecycle dates). If you’re unsure which SQL Server version you’re using, use one of the methods described in Determine which version and edition of SQL Server Database Engine is running.
The Qlik Cloud Analytics connector for Microsoft SQL Server officially supports versions 2014 through 2022. However, it has continued to work with older versions. But this will soon change.
Qlik Cloud Analytics is performing a required security update in August 2023, resulting in no access to Microsoft SQL Server 2012 or earlier. To continue using the Qlik Cloud Analytics connector for Microsoft SQL Server, ensure that your environment is on a supported Microsoft SQL Server version.
It’s recommended that you continuously upgrade to the latest version, currently Microsoft SQL Server 2022 (16.x). For reference and details, review the Microsoft documentation on how to upgrade SQL Server.
Outdated, out of support versions of Microsoft SQL Server and Qlik Cloud Analytics
Qlik Data Gateway - Direct Access 1.4.2 improves overall stability and performance by resolving several issues.
Changing the ODBC_LOG_LEVEL value in the C:\ProgramData\Qlik\Gateway\configuration.properties file would have no effect.
Reload would fail with the following error if an active Direct Access gateway connection was not used for several minutes:
Connector error: Invalid load request (DirectAccess-1006)
The issue was resolved by not timing out if the session is still alive.
Loading tables with numerous columns from MySQL and PostgreSQL would sometimes fail with the following error:
System.InvalidOperationException: Failed to HPACK encode the headers
When users did not have privileges on a Managed Space containing the Direct Access gateway, the following unclear error would be shown:
Requested endpoint could not be provisioned due to failure to acquire a load slot: Object reference not set to an instance of an object.
The error message was improved with a more accurate description of the issue.
Multiple reload attempts would sometimes fail due to excessive memory consumption.
To benefit from the improved stability and performance, customers are encouraged to upgrade at the earliest opportunity. For information about how to upgrade, see Upgrading the Direct Access gateway installation.
The following new blocks are now available for Talend Cloud connector in Qlik Application Automation:
Execute plan
Get plan configuration
Get plan tasks
List available plans
List available plans for lookup
List datasets by tags for lookup
List tables and views by connection
List task execution logs
List task executions
Pause plan execution
Resume plan execution
Stop schedule for a plan
For more information about the Talend Cloud connector, see Getting started with the Talend Cloud connector in Qlik Application Automation.
It is becoming increasing popular for organizations to isolate their data platforms from the Internet with a private connection. As these data platforms are not exposed to the Internet, they cannot be directly accessed from Qlik Cloud. There are several types of private connection, examples of which include:
With the introduction of private connection support, organizations can safely and seamlessly execute Qlik Cloud Data Integration ELT operations (including transformations and data marts) on data platforms inside protected deployments such as a VPC.
Customers can now land data from any supported source to either an on-premises or cloud-based (Amazon RDS, Google Cloud, Microsoft Azure) deployment of SQL Server. The landed data can then be leveraged to perform ELT operations further down the data pipeline, such as transformations and data mart creation. The new SQL Server target can be accessed either directly from Qlik Cloud or via Data Movement gateway if it is not exposed to the Internet (for example, if it is in a VPC).
Qlik has added some key capabilities to the business glossary within Qlik Cloud:
Associate term with master measures and dimensions: Users can already define which apps and datasets are related to a particular term in the business glossary. Qlik has now expanded this relationship capability to master Items. When creating a new master measure or dimension, the user can now also define which terms relate to the master item.
Pop-up term definition: If a chart uses a master item that has a defined associated business term, the user can see the term’s definition by simply hovering their mouse over the master item label.
Glossary links within lineage summary view: The lineage summary is an optional view, available with most chart types, that gives users an explanation of where the data came from within that chart. A link to any glossary terms referenced by masters items used within the chart has been added to this view.
Dedicated Capacity and Expanded Apps have been replaced with Large Apps. Large Apps make it easier to scale your system and improve your spaces configurations. This can simplify how your organization works with larger data sets and apps. For more information, see Large app support.
We’ve added a new script function that makes it easier to leverage variables for enhanced monitoring across apps and tenants without the need to manually enter Tenant IDs, Tenant Names, or the URLs into the script.
For the programmatic deployments, the spaceId and spaceName are also important.
The new script and expression function:
Dual GetSysAttr(VariableName)
Variables accessible in this scope:
tenantId
tenantName
tenantUrl
tenantUrlAlias
tenantRegion
spaceId
spaceName
spaceType
Introducing the “Automation Creator” role for Qlik Cloud, granting select users CRUD privileges for Automations in Qlik Cloud. This new role was designed to provide organizations with enhanced control and oversight over automation processes. This role empowers designated users with CRUD access to automations while ensuring a structured governance framework. By incorporating expanded governance controls, this new role helps organizations maintain accountability, compliance, and security within their automation practices. The ‘Automation Creator’ role will be enabled by default in a new tenant by being automatically assigned to the ‘Everyone’ group. Tenant admins can disable the role by removing the role from the ‘Everyone Group.’
The Qlik Cloud help is integrating glossary entries into topics to help users better understand Qlik terminology. The first instance of a glossary term in a topic links to a pop-up window with the definition and relevant topics.
The Qlik Cloud Migration Center on the Qlik helpsite now provides tools to monitor, manage, and execute a migration from QlikView to Qlik Cloud Analytics.
The Migration Center provides high-level guidance, along with sequencing, strategy, and best practices. You can freely utilize the new scripts and planning worksheets to execute your migration.
Qlik Data Gateway - Data Movement 2022.11.70 enhances the driver installation utility and improves overall security, stability and performance by resolving several issues.
This version adds support for performing ELT operations on target data platforms located in a private network (such as a VPC) that cannot be directly accessed from Qlik Cloud. Currently, supported is limited to SQL Server and Snowflake targets.
In previous versions, customers needed to run the "source arep_login.sh" command when installing SAP clients. From this version, it is no longer necessary to run this command.
When a replication task on Data Movement gateway failed and recovered automatically, the recovered state would not be communicated to the Landing data asset in Qlik Cloud.
To benefit from the improved stability and performance, customers are encouraged to upgrade at the earliest opportunity. For information about how to upgrade, see Upgrading the Data Movement gateway installation.
Qlik Cloud Government now supports the following connectors for Qlik Application Automation:
Stitch
Talend Cloud
Qlik Application Automation connectors
As part of our continuous improvement commitment in Qlik Talend Data Integration, we are pleased to announce support for a new data source expanding the many different sources you can extract your valuable data from.
You can now use the PostgreSQL connector to move real-time data, with change data capture (CDC), from a Google Cloud SQL for a PostgreSQL data source to any supported target.
This feature requires Data Movement gateway 2022.11.42 or later.
For more information, please visit PostgreSQL.
Qlik Data Gateway - Direct Access 1.4.1 improves overall stability and performance by introducing a health check enhancement and resolving several issues.
Direct Access gateway checks its health periodically. Starting from this version, the health check will restart the Direct Access gateway service if it is unresponsive for five minutes.
When starting a reload with a query that returns metadata immediately but only returns the first data chunk several minutes later, the following error would sometimes occur:
Connector error: data loading error (DirectAccess-4008)
In certain scenarios, Direct Access gateway would not reconnect to Qlik Cloud when a reload was interrupted.
In rare situations, the following error would be encountered during reloads:
No connection could be made because the target machine actively refused it.
When connecting to SQL Server, special characters in passwords would not be encoded correctly, resulting in the following error:
Command test connection returned non-success: Error message: Please check the values for Username‚ Password‚ Host and other properties. Description: Access credentials are not valid for this connection.
The ODBC connector would sometimes crash when aborting load activity from the user interface while the query was returning data.
In rare scenarios related to heavy loads, reloads would sometimes fail with the following error:
Connector error: Unknown reason:. Index was outside the bounds of the array. (DirectAccess-1500)
To benefit from the improved stability and performance, customers are encouraged to upgrade at the earliest opportunity. For information about how to upgrade, see Upgrading the Direct Access gateway installation.
The OpenAI Analytics Connector enables real-time access to generative content within Qlik Sense apps. Users can securely integrate powerful natural language insights directly from OpenAI into analytics apps, synthesize and combine third-party data into existing data models, directly ask questions of ChatGPT augmented with data from Qlik, and much more. The Qlik analytics engine sends subsets of data to OpenAI in real time for insights and answers in context as users make selections.
The new OpenAI Connector for Application Automation helps developers enhance their existing workflows with AI and large language model-generated content when creating expressions, commands, or scripts. Developers can leverage OpenAI to help quickly and efficiently create and deliver additional value to use cases such as sentiment analysis for CRM applications and customer service teams, translating reviews, or product material.
Qlik Application Automation connectors
App developers have new styling options for legends, providing greater flexibility and customization. Legend styling is available for line, bar, pie, mekko, and waterfall charts, plus scatterplot and distribution plot. Options for legend styling include font family, size, and color for title and labels.
A new search engine enhances the user experience with better performance, which equates to faster search response times. This improvement will be particularly noticeable for customers with large deployments and a high number of users.
The Mail connector allows you to send automation output to an email server.
Qlik Application Automation connectors
This Application Automation release adds many new connectors.
Talend Cloud: Orchestrate Talend tasks around data integration, data quality, and more with the new Talend Connector in Application Automation. Leverage automations in Qlik Cloud to streamline data pipelines and data governance needs across your organization.
SugarCRM: Streamline sales operations with the new SugarCRM connector for Application Automation now available in Qlik Cloud. The connector enables users to integrate sales ops, marketing, and account management seamlessly into their Qlik Cloud analytics environment to improve efficiency and collaboration.
PagerDuty: Manage IT monitoring, incidents, and observability with the new PagerDuty connector for Application Automation. Unite PagerDuty’s enterprise prowess of operations reporting with Qlik Cloud Analytics and Automations to support IT groups and data operations.
SaaS in 60: Notes Permissions, Button Text, New Connectors and More!
Qlik Application Automation connectors
The Qlik Platform Operations is a Qlik-native connector that can orchestrate one or many Qlik Cloud tenants using either tenant or subscription OAuth clients. Use this connector to deploy and manage tenants in Qlik Cloud without code. Connector blocks have been added or updated for many APIs. For details about the changes, see the Qlik Cloud Developer Changelog.
Qlik Cloud now offers more control and sharing options for Collaborative Notes users. To accelerate adoption and usage, Qlik now allows for control of granular access and no longer permits the ability to return a note from public state to shared state. Notes users now have the control they need to share insights as desired without risk of unapproved changes. This update will encourage, expand and accelerate notes usage across the enterprise.
New app styling settings in App options allow you to turn the toolbar and sheet header on or off for all sheets. Turning the toolbar and/or sheet header off provides more space for content and allows you to customize selections for titles and the navigation bar.
New bar chart options have been added, allowing app developers to enable toggling across different dimensions or measures within the same chart. The ability to add a simple toggle switch using the show condition expression gives developers more control, improves customization, and saves space. Users will appreciate significant time savings with the ability to toggle across the variables associated with their bar chart data.
Showing or hiding dimensions and measures depending on a condition
Users with the co-developer role can now edit the business logic for apps they do not own located in shared spaces. This expands our collaborative development capabilities allowing more people to customize the behavior of Insight Advisor.
The new styling panel for the treemap extends your ability to customize the look and feel to organization, department, or personal style standards and preferences. It includes font size, color, and family options for titles, subtitles, and footnotes. You can also choose background image and color.
As of June 1, 2023, Qlik Forts is end of life and the product has been removed from Qlik Cloud. Visit the Qlik website to learn more about Qlik Cloud.
Animations can now be turned on for the following chart types:
Bullet charts
Line charts
Chart animations are the gradual transitions in a visualization from the old view to the new view when data has been changed, for example, after a selection has been made. Animations can be turned on or off under app settings.
You can now connect to several new databases using Direct Query:
Azure SQL
Azure Synapse Analytics
Microsoft SQL Server
PostgreSQL
Direct Query allows analytics applications to directly query cloud databases with SQL pushdown as users interact with data through visualizations and filtering. App developers can use Direct Query to build SQL-centric applications for big-data analysis or near real-time scenarios.
In storage data tasks for registered data the update method Incremental using high watermark has been added. You can now process data changes incrementally using the high watermark method. A watermark column with an incrementing value is used to detect changes in the data.
App developers can now style button objects. You can change fonts, labels, and layout.
Amazon Simple Notification Service (SNS) is a web service that coordinates and manages the delivery of messages to subscribing endpoints or clients. This connector only has webhooks available.
Qlik Application Automation connectors
How to: Getting started with the Amazon SNS connector in Qlik Application Automation
Qlik Data Gateway - Direct Access 1.3.1 is prone to excessive CPU utilization in certain scenarios. Version 1.3.2 resolves this issue and contains no other changes. To prevent CPU-related failures, we encourage all customers to upgrade to version 1.3.2 immediately.
For information about how to upgrade, see Upgrading the Direct Access gateway installation.
You can now use a proxy server to connect to a cloud data warehouse and storage area, when landing data through Data Movement gateway.
This requires you to enable the relevant landing settings and configure Data Movement gateway to use a proxy server.
Tenant administrators can now assign security roles to all users in the tenant from the Auto assign column on the Permissions tab in the Management Console. This makes it easy to share content with everyone in a tenant. It also provides a way to provide everyone with roles to control access to Qlik Cloud capabilities.
For Qlik Cloud Analytics subscriptions: Assigning security roles to everyone in the tenant
For Qlik Talend Data Integration subscriptions: Assigning security roles to everyone in the tenant
The profile service needs to compute statistics and generate a schema for large files. If the file is too large to process in full, the profile server should return a schema and a partial number of rows. We will limit the profile of a data file by the number of rows in the file, instead of the size of the file in bytes. The max number of rows profiled will be 12 million. If the maximum is exceeded, the first 12 million will be profiled.
In the Visualization bundle, the new straight table significantly boosts self-service capabilities with chart exploration. It acts as a catch-all table, providing app consumers with the flexibility to pick and choose how they would like their table presented.
App creators can add many fields simultaneously, customize the table at the column-level, add alternative dimensions and measures, set column width, apply pagination, and turn on chart exploration.
Chart exploration allows users that do not have edit rights to customize the original straight table when they are in analysis mode. These users can add or remove columns, change sort order, re-arrange columns, and make selections. They can then share, download, subscribe to, or bookmark the new table layout. The changes made in chart exploration mode by a user are not seen by other users working in the same sheet. It is very helpful in apps that have many viewers with different needs.
Straight table (Visualization bundle)
SaaS in 60 - New Straight Table Chart Object
Chart exploration in a straight table in analysis mode.
The new Qlik Google Analytics 4 connector extracts traffic and engagement metrics from your Google Analytics 4-enabled websites and apps. Google Analytics 4 is a more flexible measuring tool that Google Universal Analytics, and can collect event-based data from many different websites and apps.
The previous QlikGoogle Analytics connector will continue to be supported until Google retires their old analytics service later in 2023.
When importing a cloud data warehouse data project, you can now replace the source schema for landing tasks, and the source database and schema for registered data.
Qlik Data Gateway - Direct Access version 1.3.1 includes the CA bundle for Qlik Cloud Government and resolves several issues.
The CA bundle authenticates the identity of the Qlik Cloud tenant, thereby ensuring a trusted connection.
In previous Direct Access gateway versions, the CA bundle file for Qlik Cloud Government customers was provided by Qlik as needed. From this version, the CA bundle file is included in the installation.
In a default setup, the CA bundle file is installed to the following location: C:\Program Files\Qlik\ConnectorAgent\caBundle]qcg_ca_bundle.pem
For more information, see Installing Qlik Data Gateway - Direct Access.
The Direct Access gateway agent would sometimes crash with the following error:
Unable to write data to the transport connection: An established connection was aborted by the software in your host machine
For information about the upgrade procedure, see Upgrading the Direct Access data gateway installation.
Qlik Cloud Government supports the ServiceNow connector. ServiceNow is a cloud-based workflow automation platform.
Qlik Application Automation connectors
Auto-generated SHAP importance ranking charts are now available during training of multiclass classification models, making SHAP importance visualizations available for all three model types in Qlik AutoML (for supported algorithms). The chart is displayed below the Model metrics table. Multiclass SHAP charts are uniquely interactive, and by default, display the total of all SHAP values for each feature. Other options are available, including class-specific feature SHAP and single-class SHAP charts.
SHAP importance chart for a multiclass classification model (Feature SHAP by class option)
A new button has been added to ML Model Management for faster access to the ML experiment from which an ML deployment was created. You can now navigate directly to the ML experiment by clicking View ML experiment in the bottom left corner of the page.
You can now temporarily stop the delivery of all of your Push, Email, and Email digest notifications. Click Pause notifications in the top right corner of the Profile settings page. Web notifications will still be sent during this time.
These notifications will be paused until you resume them by clicking Resume notifications. When you resume notifications, you will not receive notifications that you would have received while your notifications were paused.
Data Movement gateway 2022.11.42 introduces significant changes including a new driver installation utility and support for new data source versions.
This version introduces a driver installation utility that eliminates the need to manually install and configure drivers. The new utility shortens the installation process while significantly reducing the possibility of user error. When the utility is run, the required driver is downloaded automatically, if possible, and installed. If the driver cannot be downloaded (DB2 drivers require login, for example), all you need to do is download the driver, copy it to a dedicated folder on the Data Movement gateway machine, and run the utility.
For an example of using the driver installation utility to install a PostgreSQL driver, see Prerequisites
The Snowflake connector now supports 4-byte emoji characters.
The PostgreSQL connector can now move data from Azure Database for PostgreSQL - Flexible Server.
The PostgreSQL connector can now move data from Cloud SQL for PostgreSQL.
This version introduces support for the following new data source versions:
Databricks 11.3 LTS
The following data source versions are no longer supported:
This version resolves the following issues:
To benefit from the new features and newly supported database versions, upgrade to Data Movement gateway 2022.11.42.
To verify your current version, go to Administration > Data gateways and check the Version column corresponding to your Data Movement gateway.
App developers can now co-develop app load scripts with other members of a shared space. By default, only the app owner can use Data manager and Data load editor to add data to an app, build the data model, and load data into their app. The new Can edit data in apps user role allows other users in the shared space to use Data load editor and Data manager in apps they do not own.
When one user is editing the load script in Data load editor, the script is locked for other users. Changes made by all users are automatically saved as different versions in History.
Qlik Cloud Government app consumers can now execute Qlik Application Automations using button objects in sheets. Previously, only the automation owner could use a button object to run it. App consumers can include selections made in the app in the automation.
Automation owners can control whether any user can activate a button or only those with access to the automation.
Tutorial - Active intelligence
Creating a basic write-back solution with Qlik Cloud
Qlik Cloud Government supports the following Microsoft connectors for Qlik Application Automation:
Microsoft Excel
Microsoft OneDrive
Microsoft Outlook 365
Microsoft SharePoint
Microsoft Teams
In addition to being compatible with Microsoft Office 365 Commercial, these connectors are now compatible with Microsoft Office Government Community Cloud (GCC). Support for these connectors in GCC High is not available.
Qlik Application Automation connectors
When profiling data in Profile tile view, the Most common values frequency card now shows the five most common values and their frequency. If there are more values than five distinct values, these are combined and displayed as Other. Previously, this card would only show three values.
App developers can now customize the fonts, line thickness, and background colors in line charts. New options in the General tab provides options to change the styling of titles, sub-titles, and footnotes. You can also add a custom background color or image. Any image in the media library can be used as a background. You can choose a single background color or color by expression.
Axis labels, data point size, and line size can be customized under the Chart tab.
App developers now have new ways to customize the appearance and functionality of filter panes. The listbox for each field or master dimension in a filter pane can be customized individually with multiple new properties. The following options are available:
Hide the displayed title of the field.
Remove search functionality for the field, or switch to Wildcard mode (inserts * characters around string).
Compact view for optimizing space between values.
Checkbox mode for alternative selection method.
Histogram view to display the frequency of each value in the data.
Grid layout with custom ordering and display options.
Apache Parquet is a columnar storage format, highly efficient for storing and querying large datasets. In Qlik Sense, you can read data from Parquet files, and store tables as Parquet files. Using Parquet allows for efficient querying of specific columns in a table rather than reading the entire table. This makes it well-suited for use with big data processing. Also, Parquet supports efficient compression and encoding of data which can further reduce storage space and improve query performance.
App consumers can now execute automations using button objects in sheets. Previously, only the automation owner could use a button object to run it. App consumers can include selections made in the app in the automation.
Automation owners can control whether any user can activate a button or only those with access to the automation.
Tutorial - Active intelligence
Creating a basic write-back solution with Qlik Cloud
App developers can now style the font used for axis labels, axis titles, and value labels in the following charts:
Font, font size, and color can be customized under the Chart tab.
App developers can now add a custom background color or image to mekko charts. Any image in the media library can be used as a background. You can choose a single background color or color by expression.
App developers now have more fine-grain control over app reload schedules. For example, you can set the timezone for the reload, create an annual reload schedule, and automatically stop reloads after a certain date.
Qlik Cloud Government now supports the following Microsoft connectors for Qlik Application Automation:
Microsoft Excel
Microsoft OneDrive
Microsoft Outlook 365
Microsoft SharePoint
Microsoft Teams
These connectors are compatible with Office 365 Commercial. Support for Microsoft connectors in Government Community Cloud (GCC) and GCC High is not currently available.
Qlik Application Automation connectors
Qlik Cloud Government reporting capabilities now support Microsoft PowerPoint output for report compositions.
PowerPoint reporting capabilities
Qlik Cloud Government administrators can now monitor capacity consumption in the new Home pane in the Management Console. This gives you an overview of the consumption of users, reports, and other capacity-based resources. You can also see the capabilities that are enabled with your subscription.
Monitoring resource consumption
QlikApplication Automation has added new templates and connectors. Three existing connectors have been updated.
Export an app to a shared space as a backup: This template is set up to export a Qlik Sense app from the source space to the target space. Note that both the source and target space defined must be a shared space since copying an app from/to a managed space is not allowed. You can modify this automation to alert team members about the status of the app export to the target space.
How to export Qlik Sense Apps from source to a target shared space using Qlik Application Automation
Basic Authentication connector: Basic Authentication is a connector meant for advanced users to connect to platforms that do not have a specialized Qlik connector. The connector uses a basic authentication flow that requires only a username and password. It has RAW API blocks that support all methods as well as pagination.
How to get started with the Basic Authentication connector
Amazon SNS connector: Users can now register webhooks listening to events occurring in AWS and trigger the start of automations. This connector is limited to webhooks as a start event and can only listen to object creation events on S3. Use cases include listening to new S3 events and reloading a Qlik Sense app or triggering a data pipeline.
API KEY connector: New endpoints allow for cursor URL-based paging and cursor token-based paging.
OAuth2 connector: New endpoints allow for cursor URL, cursor token, page number, and offset-based paging.
As a tenant admin, I would like to be able to track my tenant's usage of DI, understand what I am being charged for.
Monitoring resource consumption
The Resource Center replaces the Connect & Learn menu and is now available from almost anywhere in Qlik Cloud except Qlik Sense apps. In addition, it has been moved to the top bar, making it easier to find and use. From the Resource Center, Qlik Cloud users and administrators can access in-product announcements, onboarding resources, in-product help, videos, survey and feedback options, and industry walkthrough options. They also have access to Qlik Notifications for activities such as scheduled maintenance.
This change provides a more centralized experience, providing the best resources to help you get the most from Qlik Cloud.
Opening the Resource Center
Getting started and learning options
A new role called Data Services Contributor has been added for use within Qlik Talend Data Integration. Previously, all Professional users could create and modify data movement and transformation workflows. Now, administrators can choose which Professional users can perform these Data Integration functions by assigning them this role. All current users with a Professional entitlement will be assigned this role. By default, new Professional users are also assigned this role.
If you remove this role from users with a Professional entitlement, then they will no longer have access to the Data Integration interface from the Launcher menu. This can simplify their user experience.
You can now prepare datasets and adjust design changes with a single command, Prepare. This includes the functions that were previously performed with Sync datasets.
You can now easily monitor and operate data tasks grouped within a data project. Perform the same operations that are available for a data task as data project operations.
Turn schedules on and off
Perform design operations
Start and stop execution of data tasks
Delete data tasks
You can manage a data space in Data Integration home by selecting the space in the filter at the top of Data projects or Data connections, and then clicking Space details.
To make any changes in a space you must be one of the following:
Tenant admin
Data admin
Owner of the data space
Member of the data space with the Can manage role
Qlik Platform Operations Connector is a Qlik-native connector for QlikApplication Automation that makes it easy to manage one or many tenants in Qlik Cloud. It uses tenant or subscription-level OAuth and allows you to build automations that automate deployments from one source tenant to one or many target tenants. This is useful for enterprises with development, test, production environments and multi-region requirements, and for OEMs and embedded customers who provide analytics to their end customers via Qlik Cloud.
Qlik Application Automation connectors
Tenant and analytics admins can now add images to the links they add to the hub. Previously, links had a generic image that could not be changed.
Time series decomposition has been added as an analysis type and modifier. The STL (seasonal and trend decomposition using Loess) algorithm has been available in Qlik Sense for some time, but now it is easier to break down time series data for specific analysis using the chart functions. Access the functionality via Insight Advisor Analysis Types or by adding Time series decomposition as a modifier on an existing time-based aggregation.
The Management Console has a new navigation panel on the left, designed to mirror the design of the hub. The Manage members option of a space now redirects to the space members view within the same browser tab; instead of opening a new tab. The Generate new button for API Keys also redirects within the same browser tab.
Management Console left-side panel
Qlik Sense Mobile SaaS now includes the following improvements:
Standardized and improved home search:
Pre-populates with recently updated apps.
Loads more results.
Fully selectable charts and apps.
Redesigned look & feel with more consistent truncation of results.
Persistent search option.
Mobile Collection view in mobile search
Text and image object:
Improved rendering, performance, and memory consumption.
Interact directly with text & image objects using gestures.
Straight tables:
Added support for SVG images.
Improved scrolling and layout.
Improved row expansion.
Improved accessibility and overall presentation.
These capabilities demonstrate our ongoing investment in bringing next-in-class mobile capabilities to you – delivering the unique power of our associative engine to drive insight at the point of decision.
Exploring analytics with Qlik Sense Mobile SaaS
SaaS in 60 - Qlik Sense Mobile Improvements and Capacity Consumption Monitoring
Qlik Application Automation is a no-code visual interface that lets Qlik Cloud users build automated analytics and data workflows by integrating applications and services from outside of your Qlik environment. Qlik Cloud Government supports a subset of the currently available Qlik Application Automationconnectors.
The CreateSearchIndexOnReload variable for the Data load editor determines whether search index files are created when an app’s data is reloaded.
Previously when this variable was set to 1, search index files were created when an app’s data was reloaded.
To help improve system performance, setting CreateSearchIndexOnReload to 1 additionally results in search index files being created if:
The app has been searched recently (determined by the number of days that have passed since the last search was performed on the app).
The app's data is relatively large (determined by the duration of the most recent index creation).
When setting up a prediction configuration from an ML deployment in Qlik AutoML, you can now generate dynamic prediction dataset names with time-specific variables. This is available for both manually-run and scheduled predictions. It is particularly useful when scheduling multiple prediction jobs from the same ML deployment, and helps differentiate each dataset that you are generating based on when the prediction job was run.
You can now connect to Amazon Redshift databases using Direct Query. Direct Query allows analytics applications to directly query cloud databases with SQL pushdown as users interact with data through visualizations and filtering. App developers can use Direct Query to build SQL-centric applications for big-data analysis or near real-time scenarios.
A new security role gives administrators more granular control in their Qlik Cloud tenant. Users with the Private Analytics Content Creator role can create analytics content in personal spaces, such as apps and data connections. Users without this role can still create monitored charts, alerts, subscriptions, and notes in their personal space.
This means that administrators can choose to separate the ability to collaborate in published apps from the ability to create independent apps in personal spaces.
You can now leverage data ingested into your cloud data platform by a third-party solution, such as Qlik Talend Data Integration, in your Qlik Talend Data Integration pipelines. Use the Register data menu, select the appropriate tables, and your pipeline is third-party data-aware. You can use this data without migrating your existing Qlik Talend Data Integration tasks or infrastructure to the cloud.
App developers and consumers can now apply chart monitoring to the following visualizations:
combo chart
histogram
scatter plot
waterfall
These interactive charts have been added to enhance the data visualization experience, giving even more insight into your data.
Qlik Cloud Government introduces several features that significantly enhance the platform’s capabilities.
Qlik Talend Data Integration is now supported by Qlik Cloud Government. It is a set of data integration capabilities designed to help analytics and data engineers deliver, transform, and unify enterprise data via automated, efficient, and governed data pipelines. Although the Qlik Talend Data Integration interface and tooling is available in Qlik Cloud Government, it is not functional without a license except for the ability to create data pipelines.
Qlik Cloud Government now supports Direct Query. This Qlik Cloud Analytics tool can read SQL databases without importing or loading the data in memory. Direct Query gives the user more options on how they want to access their data to suit their needs. In addition, accessing the data through Direct Query allows the user to keep the data in its underlying data source. This increases the speed at which users can interact with their data in exchange for the flexibility that an in-memory Qlik Cloud app offers.
Accessing cloud databases directly with Direct Query
Qlik Data Gateway - Direct Access is now available for Qlik Cloud Government. This tool can be used by Qlik Cloud Analytics app users to securely access data behind a firewall over a strictly outbound, encrypted, and mutually authenticated connection. Qlik Cloud Government supports using Qlik Data Gateway - Direct Access when the Windows platform where it is installed is configured to run in a FIPS 140-2 approved mode of operation.
Qlik Data Gateway - Direct Access prerequisites and limitations
Qlik Data Gateway - Direct Access overview
Administrators can now monitor capacity consumption in the new Home pane in the Management Console. This gives you an overview of the consumption of users, reports, and other capacity-based resources. You can also see the capabilities that are enabled with your subscription.
Monitoring resource consumption
The handling of user entitlements has been moved from the User allocation pane to the Users pane in the Management Console. The user entitlement is now a field associated with the user. This improves the handling of users as all administration is done in one place and you can sort and filter by status or roles. It is no longer possible to sort by entitlement type.
The model filtering mechanism in the Model metrics table has been re-designed and improved. Dropdown filters have now replaced many toggle switch filters, enabling the selection of specific algorithms and model versions. Additionally, the More model filters dropdown gives you access to the same functionality as before, allowing you to filter your results for top-performing, currently selected, and deployed models. When combining filters, the model metrics that match any of the filters applied will be shown.
The model view with metrics table and chart visualizations lets you review model performance
The Azure SQL database and Azure Synapse Analytics connectors now support two new authentication methods:
Azure OAuth: Allows single sign-on (SSO) when using an identity provider.
Azure Active Directory: Protects user identity and simplifies the sign-in experience.
Administrators can now enforce user-defined credentials when creating Google BigQuery and MongoDB connections. Users accessing this connection must input their credentials before selecting tables or loading data. These credentials belong to a user, not the entire connection. User-defined credentials can be saved and used in multiple connections of the same connector type. This option already existed in other ODBC connectors.
SCIM (System for Cross-Identity Management) is an open standard for automating the exchange of user identity information between identity providers and enterprise applications.
Qlik Cloud now supports SCIM, which can:
Simplify user management
Improve security
Ensure that user information is consistent across all systems, reducing the likelihood of errors or discrepancies
Improve the user experience by making it easier for users to access the resources they need by providing a consistent experience across different systems.
Qlik Cloud supports SCIM connectors that work with Microsoft Azure Active Directory (Azure AD) and is compatible with SCIM 2.0
Provisioning users and groups using SCIM
The Databricks MLflow analytics source has been updated to include compatibility with machine-learning models created using Databricks MLflow 2.0. When configuring a connection, you now have the option toto specify Databricks MLflow 1.0 or 2.0.
Creating a Databricks MLflow connection
You can now customize the file formatting of certain dataset types directly in Qlik Cloud Analytics. Previously, you would have to edit and re-upload the data source to change the formatting. With files that have multiple sheets, there can be different format settings per sheet.
When you upload new data files, you are warned if there are any anomalies. For example, if all column headings begin with @, instead of the header title. The following format types can be customized: CSV, HTML, XLS, XLSX, XLW, XLSM, FIX.
Support for GeoAnalytics extensions ended in March 2023.
This release enhances pipeline run-time behavior to support more advanced task scheduling options to provide more dependency control, execution flexibility, and performance optimization.
Initially, a data pipeline was composed of independently scheduled tasks that ran at regular minute or hourly intervals based on project defaults that the user could override. However, new options provide regular interval scheduling such as minutes, hourly, daily, weekly, monthly, or particular dates and times. You also have the option to schedule a task based on a specific event, such successfully completing a prior task.
Scheduling dialog in Qlik Talend Data Integration
For more information, see:
The new summary view lets you quickly view and edit your data connections. The new connections summary view can be reached by clicking on the Data connections menu on the Data Integration home.
Data connections view in Qlik Talend Data Integration
The new pipeline view uses a widget to control the level of detail shown on the canvas. You can show or hide status, data freshness, and schedule information for all data tasks.
Pipeline view in Qlik Talend Data Integration
SFTP (SSH File Transfer Protocol) is a secure file transfer protocol that runs over the SSH protocol and can help enterprises meet HIPAA, GDPR, and other regulatory rulings for file transfer compliance. Use the SFTP connector to download files from or upload them to secure FTP locations. Like other Qlik Cloud Analytics file-related connectors (SharePoint, Google Drive, Dropbox), users can also use this SFTP connector to browse and drill into any folder the user can access on the SFTP server.
Qlik Lineage Connectors automatically pull together graphical data flows from multiple sources. This feature empowers users to uncover more lineage-related insights by accessing multiple Client-Managed BI tools and data sources to find and document those assets. The result is that Impact Analysis can show the data lineage of your Qlik Sense SaaS apps, along with the data lineage of Qlik Sense Enterprise Client-Managed apps, and even Tableau and PowerBI apps.
Qlik Lineage Connectors
The Microsoft Power BI Services lineage connector now supports GCC (Government Community Cloud) and GCC High environments. Edit your Power BI Authentication URIs to access these cloud environments.
A business glossary provides data and analytic users with a single, easily-accessible repository of business terms and descriptions to ensure that everyone is using the same definitions across your organization. A shared understanding of terminology is essential for data discovery and collaboration across departments.
The Qlik Cloud Business Glossary provides a robust set of capabilities beyond simply defining terms and their meaning. Users can categorize terms logically by business context, define relationships between terms, and ensure that only approved terms are used. The glossary can also be directly linked to apps and datasets so that data consumers can easily view a term’s definition within their current UI.
Business glossaries can be imported and exported from one Qlik Cloud environment to another. In addition, Qlik Cloud supports the import of Atlan and Apache Atlas glossary formats.
Business Glossary in hierarchy view
Working with business glossaries
Business glossary video playlist
Product Innovation blog - Eliminate Data Misunderstandings with a Business Glossary
Automations can now be easily monitored and updated in a centralized overview page. Quickly search, edit, activate, and export your automations.
The metrics view provides an informational snapshot of your automations and runs. The history view allows you to easily see automation run history, status, and duration. New filters support debugging and troubleshooting.
Automations overview section
SaaS in 60 - Application Automation Monitoring and Management
App developers can now control the number of visible points and lines displayed in line charts. The maximum for visible points is 50,000. The maximum for visible lines is 1,000. These options are available for line charts with a continuous dimension axis.
A line chart with a large data set. This chart is set to display a maximum of 50 lines and 20,000 data points.
Set a background color or a background image to a visualization
App developers can now style the font used for titles, subtitles, and footnotes in scatter plots and text & image objects, giving them more options for customizing their visualizations. A new General tab provides options to change the font type, size, color, and emphasis.
App developers can now add a custom background color or image to straight tables, pivot charts, pie charts, and bar charts. Any image in the media library can be used as a background. You can choose a single background color or color by expression.
You can now use Amazon Redshift as a cloud data platform in Qlik Cloud Data Integration. Cloud data platforms facilitate data delivery and push-down transformations.
Using Amazon Redshift as a data platform
Qlik Data Gateway - Direct Access 1.2.0 now supports SAP SQL and SAP BW connectors, providing an encrypted connection to Qlik Cloud. This lets Analytics apps securely access and analyze SAP SQL and SAP BW data that resides behind your organization's firewall, without compromising network security. To benefit from SAP support, upgrade to Qlik Data Gateway - Direct Access 1.2.0 today.
Upgrading the Direct Access data gateway installation
Five new reload events have been added to app reload notifications. Previously, users would be notified when reloads:
Succeed
Fail
Exceeded_limit
Now you will also be notified when:
Fail: An engine connection error prevents a reload.
Fail: An issue with session fetching causes a reload to fail.
Fail: Engine openDoc issue leads to a reload failure.
Fail: Reload fails due to permission issues.
Notifications will no longer be sent when apps are reloaded in the Data load editor and Data manager. This removes unnecessary notifications when app developers work on their apps.
The new chart functions ObjectId() and InObject() enable creation of guided applications with custom navigation functionality. For example, you can use the functions in conditional expressions to create colored buttons to navigate between sheets in an app.
The functions give access to the hierarchy of objects in a Qlik Sense app. ObjectId() will return the ID of the object in which the expression is evaluated. The function takes one optional string parameter, which can specify the type of the object you're looking for. ObjectId('sheet') will return the ID for the sheet of the expression. InObject(ID) is true when evaluated inside an object with the specified ID.
This template will generate a report based on an app, including all public sheets with no selections applied. Each generated report will then be saved as a PowerPoint file in Microsoft SharePoint. You can modify this automation by selecting a different destination connector for the cloud storage in the "Copy File" block.
You can also choose to only include a selection of sheets by setting Sheets mode to Custom in the "Create Report" block and adding an "Add Sheet To Report" block (under Qlik Reporting).
The Qlik AutoML tutorial has been updated with guides for creating ML deployments, predictions, and prediction apps. The tutorial now teaches how to work with the output generated from an AutoML prediction, including building a data model and creating charts to visualize SHAP and prediction data.
Tutorial – Using Qlik AutoML to create a prediction app
A tutorial has been added to walk you through the process of performing time series decomposition in Qlik Sense. The time series decomposition chart functions STL_Trend, STL_Seasonal, and STL_Residual make it easy to separate seasonal patterns from general trend data. This tutorial shows you how to use them in chart expressions.
App developers can use script variables to describe and manipulate the internal structure of a Direct Query app. For example, DirectQueryRowFetchMaxCount specifies the maximum number of rows that will be fetched per chart from the remote database.
The Manage space button in Catalog has been renamed Space details.
AutoML has added support for two algorithms: CatBoost and LightGBM. An algorithm is a mathematical recipe that produces a model. CatBoost and LightGBM can be used for binary and multiclass classification problems, and for regression problems.
App developers can now style the font used for axis labels and axis titles in bar charts. Font, font size, and color can be customized under the Chart tab.
A new version of Qlik Data Gateway - Direct Access (1.2.0) is available for download.
Securely access SAP data behind firewalls:
Version 1.2.0 introduces support for SAP SQL and SAP BW connectors, providing an encrypted connection to Qlik Cloud. This lets Analytics apps securely access and analyze SAP SQL and SAP BW data that resides behind your organization's firewall, without compromising network security.
Resolved issues:
Version 1.0.0 of Qlik Data Gateway - Direct Access is no longer supported while support for version 1.1.0 will end on February 15, 2023. If your organization is using any of the aforementioned versions, your system administrator is encouraged to upgrade immediately to the latest version.
You can determine the installed Qlik Data Gateway - Direct Access version from the Apps & features page in Windows Settings on the computer where it is installed.
Qlik Data Gateway - Direct Access version
Upgrading the Direct Access data gateway installation
App developers can now use Direct Query when creating a variable input control. This control is part of the Dashboard bundle. If you are creating visualizations with expressions that contain a variable, you can add a variable input control to let app consumers control the variable value.
Qlik Cloud Government now supports Customer Managed Keys. This feature allows you to bring your own encryption keys to Qlik Cloud, ensuring that your organization, and not Qlik, retains full control over the keys that encrypt at-rest data in the tenant.
The chart and sheet download preview dialog has been updated. Download data is now the first option. This reduces preview load times by removing unnecessary API calls. Previously, download as image was the first option, which meant app developers had to wait for a preview to load, even if they only wanted to download a data file.
App developers can now style the font used for titles and subtitles, giving them more options for customizing their visualizations. A new General tab provides options to change the font type, size, color, and emphasis. The Chart tab controls styling of scrollbars and custom headers.
These charts can now also have a custom background color or image applied to them. Any image in the media library can be used as a background. You can choose a single background color or color by expression.
Tenant Admins and Analytic Admins can now receive notifications at the global tenant level for apps that fail to reload. If you used notifications in the past, you will need to resubscribe.
When using Direct Query in a listbox, you can now type in search terms instead of scrolling down to find dimensions.
The Salesforce connector includes the following updates:
Support to provide any company-specific My Domain URL to the Salesforce instance.
Support for the Salesforce API up to version 56 (default).
Option to enter a different Salesforce API version in the connection dialog box.
Qlik Cloud reporting capabilities now support PowerPoint output for report compositions. Both subscriptions and Qlik Application Automation reports can be generated in PowerPoint. This means that reports can be edited after generation.
Sheets can now have custom background image and colors, so your PowerPoint reports will automatically have corporate styling applied. App developers now have more control over object placement and sheet grid size to support advanced formatting for presentations.
Tutorial - Designing sheets for PowerPoint reports
SaaS in 60: PowerPoint Output - Subscriptions and Report Service (Qlik Application Automation)
PowerPoint Output Format - Subscription and Report Service Walkthrough
The new history panel allows app developers to save and commit different versions of the load script. Selecting previous versions allows you to preview them and, if needed, restore an older version.
Databricks connections now support Unity Catalog, a unified governance solution for data and AI assets including files, tables, machine learning models. In Unity Catalog, administrators and data stewards manage users and their access to data centrally across all of the workspaces in an Azure Databricks account. Users in different workspaces can share access to the same data, depending on the privileges granted.
Insight Advisor can now perform time series forecasting with the new Trend with forecast analysis type. Business users and analysts often monitor their measures as a trend over time. With time series forecasting they can estimate how the historical sequence of observations will continue into the future. The ability to predict how trend lines are likely to evolve can inform strategy and decision-making.
Qlik Sense Mobile SaaS now includes the following improvements:
The mobile table object has better rendering and performance, while continuing to support mini-charts, images, totals, and search. New features include row counts, expand/transpose row, and the ability to copy cells.
Landscape mode sheet navigation has been updated, adding a quick and easy way for users to switch between sheets using native gestures.
Application chaining is now supported, allowing users to persist filters across multiple apps.
KPI objects look better in full-screen mode.
Warning messages have been standardized.
These capabilities demonstrate our ongoing investment in bringing next-in-class mobile capabilities to our customers – delivering the unique power of our associative engine to drive insight at the point of decision.
SaaS in 60 - Qlik Sense SaaS Mobile Improvements
Exploring analytics with Qlik Sense Mobile SaaS
GeoOperations now includes three analytic connections that contain all necessary functions to generate GeoOperations scripts, simplifying the creation of geospatial calculations.
This template performs an evaluation on a Qlik Sense app to determine if the app should be published or not. If the results from the evaluation indicate that the app does not contain any slow cached objects, the app will be published, and a notification email is sent. If the app does contain slow cached objects, it will not get published, and an email is sent out describing the error. You can modify this automation to validate other results from the evaluation or to send out alerts to another notification channel such as Microsoft Teams or Slack.
How to do an app evaluation in Qlik Application Automation
Notifications can be sent when an ML deployment is created, an experiment version is ready, a model has completed training, or a prediction is created.
Qlik Cloud has two new connectors: Amazon S3 Metadata V2 and Amazon S3 V2 Web storage provider. These connectors are more secure because they use the Amazon S3 API to access your Amazon S3 metadata, such as the names of files and subfolders in your Amazon S3 bucket. Previous versions of these connectors used the REST API. For now, the initial release of the Amazon S3 connectors V2 and the existing Amazon S3 connectors have the same capabilities. However, new capabilities will only be added to the V2 connectors going forward.
At some point in the future, the previous Amazon S3 connectors will no longer be supported.
The Management Console has been stream-lined and enhanced. Administrators can now see roles from groups in the Roles column. The User ID, IdP subject, and Invite expiry columns have been removed.
Administrators can see the invitation status by selecting Pending invites in the drop-down list, or by selecting Pending invites in the Status column. Hover over the invite to see the expiry date.
Chart animations are the gradual transitions in a visualization from the old view to the new view when data has been changed, for example, after a selection has been made. Animations can be turned on or off under app settings.
Animations can be controlled in the following chart types:
Bar charts
Pie charts
Scatter plots
Funnel charts (Visualization bundle)
Grid charts (Visualization bundle)
Sankey charts (Visualization bundle)
Qlik Sense Visualization Files (.qvf) files created in QlikView can now be manually uploaded into Qlik Cloud. Previously, only QlikView Worksheet (.qvw) files could be uploaded. Once uploaded, the .qvf resides in your personal space. You can then share it to shared spaces, and publish it to managed spaces for which you have “Can publish” permission. You can also export these files, with or without data, the same as a Qlik Cloud app.
For more information, visit the Migration Center: QlikView apps in Qlik Cloud.
Expanding Analytics Services multilingual capabilities, Insight Advisor Chat now supports natural language processing in the following languages:
Polish
Dutch
Swedish
The makeweekdate function can now use the FirstWeekDay, BrokenWeek, and ReferenceDay system variables.
This function also supports new parameters (first_week_day, broken_weeks, and reference_day) which can be used to override corresponding system variables.
Admins can now embed Qlik Cloud into their web portals and embedded applications using OAuth2 authorization, a web standard for portal integrations. Public clients and single-page application flows can mitigate issues with third-party cookies.
Machine-to-Machine (M2M) enabled OAuth clients are a powerful and secure way to manage and automate operations on a Qlik Cloud tenant. These clients require no user interaction and have a Tenant admin role, which gives administrators complete control over their tenants.
Some Qlik Cloud connectors now automatically refresh the authentication token before expiring. Previously, authentication had to be refreshed manually every 90 days when the token expired. This automatic token refresh capability occurs when these connectors are used at least once every 90 days. Any connections created before November 2022 must be manually refreshed once to trigger the automatic refresh capability. Connections that are not used within 90 days still need to be manually refreshed. The following connectors support automatic token refresh:
Web storage provider connectors:
Data connectors:
NL Insights is a new Dashboard bundle control that displays natural language insights about selected dimensions and measures. This allows app developers to effectively share insights about data with their app consumers. Insights includes analyses based on the data selected. App developers can remove unwanted analyses if needed.
You can now connect to Google BigQuery databases using Direct Query. Direct Query allows analytics applications to directly query cloud databases with SQL pushdown as users interact with data through visualizations and filtering. App developers can use Direct Query to build SQL-centric applications for big-data analysis or near real-time scenarios.
AutoML has new insights to help clarify what happens when the machine learning algorithms train on a dataset: the underrepresented class insight and the one-hot encoding insight. Underrepresented class insight is when a value in the column has less than ten instances (only in the binary case). A one-hot encoding insight is when a categorical feature has less than 14 unique values. If more than 100 columns are selected for an experiment then all the categorical features are impact encoded, regardless of how many unique values they have.
App developers can now style the font used for titles, subtitles, and footnotes in tables and pivot tables, giving them more options for customizing their visualizations. A new General tab provides options to change the font type, size, color, and emphasis. The Chart tab controls styling of rows, scrollbars, and custom headers.
Data Mart tasks can now incrementally process type 2 dimensions and preserve the change history of a slowly changing dimension. It works by storing and managing current and historical data values in the data warehouse over time. Incremental processing provides fully automated ELT instructions which are able to detect changes across multiple source tables as part of denormalization to reduce processing time, cost and improve accuracy. Additionally late arriving dimensions are also automatically handled by the data mart task.
Qlik has completed the SOC2 Type 2 + HITRUST attestation and can now help customers meet regulatory requirements under the US Health Insurance Portability and Accountability Act (HIPAA). Customers who are Covered Entities under HIPAA and use Customer Managed Keys can host Personal Health Information (PHI) that is subject to HIPAA regulations in Qlik Cloud. Customers must also sign a HIPAA Business Associate Agreement (BAA).
For more information, see:
Field profiling helps data analysts and business users gain insights faster. They can view and visualize valuable field profile metrics at-a-glance, without needing to create an app first. Field-level metadata lets users apply aliases, descriptions, and classifications to fields; these features assist with identifying specific data and sensitive fields. Editable metadata fields include Field Alias, Description, Tags, Classification.
You can now export a data project to a file that contains everything required to reconstruct the data project. The exported JSON file can be imported on the same tenant, or on another tenant. You can use this, for example, to move data projects from one tenant to another, or to make backup copies of data projects.
Users with the Audit Admin user role can access app usage metrics and user feedback. These metrics are accessed as events. This allows the Audit Admin to make improvements, either to the app itself or to its business logic, based on how users interact with Insight Advisor.
Qlik Cloud has updated the transports for the SAP connectors. This latest version, 8.0.2, must be downloaded and installed to ensure you have access to new SAP functionality dependent on changes in the connector SAP code. For more information, see SAP NetWeaver.
The admin debug process has been improved. Admins can now easily view the SQL statements that have been executed, along with any associated error messages, the rows impacted, and run times for Storage, Transformation, and Data Mart tasks.
A new version of Qlik Data Gateway - Direct Access is available for download. This new version (1.1.1) includes stability enhancements and introduces the following new features and improvements:
Added Windows Server 2022 support
The following issues have also been resolved in this update:
Resolved a potential stability issue related to choosing a custom path during setup
Version 1.0.0 of Qlik Data Gateway - Direct Access will not be supported after January 18, 2023. If your organization is using this version, your system administrator is encouraged to upgrade immediately to the latest version.
You can determine the installed Qlik Data Gateway - Direct Access version from the Apps & features page in Windows Settings on the computer where it is installed.
Qlik Data Gateway - Direct Access version
For information about how to upgrade, see Upgrading the Direct Access gateway installation.
This Application Automation release added two new connectors and three new templates.
Microsoft Outlook: Microsoft Outlook is an email client which includes features such as calendaring, task managing, contact managing, and note taking. The new Microsoft Outlook 365 connector allows users to link their email accounts and send emails. Emails can have attachments and be formatted using HTML.
Apache Kafka: Apache Kafka is an open-source event streaming platform for high-performance data pipelines, streaming analytics, data integration, and mission-critical applications. Apache Kafka provides message broker functionality similar to a message queue, where you can publish and subscribe to named data streams. The new Apache Kafka connector allows users to publish data sourced from any of the supported Application Automation connectors into Kafka topics and streams via a Confluent Rest Proxy.
Export audit trail logs from QEM to Splunk: This template enables you to incrementally export audit trail logs from Qlik Enterprise Manager to Splunk. The template integrates QlikData Integration with the market-leading enterprise application monitoring solution to improve production monitoring and root cause analysis. Additionally, users can change the template and export the audit trail data to other logging platforms.
Create a Slack channel when JIRA tickets update: This template automatically creates a channel in Slack every time there is a status change to a Jira ticket. The template creates a new Slack channel, invites the members, and sends a message to the channel along with the Jira ticket information. Channels are only created for tickets with status changes from New to Committed, New to In Progress, or New to Designing.
Create a channel in Slack for new Jira ticket with a status change
Split QVDs using an automation to improve reloads: This template improves the loading times of application reloads by splitting a large QVD file into several smaller ones.
Qlik Cloud Government now supports the following features:
Organizations with sensitive data require an additional layer of security. Customer Managed Keys allows you to bring your own encryption keys to Qlik Cloud. This ensures that your organization, and not Qlik, retains full control over the encryption keys that encrypt at-rest data in the tenant.
Dataset predictions can now be scheduled to run on a periodic basis. At each scheduled interval, AutoML reloads the apply data set, runs new predictions, and publishes the output files to the hub to be reloaded into analysis apps.
Landing data assets can be managed and transformed the same way as Storage, Transform, and Data mart data assets. You can create transformations, filter the data, and add columns.
The AYLIEN text analysis data source is no longer supported in Qlik Cloud. Instead, consider using AYLIEN News V2, which was introduced in June 2022.
Datasets and columns can now be renamed in bulk using dictionaries. This is useful when you are working with a large number of objects from a cryptic source, such as SAP. You can add translations in a dictionary editor or import a CSV file containing the translations.
App developers can add custom tooltips to KPIs. Previously, tooltips could not be added to objects without dimensions.
ODBC data sources have increased performance when working with larger datasets. All new connections automatically use the Bulk Reader feature.
Instead of loading data row by row, the Bulk Reader works with larger portions of data in the iterations within a load. This can result in faster load times for larger datasets. To activate this feature in existing connections, open the connection properties window by selecting Edit and then click Save. No other connection properties need to be changed.
If you create a bookmark in an app with variables, you can save the current variable state. This is helpful when retrieving a calculated value or using a bookmark to transfer states.
Users added to a space as part of a group can now co-author notes, and be mentioned in notes.
Multitenant provisioning provides Qlik OEM and ISV partners, and enterprise customers, with a deployment model that fits their deployment patterns with each end customer receiving their own tenant. Multitenant provisioning enables the acceleration of three tenant use cases: creating, configuring, and content hydration via API-supported automations. Using multiple tenants separates end customers, removing any potential data security issue and, importantly, allowing end customers to use all features in Qlik Cloud.
Beginning November 1, 2022, Qlik is enforcing rate limits to API requests on Qlik Cloud REST APIs. This means any API request originating to a REST API endpoint on Qlik Cloud is subject to rejection if the number of requests to an endpoint exceeds the allowed amount in a specified duration on that endpoint.
For more information, see:
Reports generated with Qlik Application Automation can now contain sheets from multiple apps.
App developers can now control the number of visible bubbles displayed in scatter plots. Scatter plots can be set to display up to 50,000 data points. If there are more than 5,000 visible bubbles, then bubble labels and out of bound bubbles are not shown.
Scatter plot
Qlik Talend Data Integration is a set of data integration capabilities designed to help analytics and data engineers deliver, transform, and unify enterprise data via automated, efficient, and governed data pipelines. The Qlik Cloud solution securely delivers enterprise data to the correct destination, in the proper format, in near real-time regardless of where the data originates. This ensures that your data is easy to find, manipulate, and govern.
This release allows the following:
Cloud data warehouse loading, ingestion, and data synchronization
Converting raw transaction records into analytics-ready data
Using fit-for-purpose data transformations in analytics data prep pipelines for AI and ML projects
For more information, see
As of October 18, 2022, the Hybrid Data Delivery product is no longer available. The data movement capability has been superseded by the new Qlik Talend Data Integration offering.
A new version of Qlik Data Gateway - Direct Access is available for download. This new version (1.1.0) includes stability enhancements and introduces the following new features and improvements:
Support for Oracle Wallets
Support for Google BigQuery
Improved error messages
The following issues have also been resolved in this update:
Improved system recoverability after driver crashes
Unexpected Data Gateway - Direct Access service stoppages
Version 1.0.0 of Qlik Data Gateway - Direct Access will not be supported after January 18, 2023. If your organization is using this version, your system administrator is encouraged to upgrade immediately to the latest version.
You can determine the installed Qlik Data Gateway - Direct Access version from the Apps & features page in Windows Settings on the computer where it is installed.
Qlik Data Gateway - Direct Access version
For information about how to upgrade, see Upgrading the Direct Access gateway installation.
PostgreSQL versions 9.4 through 14 are now supported in ODBC data sources.
Application Automation has added six new templates and updated two connectors with new blocks.
Two new alert templates let automation owners know when their automation has failed or has not run in the last X days. For more information, see the following community articles:
Two new version control templates let you export or import an automation to GitHub.
A new template reloads all tables in a Qlik Replicate task when an error occurs while processing a table. Reloading is often all that is required to correct a table error, allowing the Qlik Replicate task to continue.
Reload the table in a Qlik Replicate task when an error occurs when processing the table
A new template sends an email with a list of Qlik Replicate servers that have licenses which are about to expire. This provides early notification so administrators can take action before the license is out of date.
Alert Qlik Replicate server license expiration when within X days
Microsoft Teams connector: New blocks in this connector now makes it possible to send chat messages to specific users instead of a channel. Send chat messages to a new or existing chat when chat members need to take action on something.
How to send chat messages using the Microsoft Teams connector
Qlik Cloud Services connector: New blocks in this connector provide license information for tenant admins about their Qlik Cloud tenant. The blocks give tenant admins visibility to license assignments, consumption, and an overview of the license.
Getting started with the Qlik Cloud connector in Automations
Library colors are available when you create visualizations in standard edit mode. This includes the ability to switch on library colors as an option for coloring by dimension.
Direct Query now provides the ability for analytics applications to directly query cloud databases like Databricks with SQL pushdown as users interact with data through visualizations and filtering. Direct Query allows developers to build SQL-centric applications for big data analysis or near real-time scenarios and can be enabled when creating a Databricks data connection.
Qlik has achieved the Federal Risk and Authorization Management Program’s (FedRAMP) authorized designation at the Moderate Impact level and Department of Defense IL2. One of the first SaaS (Software as a Service) Analytics platforms to achieve FedRAMP designation, Qlik Cloud Government is now listed in the FedRAMP Marketplace under Authorized products.
FedRAMP is a government-wide program that provides a standardized approach to security assessment, authorization, and monitoring of cloud products and services for the U.S. public sector. FedRAMP enables the federal government by creating transparent standards and processes for security authorizations that help accelerate procurement and streamline adoption of cloud-based solutions.
Qlik Cloud Government provides valuable benefits to government agencies, including:
Artificial Intelligence (AI)-powered Analytics and Centralized Data Assets and Catalog
Security and compliance designed into the platform
No-touch maintenance and cost savings with Qlik Cloud
For more information about Qlik Cloud Government, see:
Expanding our multilingual capabilities, Insight Advisor Chat now supports natural language processing in the following languages:
German
Italian
Portuguese
Natural language insights in Insight Advisor Search are now available with more analysis types, depending on the combination of dimensions, measures, and fields used in the analysis.
For information about supported analysis types for natural language insights, see Limitations for natural language insights.
Styling for pie and donut charts has been added to the simplified authoring experience. Customize the width and outline of slices. Set the roundness of the corners of the slices. And set the inner radius of the donut.
Pie chart styling
In addition to uploading datasets in the hub, now you can upload a new dataset while creating an experiment or configuring a prediction. This creates a seamless workflow by automatically adding the dataset directly to Catalog and selecting it as the training dataset for the new experiment or the apply dataset for new predictions.
The following distribution functions from the Cephes library have been added, allowing you to perform more advanced statistical analysis of simulations.
These distribution functions can be used in both the data load script and in chart expressions.
Application developers can now connect applications together with a new button navigation option. When the target application shares fields and current values with the source, use the button to specify the app and sheet ID, and the selection will be applied to the target. Application chaining makes it easier to split functionality across applications for faster load time, accelerated response time, and simplified governance.
Four items have been renamed in the context menu to improve usability and consistency. Right-click an item in the hub to open the context menu.
New labels in the context menu
A new look to the Notifications pane improves usability with expandable sections to accommodate more notifications. The Space or content specific notifications section is renamed Exceptions, and How you receive notifications is now Delivery.
Notifications pane
Favorites is now independent from Collections in the Analytics hub. Now you can access your favorites with one click from the main navigation pane. To tag content as a favorite, select .
Favorites pane
Outer set expressions simplify governance of Qlik Sense applications. It is particularly helpful when working with complex master measures that come in different flavors of one base measure.
You can now use set expressions to tweak the base master measure, for example {<Year={2021}>} [Master Measure].
The Qlik AutoML connector loads data from the integrated Qlik AutoML platform into Qlik Cloud using an analytics connection.
This connector can apply your machine learning models (ML deployments) to data using an analytics connection. The connector sends data to specific predictive endpoints, returning predictions that can be loaded into Qlik Cloud.
Real-time predictions APIs, and therefore, the Qlik AutoML connector is not available for customers using the capacity that is included with a Qlik Sense Enterprise SaaS subscription.
You can now use the visual exploration menu to change the properties of time series forecasting in line charts. For personalized insights, without having to edit the chart, adjust properties, such as the number of forecast steps, step size and unit, and forecasting method, for both dimensions and measures.
Example of visual exploration when changing time series forecasting
Using the visual exploration menu to explore time series forecasting
A new Cancel button on the Reload history page lets you stop the app reload process, for example, if the reload is taking too long or you want to start a new reload.
Cancel a reload from the Reload history page
App developers can now style the font used for titles, subtitles, and footnotes in map charts, giving them more options for customizing their visualizations.
You also now have the option to customize font properties (family, size, and color) for labels in several types of map layers. This applies to point, area, chart, and line layers.
Map chart font styling
You can now receive notifications when you've been invited to engage with new content in a space. Set your notification preferences and delivery options for spaces in your Profile settings.
Notifications with spaces
A simplified cloud hub interface now makes it easier to customize your Home. The tabbed view has been removed, and all items are now listed in a single dialog.
Customize your home dialog
Application Automation has added a new connector, a new template, and updated the Qlik Cloud Services connector.
Databricks is a cloud-based, collaborative data science, data engineering, and data analytics platform that combines the best of data warehouses and data lakes into a lakehouse architecture. Use the new connector blocks to run Databricks pipelines as part of your analytical data workflow. Additionally, create automations that perform or track Databricks ML model transitions and take appropriate actions. These allow you to start tasks after previous tasks have completed and run subsequent tasks after the Databricks job or pipeline has completed. For more information, see How to get started with Databricks.
The new API key alerting template sends an email alert to API key owners with a list of API keys that are about to expire or have been revoked. Additionally, the template can also send all tenant administrators email alerts that contain a list of ownerless API keys due to user deletion. For more information, see Alert API key owners about the API key expiration within x days.
The Qlik Cloud Services connector includes new blocks that allow you to create and update automations, and modify their run schedules across multiple tenants. In addition, automation version control via GitHub is also supported with the use of optional parameters. For more information, see How to use the create and update automation blocks, and change the automation schedule.
Scripting topics covering date and time functions, number interpretation, and scripting prefixes have been improved. Qlik Cloud Help has added new examples to the documentation.
Insight Advisor now supports Swedish and Dutch languages for both natural language questions and answers with Search. This helps more users to take advantage of natural language analytics in the language of their choice.
Several new functions allow you to decompose a time series dataset into trend and seasonality. The trend function identifies direction in the data, and the seasonality function determines seasonality with a known periodicity. The residual function identifies variation that is not associated with seasonal or trend components (noise). With these functions, you now have increased visibility into the patterns and trends in your time series data so you can better plan future action.
The Lineage and Impact analysis features are now visible and available to all users. Administrators no longer need to turn on these features.
These capabilities include the ability to not only visually show the data history by table but also by the specific field within a table—starting with applications all the way back to the original source. Field-level lineage helps you establish trust in the data. When you explore an app, you can also quickly access a data lineage summary that traces back any dimensions and measures in a chart to the original sources. This makes it easy for any user to understand where the data came from within a chart.
Field-level lineage graph
Selecting Impact analysis produces a different user interface that shows which databases, apps, files, or links are directly or indirectly impacted if the value of a particular field was changed.
Qlik Cloud makes a clear distinction between Lineage and Impact analysis:
Lineage shows you a detailed visual representation of the history of a field or dataset, back through the applications and interim datasets to its original source.
Impact analysis shows a downstream view of a data element’s dependencies - which databases, apps, files or links would directly or indirectly be impacted if the value or structure of that particular field was changed.
Working with lineage and impact analysis
Field-level lineage and impact analysis videos
The MongoDB connector in Qlik Cloud has been improved with new security features. You can now use SCRAM-SHA-256 and LDAP authentication options when defining your MongoDB connection.
Now you can access Alerts and Subscriptions from the left navigation pane of the hub making this content easier to find from the main interface.
Qlik Sense Mobile SaaS now includes the following improvements:
Landscape mode is now fully supported in Qlik Sense Mobile SaaS. In addition to supporting apps and charts, you'll see an efficient landscape design for every screen.
Qlik Sense Mobile SaaS on iOS is now supported on devices that use the Apple M1 chip.
KPI enhancements in applications include better rendering, memory consumption, and performance. KPI also now supports linking to a sheet.
A simplified setup process now makes it easier to download the Qlik Sense Mobile SaaS application and automatically add your tenant to your device. In Qlik Cloud, scan a QR code with your device or use the App Store or Play Store buttons to set up your Qlik Sense Mobile SaaS application. You can also access the store buttons from your welcome email and email alerts, or use the banner link when you log in to Qlik Cloud from a browser on your phone or tablet.
Download the app A) Qlik Cloud—Settings and management, B) Welcome email, C) Banner link
Insight Advisor now supports German and Polish for both natural language questions and answers with Search. This helps more users to take advantage of natural language analytics in the language of their choice.
The /evaluations API, used to queue evaluations of Qlik Sense apps and retrieve various performance metrics, is being deprecated in favor of new API endpoints that are more consistent with the rest of the Qlik Cloud platform. For more information, see qlik.dev.
Now you can get notified when a scheduled automation fails to run. Note that only one alert is sent per six hours. Set your notification preferences and delivery options for Application Automation events in your Profile settings.
You can now use dynamic titles in sheets that will be downloaded or exported as reports. Dynamic titles are created using chart expressions. For example, you can have a sheet title that updates to show the current date or total sales in a specific time period.
Dynamic sheet titles can also be used when creating advanced reports to reflect the filter value for the report or sheet.
Create automated machine learning experiments in Qlik Sense. Easily train and deploy models using best-in-class machine learning techniques, in a simple, code-free experience. Make predictions with full explainability data. Publish predictive data into Qlik Sense to visualize and interactively explore it. Use real-time APIs for interactive, what-if analysis to understand how changing parameters might affect outcomes.
Machine learning with Qlik AutoML
Qlik AutoML Tips, demos, and walkthrough
Getting started with Qlik AutoML
The new Direct Access gateway makes it possible for Qlik Cloud applications to securely access data behind a firewall over a strictly outbound, encrypted, and mutually authenticated connection. Qlik Data Gateway - Direct Access operates behind your organization’s firewall, eliminating the need to open inbound firewall ports to access your data from the cloud for analytics, whether that data is on-premises or in a virtual private cloud.
For a visual demo, see Qlik Data Gateway - Direct Access overview and walkthrough.
Qlik Data Gateway - Direct Access architecture
Simplified authoring is now the default creation experience for Qlik Cloud. This new interface surfaces frequently-used design components to help you quickly and easily build beautiful and sophisticated charts and visualizations. Simplified authoring accelerates creation for everyone, and particularly new and less-experienced users because it offers a short learning curve, advanced filtering options, and the ability to explore data as you perform analysis. Through the new experience, organizations can extend governed self-service creation and analysis to more users than ever before, further reducing reliance on analysts and IT.
Key features:
The advanced authoring experience is just a click away for those who prefer the classic look and feel, or need to satisfy additional use cases.
Simplified authoring experience
You can now access data stored in ServiceNow. The new ServiceNow connector allows you to include ServiceNow data, such as incidents, requests, and case records within your analysis. The new connector includes security options such as OAuth or SSL to ensure that only authorized users can access this data.
Application Automation has added a new connector, updated two existing connectors, and added a new template.
Swapcard (new)—Swapcard is a leading event & community platform when it comes to running large and complex in-person, hybrid and virtual events. Swapcard's AI and matchmaking modules can be leveraged to engage audience & generate leads for exhibitors and sponsors. Use cases will revolve around data resources such as event management alerts, notifications, managing event information like attendees, speakers, exhibitors, etc.
DataRobot (updated)—Dedicated prediction API support has been added to the DataRobot connector. The DataRobot enterprise AI platform accelerates and democratizes data science by automating the end-to-end journey from data to value. Users will now be able to get predictions from a deployed model, get prediction explanations from a deployed model, and get predictions from a deployed time series' model.
UIPath (updated)—You can now add a Run Job block to the UIPath connector and set a Timeout period in the Start Job block. UIPath offers an end-to-end platform for automation; combining the leading Robotic Process Automation (RPA) solution with a full suite of capabilities and techs like AI, Process Mining, and Cloud to enable every organization to rapidly scale digital business operations.
Getting started using the UIPath connector in Application Automation
Six new webhooks have been added in order for customers to be able to better monitor their automations and automation runs in their own tenant spaces. Users are able to maintain control of target automations and trigger an automation when either an automation gets created, updated, or deleted or when an automation run starts, fails, or finishes.
Users are able to trace where data used in a block originates from with a simple pop-up that provides a connection visualization.
Support has been added for automation webhook events such as run automation (examples: sending Slack messages, reloading apps, notifying users of results) when another automation changes state (for example, when an automation finishes). Filtering on events and automation IDs is also supported.
Scripting topics covering date and time functions, number interpretation, and scripting prefixes have been improved. Qlik Sense Help has added new examples to the documentation. To test sample load scripts and chart expressions, see:
Now in Qlik Cloud, Direct Query provides the ability for analytics applications to directly query cloud databases like Snowflake with SQL pushdown as users interact with data through visualizations and filtering. Direct Query allows developers to build SQL-centric applications for big data analysis or near real-time scenarios and can be enabled when building a Snowflake data connection.
Accessing Direct Query
App creators can now provide example questions in Insight Advisor within the business logic layer of an app. This allows them to customize the questions to their specific analytic content, and thereby help users learn how to use natural language. When users ask questions, the examples appear in a drop-down menu from which users can select, modify, and submit the question. In Insight Advisor Chat, example questions from across your apps will be available.
Example questions in Insight Advisor Search
Charts generated by Insight Advisor Chat and through the natural language API are now provided as native chart objects instead of images. For users, this provides added interactivity, such as tooltips and scrolling, and better performance. Developers can now use the data contained in these chart objects for additional applications such as custom chart libraries and functionality.
Application Automation now supports Alation Cloud Catalog with a connector. Alation serves enterprises in organizing and consolidating their data.
Insight Advisor now supports natural language insights (natural language generation) with Search in Italian and Portuguese. This helps more users to take advantage of natural language analytics in the language of their choice.
Example of natural language insights in Portuguese
The maximum allowable size for data file uploads has been increased from 6 GB to 100 GB. When uploading very large data files, you might experience constraints due to the memory usage necessary to load QVD files into the engine. If additional dedicated capacity is needed, see Dedicated capacity and .
Now you can see a log of the reload history for your app. Use it to help troubleshoot scheduled reload issues. View the log summary or download the log file to see more details.
App developers can now style the font used for titles, subtitles, and footnotes in bar charts, giving them more options for customizing their visualizations. A new General tab provides options to change the font type, size, color, and emphasis. The Chart tab controls styling of the bars in the chart.
Visual demo of new styling options for bar charts
The Google AdWords connector is no longer supported as of June 2022. This connector has been replaced with the Google Ads connector. If you have an existing AdWords Query Language (AWQL), you can migrate it to the Google Ads Query Language (GAQL). For more information, see Query Migration Tool.
Now you can save your automation as a template. Reduce the time it takes to create new automations by using a saved template as a starting point. Save your templates for personal use or share the template with all users in the tenant. Shared templates improve collaboration and allow less technical users to creat their own automations easily. Find your private templates under Personal and see templates shared by you and others under Shared.
A) Save automation as a template B) View Personal or Shared templates, C) Edit a template to change its visibility
Application Automation has added four new connectors.
Twitter—a microblogging and social networking service.
Oracle Eloqua—a software as a service (SaaS) platform for marketing automation that aims to help B2B marketers and organizations manage marketing campaigns and sales lead generation.
Inphinity—enables active intelligence through workflows, actions, data capture and process and data intelligence
Zenput—provides operations execution software for multi-unit restaurants, c-stores, and grocers.
Application Automation connectors
The new authoring experience makes it easy to create new dashboards and applications. It expedites layout and chart creation, simplifies filtering, and provides easy access to frequently-used properties. Data tables and fields are available directly from the sheet edit view. The new authoring experience increases data literacy and accelerates the learning curve for application design, making it accessible to creators of all skill levels.
Administrators can turn on the new authoring view for users in the tenant. App creators can then toggle between the new authoring experience or an advanced layout that users familiar with previous versions of Qlik Sense will recognize as the previous sheet editor.
To see a visual demo of the new authoring experience, watch Qlik Sense SaaS - Simplified Authoring Walkthrough . For more videos about the new authoring experience, see Analytics creation To step through the new interface, see the following overview of the new authoring experience.
New authoring experience
Insight Advisor now supports French and Italian, allowing more users to take advantage of natural language analytics. French can now be used for both natural language search and natural language insights in Insight Advisor Chat and Search. Italian is supported for natural language search in an app.
French is supported for natural language insights with 1) Insight Advisor Chat, and 2) Search. 3) Italian is supported with natural language search.
Catalog can now include data that is stored in relational databases such as Oracle, SQLServer and Snowflake. Data engineers and stewards can add, manage, curate, and distribute these additional content types, increasing data reuse, visibility, and governance. It also simplifies data usage as data consumers no longer need to directly connect with and look through these data sources. They can browse for this kind of data within the catalog in Qlik Cloud.
Improved collaboration in notes now allows you to see notes that contain snapshots of charts. For example, you can quickly identify all notes related to a specific chart, to other charts in the sheet, or to charts in other sheets. You can also see all other notes in a space. Switch between your notes or notes owned by others.
Find notes related to a chart
Collaborate with more users and groups by sharing apps with those who are not members of a shared or managed space. Sharing an app gives the selected user access to only that resource in the space, reducing administration and simplifying management of the space.
An app is shared with a user who is not a member of the shared space
Sharing apps with users who are not space members
A new refresh option in the catalog indicates when dataset metadata has changed from the last known state. This allows you to choose when to refresh the derived metadata, such as profile. When a change to the schema of a dataset is detected, the refresh icon is green.
The Office 365 SharePoint Metadata connector has been updated to support access to Microsoft SharePoint lists and views. The following new tables can now be loaded in the Data manager: View and ItemsFromList.
Qlik Cloud Government users have additional Microsoft data sources to access government services. US Government data sources are named according to the environment they connect to and include the following connectors:
Application Automation has added two new connectors and updated an existing connector, as well as adding four new templates.
Qlik Enterprise Manager (new)—Build an automation to connect with Qlik Enterprise Manager, the management interface for Qlik Data Integration that helps you design, execute, and monitor Qlik Replicate and Qlik Compose tasks across large business landscapes. For example, create an automation that monitors and then posts alerts to Slack when an endpoint, server, or a task stops running or an error occurs.
Microsoft Azure Blob Storage (new)—New native cloud storage blocks provide connections to the Microsoft Azure Blob Storage platform. Blobs are encrypted storage solutions that Microsoft offers to store unstructured data.
Qlik Cloud Services (updated)—New blocks have been added under Automations. These blocks do not include webhooks. Use the new blocks to run a health check on automation usage in your organization, report on connector usage in a tenant, and automation management across your tenant.
Three new Alerting templates provide email notifications in the following situations:
Alert app owners about apps without reloads in the past X days—App owners receive a list of apps that have not been reloaded in a specified number of days, or apps that have been created but not reloaded.
Alert app owners about apps that have not been accessed in the last 28 days—App owners receive a list of apps that have not been opened in the last 28 days.
Alert app owners and tenant admins about orphaned data connections—Data connection owners receive a notification about orphaned data connections when the associated space has been deleted. Tenant admins receive notifications about data connections that have been orphaned because the data connection owner has been deleted.
An additional template, Store a straight table as a CSV file on Amazon S3, stores a straight table from a Qlik Sense app to a CSV file on Amazon S3.
To learn about how the Qlik Community is using templates, see Application Automation.
New improvements in the Application Automation canvas provide better zoom control, allow you to pan the automation instead of horizontal or vertical scrolling, and include enhancements to the design of blocks, the block library, and the block configuration pane. A new toolbar provides easy access to change automation settings, reposition and zoom, undo and redo, save, run, and view the output.
Toolbar in Application Automation
Access the content you use most frequently with the new Catalog filter. You can now order your search to show the most Recently used content first.
Recently used option for catalog filters
Building on the Qlik Cloud reporting capabilities, improvements to subscriptions, reports, and PDF downloads allow you to further customize, define, and enhance report outputs. Changes include:
Support for custom themes in PDFs
Improved look and feel with margin minimums and higher resolution PDFs
Fixed-size delivery for PDF report outputs
Performance evaluation improvements now present public sheet performance measurements as part of the evaluation. App developers can now see which sheets are impeding the initial load time of an app as well as subsequent loads when sheet content should typically be cached. They can further drill down to see the top 5 slowest objects per sheet. Enhancements have also been made when measuring un-cached response times for objects in isolation. Improved isolation reduces inter-object caching for better fairness when comparing and ranking objects based on response times.
The Amazon S3 connector now has the option to assign an SSE header value during authentication. This can be used with the STORE command only.
Customers with existing JWT (JSON Web Token) configurations now have until July 19, 2022, to update their JWT token creation code with two new attributes. These attributes were introduced to enhance the security and use of JWTs sent to Qlik Cloud tenants with configured JWT identity provider configurations. After July 18, 2022, those using JWT login methods without these additional attributes will be denied access.
Qlik highly recommends adding these attributes before July 19, 2022, to mitigate any disruption to the access and login experience for Qlik Cloud users. After this date, users will need to contact Qlik Support to have access to their JWT login restored.
For tenant administrators who implemented the JWT code and are impacted by this change, see the following tutorial for the steps to make these critical updates: Implement JWT Authorization tutorial.
Qlik Sense Mobile SaaS now supports the ability to explore sheets and charts in landscape mode. You can also see more details about a specific visualization by viewing it in full screen. Improved navigation now allows you to move between sheets by swiping the sheet title to go to the next or previous sheet, or tapping the sheet title to see a list of sheets in the app.
A) Sheet in landscape mode, B) Visualization in full screen using landscape mode
Other changes to Qlik Sense Mobile SaaS include support for:
URL navigation (Parsing app URLs).
Sheet actions.
Show condition with sheets.
Pull-to-refresh the bookmark list. You'll also notice an improved layout of the bookmark screen.
App developers can now use custom theme settings to set the background color and gradient for sheet titles. Different colors help app users tell the difference between public, private, and community sheets. By default, the background is transparent. For information about creating custom themes, see Themes.
Date and time function topics have been improved. Qlik Sense Help has added new examples to the documentation. To test sample load scripts and visualizations, see:
The new Snowflake connector Application Automation provides more blocks to build automations from and to your Snowflake instance and has improved session handling.
Enhancements to the Notes feature now allows you to create a new note from a snapshot of your visualization. The snapshot is automatically added to a new note.
Create note with snapshot
Chart level scripting is a powerful feature that allows you to modify the dynamic dataset behind a chart using a subset of the Qlik scripting language, with techniques such as variables and loops. You can add or modify rows and columns that were not in the original dataset. This allows for calculations in chart expressions that were previously not possible, such as simulations or goal-seeking.
New functionality in the Qlik Cloud connector allows interaction with Qlik Cloud data assets, sets, and stores. In addition, a new Qlik Catalog connector allows the creation of automated workflows that use the metadata stored in Qlik Catalog (on-premises). As a result, you can now create workflows that synchronize metadata between various catalogs for data stewardship.
Application Automation connectors
Two new templates are available to import master items from or export master items to a Microsoft Excel file.
Import master items from an Excel Sheet—read master dimensions, measures, and variables from a Microsoft Excel file and import them into a Qlik Sense app.
Export master items to an Excel Sheet—read master dimensions, measures, and variables from a Qlik Sense app and export them to a Microsoft Excel file.
System integrators can use the Qlik Reporting Service API for systematic integration and bespoke application report distribution. For more information about this API, see the Developer Portal for Qlik Cloud.
For customers looking to move from Qlik Sense Client-Managed to Qlik Cloud, visit the new Qlik Cloud Migration Center. The Migration Center provides tools, instructions, and processes to guide you through the multi-step and multi-stage migration process. It also includes information to help your users, app developers, data integrators, and administrators understand the key similarities and differences between Qlik Cloud and Qlik Sense Client-Managed.
Qlik Cloud Government now supports multiple sheets with subscription reports. Gain more flexibility in self-service reporting with the ability to subscribe to multiple sheets (maximum of 10) in an app.
In response to customer requests and migration goals, the maximum execution time for Qlik Application Automation jobs has increased from 1 hour to 4 hours. This accelerates developer productivity by allowing you to run longer task chains and connect task chains.
As of June 7, 2022, Qlik Cloud will enforce tighter controls related to JWT (JSON Web Token) authorization capabilities with tenants. Two new attributes are being introduced to enhance the security and use of JWTs sent to Qlik Cloud tenants with configured JWT identity provider configurations. JWT authorization attempts to Qlik Cloud tenants made after June 6, 2022, will be denied access without these additional attributes.
We highly recommend adding these attributes prior to June 7, 2022, in order to mitigate any disruption to the access and login experience for Qlik Cloud end users.
For tenant administrators who are impacted by this change, see the following tutorial for further instructions, Implement JWT Authorization tutorial.
Insight Advisor now supports natural language questions in Portuguese. This expands the multilingual capabilities available in apps for natural language searches using Insight Advisor.
Insight Advisor language selection
Qlik continues to improve accessibility and reduce friction for solution providers in providing their applications to Qlik Cloud customers. Providing the same, shared client ID for all Qlik Cloud tenants with OAuth2 enhancements, simplifies the ability of the solution provider to onboard their integrations and extensions with Qlik's customers.
Creating and managing OAuth clients
Let Insight Advisor auto-generate your analysis, complete with visualizations, narrative readouts, even entire sheets. Choose the type of analysis from a variety of available options, such as comparison, ranking, trending and more. Select your data with guidance from Insight Advisor, and then let Insight Advisor generate the rest. Edit the analysis and add it to dashboards for further exploration. With Analysis Types, Insight Advisor supports multiple paths to insight including auto-analysis when you select fields, natural language search, and now auto-generating the analysis when you select an analysis type, for a more directive approach.
Insight Advisor Chat and Search features now support natural language processing in Spanish in apps, expanding our multilingual capabilities.
Starting this month, if your account is over the entitled usage amount, the Service Account Owner (SAO) will receive a usage report by email with the consumption of Application Automation runs per month, or the volume of reports generated using the Qlik Reporting Service. These reports will help the SAO determine the capacity required to fully take advantage of the powerful automation and cloud reporting capabilities available.
Qlik Application Automation now includes the following new templates:
As part of delivering explainable BI, new catalog capabilities are now available. Explainable BI is the concept that users will gain more confidence in using data and making decisions based on it, if they have a good understanding, or explanation, of the information’s origin.
Lineage capabilities have expanded to not only visually show the data history by table but also by the specific field within a table—starting with applications all the way back to the original source. Field-level lineage helps you establish trust in the data. When you explore an app, you can now quickly access a data lineage summary that traces back any dimensions and measures in a chart to the original sources. This makes it easy for any user to understand where the data came from within a chart.
There is also now a distinction between Lineage and Impact Analysis.
The lineage graph shows the history of apps and data in your organization in a graphical data flow.
Impact analysis shows the downstream direct and indirect dependencies for a data element
A new dataset overview replaces the previous dataset detail viewer and provides key descriptive and technical metadata about datasets. Information in the overview includes the source file type, space, creation and last modified timestamps, field and row count, creator and owner, usage metrics, applied tags and common data classifications. Catalog now also provides three views of field profile data: Tile, List
, or Data
Dataset overview and fields
Changes to the user interface in the Qlik Cloud hub introduce a new left pane that simplifies navigation and makes content easier to find. The left navigation pane contains menu items for Home, Catalog, and Collections, as well as Getting Started. Additionally, Catalog includes a more prominent Spaces drop-down so you can easily navigate and view content in spaces.
Left navigation pane and new Spaces drop-down
Insight Advisor Chat now supports apps that use section access. This makes conversational analytics available to those who use section access for data governance.
The new Qlik Google Ads Connector allows you to access your performance data using the Google Ads Query Language. Google will stop supporting the API for Google AdWords on April 27, 2022. If you are using the old Qlik Google AdWords Connector, you will need to create new connections with the Google Ads Connector.
New actions available with the button object improve the workflow for on-demand apps and dynamic views. App developers can use the button to make interfacing with and transitioning to a new app more user friendly.
The redesigned scatterplot chart provides greater flexibility and detail. Scatterplot now supports regression lines, including average, linear, exponential, and logarithmic, as well as second, third, and fourth polynomial. Customize the regression line settings including color and type, vertical or horizontal fit, and show formula to quickly see the relationship between two variables.
Scatterplot chart with regression lines
Qlik Application Automation will now recover and prompt you to restore any unsaved work the next time you open an automation in the editor. For example, you might have unsaved changes if the automation editor closes unexpectedly due to a session time-out or browser refresh. Restored, unsaved changes are stored for two weeks.
Select the restored automation with unsaved changes
You can now upload apps from other versions of Qlik Sense that use GeoAnalytics extensions. The extension will continue to function until March 2023, giving app developers time to modify apps to use the improved Map Chart feature in Qlik Sense SaaS instead.
Insight Advisor Chat now includes support for period-over-period analysis, allowing users to ask natural language questions to compare current performance to prior periods and get answers through conversational analytics.
Tenant and data admins can now monitor scheduled reloads in the Management Console.
Scheduling details for data assets in the Management Console
The Databricks Connector now supports OAuth 2.0 authentication with Databricks on Azure. The support for OAuth also allows single sign-on (SSO) to Databricks when using an identity provider.
The Databricks connection interface has been simplified to include the database properties that apply only to this connector.
A new toolbar in the Qlik Application Automation canvas Editor view includes Undo and Redo buttons, allowing you to easily revert or reinstate actions as you create your automation.
Toolbar in Editor view
Qlik Application Automation has a new Okta connector. Okta is a customizable and secure Identity as a Service platform. The Okta connector in Qlik Application Automation allows you to manage your users and groups in an automation.
Application Automation connectors
All users can now set the run mode of the start block to webhooks to trigger automations based on events in Qlik Cloud. In addition, you can now apply filters to improve efficiency and gain better control over when automations run, for example by triggering on specific apps or apps in specific spaces.
Webhook for the App Reload Finished event filtered by space ID
Gain more flexibility in self-service reporting with the ability to subscribe to multiple sheets (maximum of 10) in an app.
With Qlik Sense Mobile, you can now convert visualizations to tables directly on your device, allowing for better visibility into your data when you're on-the-go. Tables include infinite scrolling, resizable columns, column sorting, full screen mode, and the ability to make selections directly in tables. Tables are optimized for performance for fast rendering on mobile devices. This capability improves the functionality, usability, and accessibility of Qlik Sense Mobile, building on the unique, interactive mobile experience online and offline.
A new usage metric setting in the Management Console allows tenant administrators to control whether catalog items in the tenant show KPI metrics, such as views, viewing trends, and usage. KPIs allow you to easily understand the popularity and usage of content at-a-glance. The usage metric setting is turned on by default.
Turn on usage metrics in the Management Console to show KPI metrics for catalog items
The new advanced analytics integration connector for Databricks MLflow allows you to interact with and explore live calculations made on the Databricks platform directly within Qlik Sense dashboards.
The Azure ML Connector now supports the following services:
Automated ML
Designer
Improving visibility to data content in the tenant, tenant and data administrators can now see and manage data assets from the Management Console for the spaces to which they have access. This allows administrators to provide better tenant management at scale.
Data assets in the Management Console
New map settings include options for label coloring, allowing you to customize how labels contrast with the base map or colored areas. Set your map to automatically adjust the label coloring depending on the base map, or select your preferred coloring.
Labels with a Light label color contrast well on dark areas of the map
Qlik Cloud makes use of utilities and connectors that are installed on your own systems. These tools are available for administrators to download from the Tools page in Qlik Cloud or from Product Downloads, which has a new location and an improved user experience.
Example from the Download Site where the files have been filtered on product and release.
Now you can add background colors to KPI charts, giving you more flexibility when customizing your visualizations. An extensive array of new icons has also been added to the existing icon set.
The integrated OData connector can now load data tables stored in JSON format. All data types in a JSON response are identified, including hierarchies and collections. You can retrieve data structures in normalized data tables.
Providing more visibility and control over resources in the tenant, administrators can now view and manage data connections in the Management Console for the spaces to which they have access.
Data connections
Announcing the release of five new smart connectors to Qlik Application Automation.
Connector | Description |
---|---|
![]() |
Expert.ai is an artificial intelligence platform. |
![]() |
GitLab is a DevOps platform for development, operations, and security teams. |
![]() |
Microsoft Power BI is an interactive data visualization software. |
![]() |
OAuth2 is a protocol for authorization. It provides authorization flows for web applications, desktop applications, and mobile phones. |
|
Tableau is an interactive data visualization software. |
Application Automation connectors
Announcing the release of two new time-saving Qlik Application Automation templates.
Commit an app to GitHub: Saves an app and its load script to GitHub whenever the app is published.
Import an app from GitHub: Retrieves a specified QVF file from GitHub and imports it as an app.
Insight Advisor Chat improves support for follow-up questions with the Explore this further option. The option takes you directly to search-based discovery within apps for deeper analysis. When you ask follow up questions to an original question and select Explore this further, the app opens with the selections applied for the full line of questioning, allowing you to continue visually where you left off conversationally.
The Explore this further option opens an app and applies selections to filter data on sales for Germany
Enhancements to creating and setting up alerts deliver a more user-friendly and efficient workflow to help you accelerate time to action. Details from the visualization, such as title, measures, dimensions, and selections, automatically fill the associated fields when you start creating an alert.
Create alert dialog with improved workflow
A top request through Ideation, the updated, flexible variable dialog simplifies the management of chart variables. Displaying all variable elements, including name, description, value, and tags, it allows you to add, search, and duplicate variables. You can even delete multiple (up to 20) variables simultaneously. These capabilities alleviate manual work and help teams work more efficiently.
New variables dialog
Learn how to build set expressions for set analysis.
Business Logic allows you to define the default grain for a calendar period, such as a yearly, quarterly or monthly basis. When you create behaviors such as default calendar periods, you can now specify whether to use or ignore the grain for a particular analysis, providing more advanced fine grain controls.
Insight Advisor now returns more robust period over period analyses in the form of entire dashboards, when users select or search for applicable fields. Instead of a simple chart, you get one or more charts and KPIs, along with a filter pane, allowing you to make selections and further explore comparative performance.
A period over period dashboard analysis
You can now delete shared or managed spaces directly from Settings.
Deleting a shared space in catalog
The Facebook Fan Pages connector has been removed. Any instances using the connector will no longer work in Qlik Cloud.
The tables available with the Twitter connector have been updated. New tables include: Followers, Following, HomeTimeline, and LocationWithTrends. Tables that have been removed include: TrendsForPlace, TrendsNearLocation, UserLookup, and UserLookupById.
A new advanced configuration setting allows you to use Google Identity or OneLogin as the identity provider with Qlik Sense Mobile SaaS and OAuth 2.0 applications. For more information, see the Advanced Options section in Creating a new identity provider.
Qlik Application Automation now has seven new connectors in the following categories: Data Warehouses, Platform Enhancements, and Remote Applications. For more information about the new connectors, see the recent Qlik Application Automation post on the Qlik Product Innovation Blog.
Application Automation connectors
Now users can automatically pull together graphical data flows from multiple sources with the introduction of Qlik Lineage Connectors. This new addition to Qlik Sense Enterprise SaaS empowers users to uncover more lineage-related insights by accessing multiple Client-Managed BI tools and data sources to find and document those assets. The result is that Impact Analysis can not only show the data lineage of your Qlik Sense SaaS apps, but also the data lineage of Qlik Sense Enterprise Client-Managed apps, QlikView apps and even Tableau and PowerBI apps. It can also show the upstream lineage of data stored in repositories like Snowflake or SQL Server.
Qlik Lineage Connectors
Extracting lineage data with Qlik Lineage Connectors
Catalog items now display KPIs that allow you to easily understand the popularity and usage of your content at-a-glance. New KPIs track viewing trends, the number of unique views in the last 28 days, as well as the number of applications that currently use a particular item.
KPI indicators for a data file show 2 viewers, a positive viewing trend, and 4 applications using the data
Distribute customizable report outputs from Qlik Sense apps to a variety of channels using business process automation. You can:
You can also integrate the Report Service API into your environment.
You can now browse and select datasets in the data catalog from the Data load editor.
Qlik Cloud supports OAuth, a standard security protocol that protects end-user credentials, while still allowing access to API resources through third party applications. Support for OAuth clients lets you deliver secure and seamless integrations of Qlik Cloud Services and Qlik products with other software. It also makes embedding Qlik applications significantly easier. New tutorials are also available to show you how to build client applications, see the OAuth Libraries section on the tutorials page of the Developer portal.
Creating and managing OAuth Clients
The Bitly V2 built-in web connector has been removed.
Qlik Application Automation templates are a mechanism to accelerate flow development. Choose a starter template from a list of Qlik-curated blueprints and then configure the blocks, rather than assembling the automation from scratch. Currently, there are 18 automation templates. Categories include: Analytics Data Pipeline, Alerting, Reporting, Master Item Management, Change Control and App-to-App Integration. Automation templates are available with every Qlik Application Automation subscription and do not require additional licensing or pricing.
Templates in automations
Insight Advisor can now recognize expressions contained in variables and use them when generating analytics. This allows users who manage expressions in variables to generate more relevant insights.
Time series forecasting is a new capability in the line chart that allows you to easily generate future forecasts that extend your historical data. Users can add a forecast to a line chart through the properties, specifying the calculation method, time period, and confidence intervals for the forecast. Calculation methods include SSA (singular spectrum analysis), a non-parametric time-aware method that is commonly used, and OLS (ordinary least squares), a more linear method that uses regression techniques. With time series forecasting, you now have the ability to easily generate forward-looking views without having to use complex modeling or third-party calculations.
Qlik Sense SaaS users can now quickly find the data they need by taking advantage of the catalog browsing experience in Data manager. Once a dataset is found using any of the catalog search capabilities, you can add it to the app or explore further using catalog capabilities like visual profiling and viewing sample data. You can also search for and select multiple data sets from different Qlik Sense SaaS spaces and easily include them in your app from a single easy-to-use interface.
Simply and securely load geographic data into Qlik Sense SaaS, providing greater flexibility and usability in Qlik Cloud. This includes new support for datafile types and the ability to load from data files in GeoOperations.
Insight Advisor now supports natural language insights in Spanish, expanding our multi-lingual capability.
Qlik Sense Mobile SaaS now supports iOS 14 or later.
Technical and security considerations
If you have access to multiple tenants, you can now switch between them in the Qlik Sense Mobile app.
Switching between subscriptions
Qlik Cloud now includes customized tours for new users based on their user role and Qlik product experience. The tour starts the first time you log in to Qlik Cloud.
Qlik Cloud welcome tour
Straight tables in view data mode have improved keyboard navigation.
Improvements to the grid chart now let you show labels for each data point in the chart. Labels identify the value of the measure for the data point. Also, in preparation for the deprecation of the Heatmap extension in February 2022, the grid chart now includes two layouts, Standard and the new Heatmap option. The heatmap layout adds the functionality of a heatmap chart to the grid chart. As of February 2022, the Heatmap chart extension will no longer be supported.
Labels for data points in a grid chart
Heatmap layout with labels in a grid chart
New parameters have been added to business logic that help refine the analysis generated by Insight Advisor. Options include setting trend direction and sort order for a measure, specifying favorite types of analyses to be used by the system, and specifying the overall aggregation type for complex expressions.
Favorable trends: Sets whether the desired trend for a measure is to increase or decrease.
Favorite: Identifies a measure of interest for Insight Advisor so that Insight Advisor will use the measure more often when generating visualizations without user queries or selections.
Overall aggregation: Helps Insight Advisor determine which aggregation to use for queries that involve master measures with complex expressions where the aggregation is not clear from the outset.
New authentication support with the Amazon Redshift connector allows you to use AWS Identity and Access Management (IAM) credentials authorization. This will allow organizations to assign role-based access privileges in addition to designating access rights individually.
The Snowflake connector now supports the use of key pair authentication to allow you to use enhanced security measures when users access Snowflake from Qlik Sense.
Convert passive analytics consumption to active actions in real-time using automations with buttons. Connecting automations to buttons in a sheet lets you automate manual tasks and improve visualizations for your app users. Actions can be as simple as sharing metrics over Slack or email. Or, they can allow users to create or update data in a business application, such as Salesforce. When you connect an automation to a button, the automation runs each time you click the button.
Connecting an automation to a button in a sheet
Insight Advisor now includes a new Like button for all charts generated from a natural language question. Liking helps to improve natural language question responses over time.
Insight AdvisorLike button
Qlik now provides a new cloud region in Singapore to support the growing demand for customers to rapidly innovate with data and technology for analytics in the Asia Pacific (APAC) region. This new region is the second of two cloud regions in APAC and the fourth globally, following cloud regions in Australia, Ireland, and the United States. Organizations based in Singapore and the APAC region can now store and deploy data for analytics locally at scale, ensuring optimal operational performance and data compliance with the inherent cost savings of the cloud. Storing data in a local cloud allows customers to effectively meet the analytics needs of their users across the region, with faster access and lower latency.
Select your region from the map during setup of the tenant
Support has been added for the Personally Identifiable Information (PII) Service available in Amazon Comprehend. Now you can identify PII data in text that originates in a Qlik Sense app and use the metadata to mask it within a Qlik Sense application data model.
Users with access to many spaces and connections can now view data connections by space in the Data load editor. By default, connections in their Personal space are loaded. Organizing connections by spaces improves load time and provides greater control over the connections you want to view. The new spaces list is also available in the Data manager when adding data.
View Data load editor data connections by space
Set analysis lets you define a set (or group) of data values different from the normal set defined by the current selections. This is useful if you want to compare the current selection with a particular value. For example, last year’s value or the global market share.
The set analysis documentation in Qlik Sense Help has been expanded and now includes examples.
Dollar-sign expansions are definitions of text replacements used in scripts or in expressions.
Qlik Sense Help has added new examples to the dollar-sign expansion documentation. To test sample load scripts and visualizations, see:
The GitHub data connector now supports the Statuses and StatusHistory tables.
This release includes further customization of tooltips with the ability to embed a master visualization inside the tooltip. This allows you to visualize an overview first then drill down directly in the graph for details. The embedded chart inherits the state with dimension value in focus selected.
Chart in tooltip example
The line graph labels have been enhanced with a new All option, which forces data labels to always remain visible. Additionally, the Auto option, which automatically shows labels based on the space available, has been improved to display more labels.
Line chart showing label options for Auto and All
nebula.js is a collection of JavaScript libraries, visualizations, and CLIs that help developers build and integrate visualizations on top of Qlik's Associative Engine. With this update, as a part of the recent release of the Nebula 2.0 library, developers can generate a nebula visualization that can be used as an extension in Qlik Sense. This also allows the developer to generate a legacy extension to run in Qlik Sense before 2020.
For more information, see Introduction to nebula.js.
You can now create alerts that compare a measure value or dimension to the previous evaluation. For example, create an alert to notify you when a stock price jumps by 10% from the last evaluation, or when the sum of sales exceeds 100 but only if this change is different from the previous evaluation.
Last evaluation alert condition
Comparing alert conditions with the previous evaluation
Creating an alert that compares values and dimensions with the last evaluation
This release introduces Layered Labels, giving you greater control and flexibility over the presentation of graphs. In addition to label options like auto, horizontal, and tilted, you can now layer your labels on the X-axis. Layering staggers your labels to make better use of space and provide more room for your graph.
Chart with layered label orientation
Qlik Sense now supports the following screen reader configuration: NVDA screen reader for Microsoft Windows and Google Chrome. The NVDA screen reader is a third-party product and is not licensed or supported by Qlik. The NVDA screen reader is a third party product and users are responsible to obtain their own license for the screen reader.
Advanced Analytic integration supports the real-time exploration of calculations from data science and machine learning models within Qlik Sense. Direct, engine-level data exchange with third-party data engines deliver new calculations as the user clicks, allowing you to refine context and evaluate the results both interactively and visually.
Qlik Sense SaaS provide out-of-the-box connectivity to Amazon Sagemaker, Amazon Comprehend, Azure ML, DataRobot, and a QlikAdvanced Analytic connector that allows you to connect to custom solutions and other machine learning platforms.
Performance evaluation now includes the option to compare evaluation results between versions of an app. This improvement helps app developers make informed decisions as they develop and optimize app performance before publishing it to shared or managed spaces.
Analyze the origin of your data set with impact analysis. Visually see the data flow of apps and data sets in your organization, including origins and outputs. Data administrators can use this information to improve operational efficiency. App developers and data modelers gain trust and a better understanding of their data. They can also see which applications use the data set, and identify new information derived from an existing data set.
The lineage graph
Qlik Application Automation helps you easily create workflows that streamline and optimize your data and analytics processes. Its visual approach lets you quickly assemble automated flows that span market leading SaaS applications to trigger alerts and invoke downstream processes that react to changes in your business. Consequently, you spend less time programming back-office tasks that drive automated actions, leaving you more time for data analysis.
Insight Advisor now provides the ability to detect and show changes in the trend of a time series by analyzing patterns in historic data.
You can now add images by URL to rows in straight tables for added context and insight.
Table with images
Insight Advisor Discovery provides an improved Insight Advisor experience in-app, allowing users to easily auto-generate the most relevant analyses and insights from their data. A new Discovery button opens Insight Advisor, where users can select fields and generate insights without having to navigate away from their current sheet. The new Ask Insight Advisor search box is now visible at all times within dashboards, allowing users to easily generate insights using natural language processing. Auto-generated visualizations and analyses can be refined and added directly to dashboards for further exploration.
Users can now directly edit master items from the properties panel in visualizations, removing the need to navigate to them in the assets library to make changes.
Custom analyses allow you to create custom responses for specific phrases in Insight Advisor. You can define the analysis that will be returned, such as comparison, ranking, and clustering, using specified input fields. This provides improved control over auto-generated analytics without having to define complex rules.
Subscriptions to charts and sheets can now be shared with up to 20 other Qlik Sense users. If you create a subscription, you become the subscription owner.
When an app has business logic turned on, users can search all fields set to visible in the app.
When an app has business logic turned off:
Users with edit permission on the app can search fields and master items.
Users with View only permissions on the app can search master items.
Users can see the history of an alert, in chart form, in the mobile to see whether patterns are emerging around frequency of scans compared to triggered alerts.
Using Qlik Sense Mobile for SaaS
For added security, you can now turn on app lock to use your device authentication method (PIN, fingerprint, or face) with the Qlik Sense Mobile SaaS app.
Unlocking the app with a PIN or biometric
The container is an object that lets you add visualizations in a limited space. By default, the first tab is displayed when you view a container. To improve the user experience, you can now set the default tab when creating or editing a container.
Alerts let you monitor critical data without opening yourQlik Sense apps. Use alerts to manage your business by exception and increase the value of Qlik analytics with notifications that lead to immediate further analysis and prompt actions based on insights.
The alerting features are now available to Qlik Sense Business users. Previously, they have been only available to Qlik Sense Enterprise SaaS users.
When configuring an SMTP email server, you can now have separate sender email and user name settings.
Data owners can use the new data consumer role to provide consume-only access to data connections and data files inside a space. This new role gives you better control over space members and your data assets inside spaces.
Users can now compare a change in a measure of the current period versus the previous period by using the Period over period analysis. The analysis is applied to a line chart which lets users visualize how a measure differs between two periods of analysis.
Configure a behavior to use a default calendar period for Period over period analysis
Data curators and consumers can now browse their data catalog using filters. Filters help to find and understand all available data in the system. Catalog filtering reduces time spent managing and browsing for content with improved search accuracy.
Additional global access roles, which were introduced on May 4, 2021, improved user system security. With this update, you can now assign global access roles to user groups. This helps you to easily assign permissions to a group of people, which makes the management of permissions in your tenant easier and more scalable.
Users can easily see alerting trends in the hub with the new capability to see the alert history in chart form. This helps users with data alerts see patterns emerging around the frequency of scans and triggered alerts.
Users can now customize the analysis period used by Insight Advisor by setting the periods of analysis. Previously, users would need permissions to change the business logic. Now, users can make these changes on demand, improving their ability to get the insights they need quickly.
Insight Advisor Chat introduces a better way to communicate error messages. This new communication element helps you better understand when issues need to be addressed in underlying apps.
Qlik SenseGeoOperations help content is now available in this helpsite. Qlik SenseGeoOperations is available as an Advanced Analytics Integration with Qlik SenseGeoAnalytics for Qlik Cloud. It allows you to make geographic calculations and use functions for calculating routes or travel areas. You can also load geographic data from GeoJSON and ESRI shapefiles.
The GeoOperations function INTABLE now can now convert CRS coordinates when rendering maps from data in Qlik Sense.
The improved bookmark functionality in Qlik Sense now lets you save the layout for a container object. Previously, container objects saved in bookmarks would default to the first tab. Now a user can choose to save the layout state of the container when creating the bookmark. Then, when users open the bookmark with a container object, they see the saved container layout.
Qlik Sense SaaS users who are migrating from QlikView to Qlik Sense can use the new QlikView Object Migration for Cloud tool to migrate server bookmarks for QlikView apps to their managed spaces in a Qlik Sense SaaS tenant. This tool solves the issue of not being able to bring QlikView bookmarks into your Qlik Sense SaaS environment, and it improves the migration experience for Qlik Sense users migrating from QlikView.
Migrating bookmarks from QlikView to SaaS editions of Qlik Sense tenants
A fourth base map type with a dark theme has been added to Map chart options. The dark base map with neutral colors puts the focus on the content and makes light-colored feature layers stand out.
Customers can open apps with the IE plug-in using Microsoft Edge in IE mode. The menu option to "Open app in IE Plugin" is only available when using the Edge browser.
Notes provide users a collaborative canvas inside the Qlik Sense environment, which allows users to capture analysis, give context to what they are seeing in the data, and collaborate with others on what it means. Users can create rich-text narratives in notes alongside snapshots of analytics to create a collaborative analytics experience inside Qlik Sense.
With this release, we have introduced personal digests for notifications. For alerts and system events, users can now choose to receive a daily email digest with all relevant notifications packaged together. They have the option to choose which alerts and types of events are included, they can change the time the digest is delivered, and they can link directly to live analytics for follow-up.
User can now add bars on the secondary axis in a combo chart.
The underscore.js library that is exposed through the AMD module in the Qlik Sense client has been updated from version 1.5 to version 1.13. This change fixes a potential security issue with the underscore.js library, but it causes some breaking changes to extensions and mashups that use the library.
The following properties and methods are removed from the underscore.js library with version 1.13:
unzip method is replaced by _zip.apply(_,list).
_.escape function no longer escapes /.
_.matches function is replaced by _.matcher.
Alerts let you monitor critical data without opening your Qlik Sense apps. Users now have access to a tutorial that shows you how to create simple and complex alerts, and how to manage an alert's lifecycle.
A new real-world use case and example is available to help users understand the KMeans and centroid functions. "Optimizing with k-means: A real-world example", takes users through a real-world business scenario from a raw dataset to calculation of coordinates on a Map chart. This example highlights the value of Qlik Sense KMeans and Centroid functions and shows how to apply them.
New data alert notifications can be sent to users for the following events:
An alert stopped or failed
I am added to an alert
Users can now see the latest version of all monitored visualizations in Qlik Sense Mobile SaaS.
Monitoring visualizations in Qlik Sense Mobile for SaaS
This new Qlik Sense SaaS capability allows data consumers to subscribe to charts or sheets to receive a scheduled PDF report distribution to their email. Users can also expand insights by including a link back into the Qlik Sense app at the analytic point of report presentation.
Users can now find all documentation for data sources supported by Qlik Sense SaaS on this site. This was previously available in the Qlik Connectors documentation.
The following connectors and tables are now available from Data Manager:
The following performance features are available for all ODBC connectors (except snowflake):
[x] Use Bulk reader - This provides a faster way to fetch data.
Max String Size - This truncates long strings down to a max string size.
You can now add an image to a point layer map from a URL. This is in addition to adding images located in the Qlik Cloud media library.
In a combo chart, you can configure each measure to have its own color setting, either a single color or color by expression.
The Share button control in the Dashboard bundle has been removed and replaced with the Publish bookmark tool. Existing instances of this legacy control continue to function, but new instances cannot be added.
If you need to configure existing instances of this control, refer to the last version of the help before it was removed.
Users with app creation capabilities can now select an app creation locale in their profile settings. The user-defined app creation locale enables app creators to inherit the locale for script variables for formatting, which apply to money format, decimal separators, month and day names.
Users can now view and edit alerts they own within Qlik Sense app. This helps improve visibility of the data alerts you've already created in the context of the app and promotes the usage of data alerts.
A card-based, visual representation of field profiling metrics laid out in a grid manner now complements the existing list view. Tile view is designed to give users a good overview of some key metrics and the most informative content for that type of field; whether the field is text or numeric with toggle options for mixed fields.
The partial data reload option can be used in scheduled data reload operations.
The documentation for Qlik Sense SaaS has been redesigned to meet the needs of each Qlik Sense user role. This will make it easier and more intuitive to find the information for your role in your organization’s Qlik Sense environment.
The Analytics for business users section discusses how to use Qlik Sense apps and makes data-informed decisions.
The Creating analytics and visualizing data section discusses how to create and design Qlik Sense apps, along with creating and editing visualizations.
The Loading and modeling analytics data section discusses how to load, model, and manage data used by Qlik Sense apps. This section can help you better understand how to bring in data from multiple sources and use data load scripts.
The Administering Qlik Sense section discusses the different administration roles. It includes information about managing users, system settings, configuration, and handling user resources.
The API allows developers to build their own client for Qlik Insight Advisor Chat into their apps and enterprise chat bot platforms, available where the chat add-on is included.
Insight Advisor can now analyze and score the mutual Information between fields. This provides a measure of the influence that one field has on another, allowing you to understand which fields are drivers of another target field.
You can also now calculate mutual information between targets and drivers in charts with the MutualInfo function. This allows analysis such as pair-wise mutual information analysis and driver breakdown by value.
In addition to running when data is reloaded, you can now schedule alert evaluations at specific times. This can help you create a schedule for analysis and customize how often you might be alerted.
These are the first in a series of updates on how security roles and global access rights are assigned. Users who aren’t tenant administrators or aren’t Professional users can now be assigned a role that lets them create shared or managed spaces. Additionally, these users can also be assigned the analytics admin role for limited access to governance capabilities in the management console. These changes provide more flexibility for the appropriate users to create spaces and manage content, especially when working in multi-cloud or hybrid deployments that distribute content from a Qlik Sense Enterprise Client-Managed site to Qlik Sense SaaS.
In this release, there are several enhancements to Insight Advisor Chat including improved natural language in question responses (NLG), a refined user interface for question parsing, and more intelligent app selection when responding to questions.
Qlik Sense Mobile SaaS delivers Qlik Sense analytics in the best form for mobile consumption, with enhancements such as a single object mode for navigation, an intuitive selections bar, and a mobile collection in the hub. With the Qlik associative engine running on-device, it supports fully interactive online and offline exploration allowing mobile users to answer unanticipated questions in any environment. And it features integrated alerting with push notification, so users can be notified of important changes in their data and respond in real-time.
Get started with the Qlik Sense Mobile for SaaS app
This new connector will enable Qlik Sense SaaS users, assuming they have sufficient privileges, to select and browse the Office 365 SharePoint hierarchical structure.
Qlik Sense SaaS administrators now have the option to let users provide their own credentials when using any of the following connectors:
Amazon Athena
Amazon Redshift
Apache Drill
Apache Hive
Apache Phoenix
Apache Spark
Azure SQL Database
Azure Synapse Analytics
Cloudera Impala
Databricks
Microsoft SQL Server
MySQL Enterprise Edition
Oracle
PostgreSQL
Presto
Teradata
Updates to the data to visualizations experience provide a consistent first-time add data sequence from both the Welcome screen and Add New button in the cloud hub. After data is loaded, users are prompted to either go directly to insights or to their sheet. Users have clear direction and options about how to continue creating, adding and analyzing insights.
A variety of demo applications are now available directly from a special collection on the home page of the cloud hub. Qlik Sense Business users and Qlik Sense Enterprise professional users can open demo apps in their personal space and explore content that highlights the full power of Qlik Sense. Users also have the ability to explore apps and add sheets within the demo apps.
Now you have direct access to our Ideation program within your Hub. Qlik’s Ideation program provides our valued customers and partners an opportunity to influence how our products evolve and where we take our innovations in the development process. Now part of the Connect & Learn navigation, you will find a dedicated space for Ideation that will lead you to a video overview of the program and direct access to the community forum. In addition, you now have visibility into newly released features derived from the Ideation process which will be highlighted in the "What’s New" area of Connect and Learn marked with an Ideation badge.
Users can re-publish apps out of personal and shared spaces into managed spaces with duplicated or recreated versions of an original app, providing more flexibility for content workflows across development, test, and production spaces.
The exporting PDF capability has improved to better deliver Qlik themes, retaining margins, presentation headers and other visual elements, and providing a rendition of your sheet that closely resembles the visible dashboard.
The Salesforce connector now supports OAuth authentication, helping you improve security by keeping your user information separate from Qlik Sense.
Create a Salesforce connection
OAuth authentication in Snowflake and Salesforce connections
Navigate quickly and use the tools that you need in the redesigned navigation bar and toolbar in Qlik Sense.
Dedicated capacity provides additional dedicated memory and virtual CPU in Qlik Sense SaaS to support workloads and consumption of large apps. This release provides expanded options for customers purchasing dedicated capacity, with the ability to choose 120 GB memory or 240 GB memory pods.
Qlik Sense SaaS Enterprise and Business now include an initial set of data cataloging tools that will be the foundation for additional functionality in the future. Integrated data cataloging allows users to spend less time finding data and more time getting value out of it. Datasets can now be profiled and governed within the cloud hub, making it easier for users to find and determine which data is best to use within a new or existing app.
Webhooks allow communication between enterprise applications to send and receive automated messages from one another. This is makes it easier to create automated workflows, enhance control over your analytics supply chain, and empower active intelligence through your organization.
Users are now able to monitor on-disk and in-memory app size of their applications. Users can get this information from the App Details section of each app and from the App section in the Management Console. This enables users to closely monitor app size and evaluate whether additional data capacity is needed.
Users can now create data alerts with conditions that span more than one step, by visually adding or grouping steps. This provides more robust functionality and control over how alerts are evaluated, making data alerting even more powerful.
An improved combo chart is now available, with enhanced functionality including support for vertical presentation, reference lines based on measures and dimensions, and line and bar styling.
Reuse data models more easily by using apps in personal and shared spaces as a data source for a binary load. This is in addition to the existing capability to binary load from third party storage.
Administrators now receive a warning when attempting to invite users by email if a user is already active in the system. The active user doesn't receive another invitation.
To support the growing popularity of Databricks, a Qlik strategic partner, Qlik Sense SaaS Enterprise and Business now include a pre-configured connector for Databricks. This includes support for the new Apache Spark 3.0 engine. Utilizing the Databricks SQL Analytics service, the Databricks connector enables Qlik Sense users to easily include data in Databricks to gain a comprehensive view of their business as well as generate new insights and data-driven actions.
Enhanced capabilities have been added to grid dimensions for your visualizations that help better identify chart location and associated dimensions on the sheet. There is a new indicator on the bottom right side of chart objects that contains the grid dimensions and coordinates when moving or resizing objects on your sheets.
Service account owners can now have more than one subscription and tenant associated to their email address. Additionally, if a user has access to more than one tenant via subscription(s), they can now easily view all those tenants from one convenient location in the MyQlik portal and login page. If the subscription allows more than one tenant, and the Service Account Owner has not created all their allowed tenants yet, they can create their remaining tenants from within MyQlik.
Registering for a subscription
There are several improvements to the Insight Advisor search-based analysis within Qlik Sense apps. These improvements include:
Analysis of change over time – Insight Advisor Search will now generate multiple charts for a single analysis type, such as responding with analysis of data between two date periods through a combination of charts.
Natural language generation – Visual charts generated by Insight Advisor Search now have a new option to view natural language insights and interpretations of the data.
There are several improvements to the Insight Advisor conversational analytics within Qlik Sense apps. These improvements include:
Follow-up suggestions: Insight Advisor Chat now offers possible follow up questions for the user, helping drive further analysis and insight.
Improved context awareness: Insight Advisor Chat improves how it interprets context, in terms of how a question is being handled in the context of a previous question or a new question.
The new KMeans algorithm can prevent clustering results being skewed by one feature dominating another. Data can now be normalized for analysis with an optional ‘norm’ parameter.
There is a new tutorial showing how to improve search-based analysis in Insight Advisor using business logic. By customizing the logical model and adding vocabulary, you can improve the experience for search-based analysis.
Users can now reference master measures within expressions, improving productivity and governance.
App creators can now show or hide sheets based on conditions, enabling them to target different user groups within the same app by tailoring the experience.
App creators can now add new button actions to provide reload data functionality directly in an app.
A new visualization that uses symbols of varying size sorted in a grid. The grid chart is included in the Visualization bundle.
A new capability that lets you embed and play videos directly in Qlik Sense apps.
Qlik SenseSaaS users can now customize the hub landing page by choosing which collections appear on the home page and in what order.
Alerts can now be evaluated based on whether section access is enabled in the source application.
For apps without section access, there is no recipient limit. For apps with section access, the limit is now 100.
SAP Bex and InfoProvider connectivity is now available on Qlik SenseSaaS, improving on our end-to-end SAP solutions. This is a new SAP BW connector that merges the InfoProviders and BEx connectors.
The ODBC connectors now include connectivity to Amazon Athena database.
Single-sign on lets Qlik Sense to store the credentials separately from a data connection. This provides an option to enforce user-specific credentials and allow a set of credentials to be saved for reuse across multiple connections.
A new merge command in Qlik Sense scripting that lets you load only the data that has changed into a Qlik Sense app without having to reload the entire data model.
Coalesce: For returning the first not null expression.
EmptyIsNull: For identifying empty strings.
LevenshteinDist: For comparing fuzzy strings.
App evaluator is a new feature built into Qlik SenseSaaS to support Sense app developers. The app evaluator will allow an app developer to request a performance evaluation of a Sense app.
Documentation for managing data security with Section Access has been revamped with a new organizational structure to highlight the levels of security through the use of data reduction. A clear explanation of Section Access concepts, updates to Section Access implementation details, and more authorization script examples have been added.
If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!