Qlik Sense May 2024 (Client-Managed) now available!

We are happy to announce the next version of our client-managed analytics offering, Qlik Sense May 2024.  This version includes improvements primarily focused on visualizations, connectivity, and the ability to preload apps.

Visualizations and dashboards

Add the Styling option to add Background Color Opacity

The color picker gets an opacity control! By adding this feature, we are making it easier to adjust the transparency of the color with the new addition and option to utilize slider functionality. Here are some use cases that you may find this feature very useful:

• Allow the sheet background to shine and make a statement along with the data you’re showing!
• Add more elegance to stacked charts

For those of you who will stick to hex codes, don’t worry – we made that easier too! Moving forward, you’ll be able to paste your codes with or without the “#” symbol.
 

Cyclic Dimensions

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.

Table Improvements

We continue to improve on the new Straight table and Pivot table because they are not only classics, but they’re also favorites!

• Straight Table
  • Smaller columns
  • URL links
• Pivot Table
  • Dimension limits
  • Measure formatting
  • Text alignment, dimension and measures values and titles
  • Null value styling measures
  • URL links

 

Button Enhancement

The following navigation enhancement has been added to the Button: “Go to Sheet: specify chart”. Check out some of the bulleted use cases below where this will come in handy:

• Navigating to a specific chart
• Single page design
• Jump to Section
• Back to top

 

Hyperlinks for new tables

Finally, you now have the options to display values as clickable links within dimension columns, for both the straight and pivot tables!

*Part of the visualizations bundle
 

Move quick sheet navigation arrows from sheet header!

When hiding the sheet title, the sheet navigation buttons will be available in the selection bar instead of being hidden.
 

Connectivity

SAP ODP Connector for Qlik Windows

Like our Qlik Cloud 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.

 

Hub & Engine

Preload Apps Functionality

Available now in Qlik Sense is the ability for customers to configure and schedule the preloading of apps! This has been a highly requested feature and rightfully so, customers can improve their end-users experience by making datasets nearly immediately available within an application (especially useful for larger apps) upon utilizing the preload functionality.

To make the management of these tasks intuitive and seamless, within the Qlik Management Console you will now find new Support options for the following: Preload Tasks: Create, Edit & Delete

 

Resolved Defects

May 2024 Patch 3

Key	Title	Description
QB-27352	Qlik sense Visualizations: Selection popup and bar is blank when using getGlobal method in a mashup	Fixed a problem where listboxes within mashups could stop working. This problem occurred specifically for mashups created using the Capability API and calling the qlik.getGlobal function.
QB-27108	Visualizations: Exporting object with styling fails	Fixed a problem where exporting any object with shadow values as an image would fail. This was solved by disabling chart shadows on server printing.
QB-25016	Qlik Sense: Issue with display scaling on Qlik Sense on Windows February 2024	Fixed a problem with scaling present on high DPI monitors.

 

May 2024 Patch 2

Key	Title	Description
QB-26558	Qlik Engine: Connector performance reload issues in Qlik Sense February 2024	The Select Statement Lineage for Sense Server has been disabled as it served no purpose in Qlik Sense Enterprise on Windows. This was causing issues with some connectors by making irrelevant calls in Sense Server.
QB-26840	Qlik Sense Engine: The <CreatorDoc> tag is empty in QVDs created with Qlik Sense February 2024	Fixed a problem where the <CreatorDoc> tag in the metadata of QVD files created with Qlik Sense February 2024 was empty, instead of showing the app ID that generated the QVD. <CreatorDoc> tags are now written from the STORE statement, even if the format spec is omitted.

 

May 2024 Patch 1

Key	Title	Description
QB-25871	Qlik Engine: Cannot reference iterator value using $() in chart script	In a chart script, the iterator in a "For… Next" loop could not be used in a dollar expansion expression. This has now been fixed.
QB-26613	Qlik Engine: Dimension created with Aggr function does not fully support selection	Fixed an issue that would cause some apps to have a limited ability to make selections in a dimension created using the Aggr function.

 

May 2024

