Our spin-off for business planning and simulation with Jedox.
Migros Bank migrated its existing business intelligence solutions to Qlik, Informatec ensured the smooth migration of existing applications and implemented further applications in the product and sales areas.
Last places available for our Classroom Trainings in June - Qlik Sense Create Visualizations (20/06 - 21/06/2022) and Qlik Sense Data Modeling (22/06 - 24/06/2022)
Qlik Sense business users, analytic creators, and data integrators will give a special attention to the new features and improvements available in Qlik Sense Enterprise on Windows since May 2022.
Business logic fine grain controls in Insight Advisor
The intention of Business Logic is to allow you to define grain for a calendar period, such as a yearly, quarterly, or monthly basis. When you generate behaviours 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.
A lot of improvements have been made to the sheet navigation and layout. Also, functionality that was previously only supported in web browsers is now made accessible in the mobile app. The list below summarises the improvements:
New action for button object
New actions now accessible and 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.
Label colouring with map chart
New map settings incorporate options for label colouring permitting you to customize how labels contrast with the base map or coloured areas. Place your map to automatically adjust the label colouring depending on the base map or select your preferred colouring.
Favourites in the Hub
Mark your private or any published apps as favourite for easy entry in the hub. Favourite
apps are signed with a * icon and display in the new Favourites division. This division is visible in the hub only when at least one app is marked as a favourite.
Scatterplot now supports regression lines
The redesigned Scatterplot chart contributes greater flexibility and detail. Scatterplot now supports regression lines, as well as average, linear, exponential, and logarithmic, including as second, third and fourth polynomial. Customize the regression line settings, incorporating colour and type, vertical and horizontal fit and reveal formula to quickly see the relationship between two variables.
KPI Background colour and new icons
Now you can attach background colours to KPI charts, giving you more flexibility when customizing your visualizations. A large array of new icons has also been added to the existing icon set.
Uploading Apps with GeoAnalytics extensions to Qlik Cloud
To assist customers who are transitioning to Qlik Cloud, there is a 12-month grace period for apps that use GeoAnalytics extensions and have been uploaded to Qlik Cloud from other versions of Qlik Sense. Following the grace period, you can use the map chart in Qlik Cloud, which is faster, easier to use, has an improvement in printing and also includes more features.
Qlik Web Connectors included in Qlik Sense Enterprise Client-Managed
The Qlik Web Storage Provider Connectors are now obtainable in Qlik Sense Enterprise on Windows in the same way as in Qlik Sense Saas. The corresponding metadata connectors are also integrated, without the need for Qlik Web Connectors to be separately installed. These connectors let you connect to file-based data stored on a web storage provider, either by browsing for folders and files directly in the interface or utilising the separate metadata connectors listing the structures and objects in tables. The web storage provider platforms supported are Amazon S3, Azure Storage, Dropbox, Google Cloud Storage, Google Drive, Office 365 SharePoint, and OneDrive.
Support for uploading Oracle Wallets
The Qlik Oracle Connector now dispenses additional security capabilities with support for uploading an Oracle Wallet file. Oracle Wallets are containers that store authentication credentials, private keys, certificates, and more. This allows organizations to easily implement security rules based on defined user privileges contained in an Oracle Wallet. The Qlik Oracle Connector can now access Oracle Wallets through a TLS- encrypted communication channel.
A whole new functionalities and user interface improvements are out in the Qlik Cloud release May 2022, such as:
Chart level scripting
Chart level scripting is a new powerful feature that let users add or modify rows and columns in the dataset behind a chart. With chart level scripting, you can add script-like functionality to the results of a visualisation, including control statements such as loops and variables, and complex calculations such as simulations or goal-seeking. This allows users to manipulate datasets from the user interface.
Increased run timeout for Qlik Application Automation
In reply to customer requests, Qlik has extended the maximum execution time for Qlik Application Automation jobs from one hour to four hours. This will boost productivity by allowing developers to run longer task chains.
New templates and connector updates for Application Automation
New templates have been attached to import or export master items from or to a Microsoft Excel file: Import master items from an Excel Sheet: read master measures, dimensions and variables from a Microsoft Excel file and import them into a Qlik Sense app. Export master items to an Excel Sheet: read master measures, dimensions and variables from a Qlik Sense app and export them to a Microsoft Excel file.
New connector updates and improvements
The new Snowflake connector offers more blocks to build automations from and to your Snowflake instance and has upgraded session handling. New functionality in the Qlik Cloud connector allows interaction with Qlik Cloud data assets, sets, and stores. A new Qlik Catalog connector permits creation of automated workflows that use the metadata stored in Qlik Catalog (on-premises). Therefore, users can create workflows that synchronise metadata between various catalogues for data stewardship.
Create a new note from a snapshot
Enhancements to the Notes feature now allows users to create a new note from a snapshot of a visualisation. The snapshot is automatically included to the new note. Simply right click on a visualisation and select the new option.
Custom styling for sheet tiles
App developers can now use custom theme settings to set the background colour and gradient for sheet titles. Different colours can help users differentiate between several types of sheets, for example public, private, and community sheets. By default, the background is transparent.
Changes to JWT authorisation capabilities with cloud tenants
As of June 7, 2022, Qlik Cloud will enforce stricter controls related to JWT (JSON Web Token) authorisation capabilities with tenants. Two new attributes are being introduced to enhance the security for Qlik Cloud tenants with JWT identity provider configurations. JWT authorisation attempts to Qlik Cloud tenants made after June 6, 2022, will be denied access without these additional attributes.
Updates to scripting topics on Qlik Help
Date and time function topics have been upgraded on the Qlik Sense help site. New examples have been attached to the documentation. To view sample load scripts and visualisation examples, click on the following links:
New chart and script functions to support JSON
Updated allowlist entries for Qlik Forts deployments
There have been modifications to the IP ranges listed as prerequisites for the following fort deployments.
Support for the QVF File format was introduced already with the Qlikview May 2021 release, the QVF format will be the default file format.
The QVW file format will still work and will be the default save format for existing QVWs. If two documents have the same name but different extensions, they will share the meta and shared files. There is not yet any cross-compatibility between QlikView QVF Files and QlikSense QVF files.
The Qlikview Server services has been upgraded to NET 4.8.
Persisted Doc Admin cache
Formerly, the Doc Admin Cache was just in memory and was erased if the QMS service was restarted. Now the cache is persisted in a database.
New function for key driver analysis
The function mutualInfo calculates the mutual information between two fields.
E-mail alerts for the tasks finished with warning
Previously, the Qlikview Server have had the functionality to send an e-mail alert if any of the tasks would fail on the reload. Now we have added the new possibility to also include tasks that finished with warnings.
New option for container objects
It is now possible to hide tabs in the container object. The object will show the first non-hidden object.
Mekko chart total on top
The Mekko chart can now show totals on top of each segment stack.
Log collector tool
The Log collector tool developed by the Qlik Support has been now integrated into the QlikView Management Console.
Source Document tracking
The user document, created in a Loop and Reduce process, now contains information about the source document. The information can be found in the Document Support Information dialog.
More about Qlik Sense
Mre about QlikView