Key	Title	Description
QB-21161	SSL setting changed after Qlik Sense upgrade	Fixed an issue where the 'Ssl Mode' setting in the repository config file changed to a blank value during an upgrade to the May 2023 version of Qlik Sense.
QB-21455	Qlik Sense Hub: Favorites icon visible in anonymous sessions	We have removed the Favorite icon for anonymous sessions.
QB-22171	REST Connector: Slow when importing large files	We have made performance improvements of file import with the REST connector for cases where a table contains a large number of columns.
QB-22519	Qlik Sense Engine: Inner set expression issue when outer set expression is present	Fixed an issue that caused the miscalculation of inner set expressions when outer set expressions were present. To apply this fix, users must add the line "AdHocFieldIgnoreOuterSetField=1" to the settings.ini file. For information on how to edit the file, see How to modify Qlik Sense Engine settings.ini.
QB-22955	Visualizations: Incorrect filter values in duplicate app	When building mashups using multiple apps, there was a risk for filters, and in some cases charts, to interfere with each other if they shared the same ID. This typically happened if the apps were duplicates of each other or if they shared the same data structure. This has now been fixed.
QB-23689	Google BigQuery Connector: Preserve the original future timestamp	This release addresses the discrepancy in timestamp conversion from the Google BigQuery connector. The fix ensures that timestamp fields containing future values are accurately represented within Qlik Sense, preserving the original future timestamp without unintended conversion.
QB-23878	Restriction of 'About' Service APIs	The APIs connecting to the ‘About’ Service have been revised and restricted for on-premises deployments of Qlik Sense.
QB-23879	Restriction of 'About' Service APIs	The APIs connecting to the ‘About’ Service have been revised and restricted for on-premises deployments of Qlik Sense.
QB-23975	Qlik NL Insights: Incorrect Dutch translation	NL Insights for "top dimensions" have been updated to the correct translation in Dutch.
QB-23999	Connectors: Fix reading of empty columns in BulkReader mode for Oracle	Queries with an empty column like "SELECT DepartmentID, '' as FakeColumn FROM AdventureWorks.HumanResources.Department;" failed for Oracle driver in Bulk Reader mode. The reason was that such columns were detected as zero column size. To fix this issue, we have extended the list of char types that override zero column size value with the default value.
QB-24347	Qlik Sense Hub: Streams not visible	Some streams were not visible when custom banner was enabled. We have made some layout changes to fix this issue.
QB-24350	Qlik Sense Visualizations: No longer possible to select several areas of the map at the same time	Clicking on one element of a slightly off-screen map would focus on the selection and confirmed it directly. This has been fixed and the map allows multiple selections.
QB-24368	Qlik Sense: Content libraries do not recognize virtual proxy prefix	Fixed a problem where it was not possible to load content library items if a virtual proxy was used.
QB-24411	Visualizations: Expression for legend label in distribution plot not evaluated	Using an expression for a legend label wasn't evaluated in a distribution plot. For this fix to take effect, the user will need to reapply the properties for the visualization to pick up the change.
QB-24430	Qlik Data Prep: Uploaded data not converted to date format automatically	Fixed a problem where the Data manager did not provide the correct date format in the script for auto concat scenario.
QB-24440	Qlik Sense: EngineHealth function in QMC stops working when TimeZone is UTC	Fixed a problem where the engine timestamp did not include a timezone offset, presenting only a "Z" instead of the expected "+0000", leading to a failure in converting the timestamp into a readable format. This update addresses a critical issue where the EngineHealth function would cease to operate correctly when the system TimeZone was set to UTC. We have enhanced the functionality within the QMC to ensure robust and accurate parsing of date-time strings across various time zone formats.
QB-24441	Qlik NL Insights: NL Insights not working on mashups on Qlik Sense Enterprise on Windows	Fixed a problem where NL Insights considered extensions as virtual proxy prefixes, causing the request to use the wrong URL.
QB-24469	Engine: Loading data from SSE plugins causes an error if no rows are loaded	Resolved an issue where engine did not build a data table if no rows where loaded via a SSE plugin.
QB-24503	Qlik Connectors: Authentication issue with Qlik ODATA connector	Fixed an authentication problem by adding a new authentication type option: BasicPreEpmtive.
QB-24504	Qlik Sense Enterprise on Windows: Unselected bars are grey on Barchart	If a type "S" hypercube has SET expressions in the measures, and a dimension is colored by another dimension, then a selection that impacts the coloring expression but not the actual dimension being colored, could cause grey colors in the chart. This was caused by the expansion of the SET expression. With this fix, the coloring dimensions are also expanded by the SET expression, getting values for all rows of the hypercube.
QB-24577	Qlik Sense Visualizations: Treemap chart color doesn't apply defined custom theme after upgrade	After upgrading to QS May 2023 patch 9, the custom theme was not applied to the treemap. This has been solved, and in cases where the color scheme does not exist, it will fall back to default.
QB-24624	Qlik Sense Visualizations: Wrong scroll position	Fixes an issue in the combo chart where the initial scroll position could be incorrect when combined with selection sheet actions.
QB-24625	Qlik Sense Engine: Access to hidden values possible through Set Analysis on dimension	Fixed a problem where the Section Access value subset was not correctly applied to fields-on-the-fly based on a single key field. This resulted in all key values being visible on the field on the fly, even if Section Access restricted the source key field.
QB-24656	Qlik Sense Visualizations: Pivot table drag dimension to column fails	Dragging dimensions to columns failed if disabled dimensions were present. This has been fixed and dragging dimensions in a pivot table now sorts correctly.
QB-24709	Incorrect translations for 'Copy\Paste style' in Swedish and German languages	Corrected Swedish and German translations for 'Copy style' and 'Paste style' in the context menu for a visualization.
QB-24802	Qlik Sense Mobile: All filter option is not displayed on iOS device	Fixed a problem where zoom on text entry was not reset, resulting in missing filter options.
QB-24906	Qlik Engine: Issues with field name when storing Parquet files	Fixed an issue with field names containing a "." character when storing Parquet files.
QB-24911	Visualizations: Some lines disappear when scrolling line charts	Fixed a problem where, for certain datasets, two-dimensional line charts sometimes failed to show all lines when scrolling.
QB-24943	Visualizations: Map chart label coloring not functional through exploration menu	Fixed a problem that caused changes to the base map and language setting when changing the label coloring for map charts in the exploration menu.
QB-24944	Visualizations: Qlik.Resize() not working in mashups	Fixed a problem where Qlik.Resize() was not working in mashups. Chart rendering on resize is now triggered when the chart starts with zero size.
QB-24957	Connectors: REST connector does not return response headers	Resolved an issue where the REST connector failed to retrieve response headers when there was no response body present.
QB-25034	Visualizations: Sheets with tables have incomplete or blank data	Fixed an issue that would cause some apps to show incomplete or blank data in some visualizations after selection operations, or in some cases, on the first rendering.
QB-25045	Qlik Sense Licensing: Cannot set offline license in Qlik Sense Enterprise on Windows February 2024	Fixed a problem that would throw an error when using offline license.
QB-25055	Visualizations: Calculation condition does not work correctly	The name of the calculated item was not displayed when the condition was not met. This has been fixed and the labels for dimension expressions are shown instead of showing an error text.
QB-25080	Engine: WHERE statement fails with Parquet files	Fixed an issue where WHERE statements failed with Parquet files if the filter field was not part of the loaded fields.
QB-25165	Qlik Sense Visualizations: Unable to add data connection throwing error 404	Resolved a degrade issue that made it impossible to create connections when using virtual proxy prefixes.
QB-25217	Qlik Data Prep: Limited field of view in the Add Data dialog in Data Manager on Chrome and Edge	When selecting a source data file, the preview window was limited to only showing one row. This has been solved by fixing a rendering problem in the Add Data Dialog on the latest Google Chrome and Microsoft Edge versions.
QB-25238	Qlik Data Prep: Unable to see scrollbar for selecting file locations	Fixed a rendering issue in the Data Manager Add Data dialog that affected the latest Google Chrome and Microsoft Edge versions.
QB-25245	Qlik Sense Visualizations: Issues with filter panes in mashups	Fixed a problem where scrollbars disappeared and filter panes moved when a popover opened. The new Listbox used a feature to prevent scrolling. This has been disabled to prevent "jumping" behavior on Windows when a popover opens.
QB-25258	Qlik Sense: Content libraries do not recognize virtual proxy prefix	Fixed a problem where it was not possible to load content library items if a virtual proxy was used.
QB-25362	Unable to rearrange sheets in touch screen mode	Fixed an issue with drag-and-drop reordering of sheets in touch mode.
QB-25384	Qlik Cloud Data Prep: Error in expressions with label name	Fixed a validation issue in the expression editor when using labels. This ensures that the expression editor is aware of existing labels when performing a validation.
QB-25504	Qlik Sense Hub: Last row of apps not fully visible on Chrome/Edge	The last row of apps was not completely visible on Chrome/Edge if there was a banner message enabled. We have made a few changes to the layout to fix this issue.
QB-25526	Error "invalid parameters" when changing tab to a Table within container	When changing the selected tab to a Table visualization within a container, an engine error called "invalid parameters" could sometimes occur. This error occurs in sheet edit mode. The issue has been fixed by ensuring the correct parameters are sent to the engine, preventing the error from occurring.
QB-25640	Visualizations: Distribution plot limitation	The message "Currently showing limited dataset" for distribution plots is now also shown when you're exactly on the limit.
QB-25644	Qlik Cloud Engine: Fields on the fly can lead to hanging errors when loading a sheet	Fixed a problem where fields on the fly introduced a recursive dependency when the state was being evaluated.
QB-25673	Qlik Sense: Error-128 shows when opening app	Fixed an internal error that would sometimes cause an error message with the code 128 to be shown when an app was opened and a bookmark applied on Qlik Sense Enterprise on Windows.
QB-25677	Databricks connector: OAuth authentication problem related to character length of connection string	Fixed an issue that caused errors in authenticating a Databricks connection via Azure OAuth. The problem was caused by a change in the character length of the connection string. The issue has been fixed by excluding OAuth tokens from connection string length validation, and additionally by providing these tokens with their own length limit of 16kb.
QB-25804	Qlik Sense: Fonts not loading in external Mashups	Fixed a problem where binary fonts were not loading on externally hosted mashups. These fonts are now loaded with authentication headers injected in the request when loaded from a cross-domain mashup using Qlik Sense Enterprise on Windows.
QB-25827	Variable description was not shown on separate row	An issue in the variable editor interface in which the variable's description was not separated from the variable name with a line break. The issue is fixed and the variable description is moved to a separate row in the cell.
QB-25897	Link to helpsite missing in topbar menu	Restored the Help link to the Qlik helpsite in the action menu (...) on the  navigation bar.
QB-26048	Qlik Sense Visualizations: Scroll bar missing from Selections tool	Fixed a problem where the scroll bar was not properly displayed in the Selections tool, making it hard to see all values in the list box.
QB-26125	Qlik Sense Engine: File lock applied when saving reloaded apps on NetApp file share	Fixed a problem with the degradation of a third-party driver that would cause the Qlik Engine to be unable to take file lock when applying changes to the App. This problem only occurred when using Qlik Sense with NetApp SMB file share.
QB-26190	Qlik Sense Engine: Section Access issues after upgrade to Qlik Sense February 2024	After the February 2024 upgrade, Section Access with dynamic data reduction would fail in some cases. When reduction fields were using numerical values, it would sometimes cause the data reload to fail. This has been fixed.
QB-26249	Visualizations: Fully expanded chart exploration panel causes a page break	Fixed a problem where the chart exploration panel would fully expand and cause a page break instead of being sized to the table. This was fixed by restricting the chart exploration to the bounds of the chart.
SHEND-1828	Qlik Sense: Updated Node.js	Qlik Sense May 2024 updates the version of NodeJS to pick up recent patches