Sense Enterprise on Windows Release Notes - November 2023 Initial Release to Patch 1

[Elisabeth-Virc-Hall]

Table of Contents

• What's new in Sense November 2023
• Resolved Defects
• November 2023 Patch 1
• November 2023
• Known issues and limitations
• Clients
• Dynamic views
• Managing a Qlik Sense site
• Qlik Sense Desktop
• Connectors
• Cloud deployments and Multi-Cloud
• System requirements notes
• Downloads

The following release notes cover the versions of Qlik Sense Enterprise on Windows released in November 2023.

For questions or comments, post in the Product Forums or contact Qlik Support.

What's new in Sense November 2023

Please refer to the What’s new sections of the online help for information about the new and updated features of the Qlik Sense Enterprise on Windows November 2023 release:

What's new in Qlik Sense November 2023 (Users)

What's new in Qlik Sense November 2023 (Developers)

What's new in Qlik Sense November 2023 (Administrators)

Resolved Defects

November 2023 Patch 1

Key	Title	Description
QB-21103	Qlik Engine: Variable definitions are unexpectedly changing during an interactive reload	If a variable was created as an app object (not in script) and a user changed the value of the variable within their session, for example by using the variable input control in the Qlik Sense user interface, and the user then reloaded the app in the same session, the definition of the variable would change to the value in the user's session. This scenario would typically occur during app development, since it requires user-triggered interactive reload, with the same user working in the app, in the same session. This fix ensures that the definition of a variable is always maintained unless it is explicitly changed by an app designer or in a load script. The in-session value of the variable is independently controlled.
QB-22968	Qlik Sense: External call to fonts.googleapis.com	The font Qlik Sense loads when the application starts is now loaded from Qlik Sense's own web resources. This means that external calls are no longer made.
QB-22161	Qlik Sense Hub: Blank space appears in the Hub when app menu is opened	Fixed an issue where a blank space was displayed at the bottom of the screen in the Hub when the app menu was opened using right-click.
QB-22497	Qlik Sense Visualizations: Hyperlink in table not working on Qlik Sense August 2022 IR	Fixed a problem where opening a URL from a table would cause the link to have a port attached to the URL. This went against the browser's origin restriction, meaning the iframe didn't show. This was solved by adding a "noopener" to the opening of the link.
QB-22217	Qlik Sense on Windows: Bad request error when connecting to websocket for some formats of headers	This issue affected Qlik Sense on Windows August 2023 Patch 2. A "400 Bad request" error was thrown when connecting to websocket if multiple comma-separated valid headers were entered without entering a whitespace after the comma. This has been fixed and header values are now allowed without whitespaces.
QB-22155	Qlik Sense: Fail to open Data Load Editor in new tab	The routing was redirecting to a non-existent HMTL file, causing the failure to open the Data Load Editor in a new tab. This fix corrects the routing.
QB-22849	Qlik Sense: Dashboard variable input has inconsistent behavior	Fixed a problem where the variable input from the dashboard bundle added an extra option to the dropdown. This extra option was confusing and has now been removed from the dropdown options. A new hidden option has been added that will allow selection of any option in the dropdown when these do not match the current value of the variable.

November 2023

Key	Title	Description
QB-17864	Visualizations: NPrinting reports do not keep original theme background	NPrinting theme with cards was showing a white background. This has been solved and the background is grey with a border visible around the cards.
QB-19282	Front-end validation and Regular Expression enhancement for 'Custom filter' in 'Custom' schedule of a trigger	Implemented front-end validation for 'Custom filter' in 'Custom' schedule of a trigger to avoid invalid data submission. Also added regular expression checks to ensure the correct format of the custom filter input, including minute, hour, weekdayPrefix, weekday, weeklyInterval, day of month, month, and monthly interval. Users can see real-time feedback on the validity of their input in custom filters, reducing the occurrence of scheduling errors.
QB-19290	Fixed err,or related to "Multiple files not allowed"	User can now upload new file with same name or different name and connection will be updated based on content on new file.
QB-19335	Visualizations: Accessible headings	Sheet title is now marked as Header <h1>, and the title and subtitles of the objects on the sheet are marked as <h2> and <h3>, respectively.
QB-19432	Qlik Sense Visualizations: Sheet image and sheet title are not accessibility compliant	Sheet image and sheet title were not accessible by tab and the image did not have any descriptive text. This has been fixed and both the sheet title and sheet image can be accessed by tabbing and the logo has descriptive text.
QB-19433	Hide button label to allow for accessibility	It is now possible to hide a Button object label while keeping a label text, which leaves the label text as a screen reader-only label for the button.
QB-19571	Enterprise Connectors: Unexpected behavior in the data preview for the Oracle connector (ODBC connector package)	Fixed a problem where the data preview did not show all the available tables in the select dialog for the Oracle connector.
QB-19712	Visualizations: "Indent rows" not working on pivot table when Hebrew is added	When the app was in RTL mode, the text in the pivot table would not properly align with the "indent row" options enabled. This has been fixed and text alignment is now correctly handled.
QB-19860	Visualizations: Issue with label contrast	Introduced a new setting for automatically adjusting labels inside bars to get a better contrast.
QB-19896	Qlik Sense Hub: Visible blank space in the Hub when app menu is opened	Fixed an issue that displayed a blank space at the bottom of the screen in the Hub when the app menu was opened using right-click.
QB-19914 (linked to QB-22702)	Qlik Sense Visualizations: Keyboard navigation to selections menu does not work	It is now possible to use the keyboard navigation to access the selections menu when activating selections in the straight table.
QB-19943	Visualizations: Background images not always showing in exports	There has been a delay when loading a button's background image when preparing to be reported via reporting causing the image to not be exported in some cases. The time gap is now adjusted so the button's background image is loaded before being downloaded as an image or PDF.
QB-19992	Visualizations: Difficult to see navigation arrows	It was difficult to see the quick navigation arrows on an app sheet if the background was dark. The arrows now have a light color on dark backgrounds.
QB-20005	Visualizations: Value labels not visible in Waterfall charts with dark colors	Value labels are now visible if a dark color is used in Waterfall charts. When you use a dark color, the value label color will change to make them visible.
QB-20064	Visualizations: Scroll hint indicator incorrectly displayed	Fixed an issue where scrollable charts showed the scroll hint indicator even when further scrolling was not possible.
QB-20138	Confirm selection	Confirm ongoing selection in a chart by clicking outside of the chart would freeze the chart.
QB-20282	Visualizations: Straight table search option not showing listbox	Fixed a problem where the listbox for searching and selecting was not opening when clicking on the search option in the header menu.
QB-20292	Generating ODAG app and publish to stream	Generating ODAG apps and publishing them to a stream didn't work for any user IDs with spaces in them. This is now resolved.
QB-20321	Alternative dimensions and measures	Improved accessibility of alternative dimensions and measures.
QB-20326	Use connection name for "Select data from source" in Data Manager	For "Select data from source" we need to look up by connection name to be more consistent with Data Load Editor. After an upgrade, the connection ID no longer matched which caused issues trying to add the data from source in Data Manager.
QB-20478	Prevent flickering scrollbar and item displacement when dragging sheet or story items	When the container with sheets or stories was close to overflowing, the scrollbar was flickering. On browsers rendering a thick scrollbar, this sometimes lead to a displacement of subsequent items. This has been fixed through a CSS style change of the containers and should now work as expected.
QB-20521	Qlik Sense Operations Monitor: Incorrect master dimensions	The Operations Monitor app was displaying the "Incomplete visualization" error due to inexistent dimensions. Three master dimensions have now been removed as these did not exist in the data model.
QB-20549	Qlik Enterprise Connectors: Amazon Athena returns incorrect value when using useBulkReader	When using useBulkReader an incorrect value for $file_modified_time was returned. This has been fixed and now the correct value is shown.
QB-20586	Border option in Container	The Border option for Container objects did not work after the February 2023 release. This is now fixed.
QB-20587	Qlik Sense Engine: The engine crashes when merging tables in the load script	Fixed a problem where the engine would crash when merging tables in the load script by resizing the ColGenerationCounters array to avoid access violation exceptions.
QB-20591	Prevent duplicate expression in master dimension	It used to be possible to add duplicate expressions in a master dimension. Users are now prevented from adding duplicate expressions to a master dimension and notified that this is not possible.
QB-20614	Storing data containing null values into parquet file created a faulty file	Storing data that contained null values into a parquet file created a file that when loaded would throw an error: "Cannot open file: 'Failed to read column' (: Malformed levels. min: 0 max: 254 out of range)". Null values will now be handled correctly when storing data into parquet files.
QB-20783	Buttons with fixed layout	It is now possible to place a space between icon and text in buttons with fixed layout.
QB-20802	Qlik Engine: Telemetry logging does not work with 2 GB ErrorPeakMemory or more	Engine setting size for ErrorPeakMemory and WarningPeakMemory were upgraded from Int32 to Int64.
QB-20824	Straight table Select All function issue	The inline listbox in table header cells would not work for master dimensions.
QB-20860	Qlik Sense: Analyzer capacity minutes not consumed as expected	Fixed the way Analyzer capacity minutes are consumed. The minutes are consumed per user session.
QB-20866	Bookmark set expressions are not working as expected	Fixed issues with bookmark set expression: - A field without selections that does not match database records does not cause extra commas in the set expression. - The set expression in a field in a bookmark is not limited by 1000 selections in a datamodel field, but by the actual bookmarked selections.
QB-20885	Scheduler failure with a trigger with incorrect filter in one of the scheduled tasks	Scheduler failed to execute all scheduled tasks due to the presence of a trigger with an incorrect filter in one of the scheduled tasks. This issue is fixed by identifying the trigger with an incorrect filter, disabling it, and removing it from the scheduler's memory to avoid future executions of the task. With this fix, other tasks will continue running as per their schedule.
QB-20910	Visualizations: Changed position of selection toolbar in table	We moved the selection toolbar from the top-right corner of the table to the column where the user makes the selections.
QB-21015	Variable input extension	Variable input extension was reverted to the previous version to fix unintended changed behavior.
QB-21045	Geoanalytics: Tooltip is stuck to a fixed position when scrolling the page	The tooltip in a geo-mapchart would get stuck when hovering over a data point and then quickly moving the cursor outside the geo-mapchart. This has now been fixed.
QB-21051	Straight table in alternate state	Straight table, available in the Visualization bundle, is now respecting alternate states when making selections through the listbox in the header.
QB-21095	Visualizations: Tooltip information not visible when the cell is extended in size	When the screen area is fully covered, the tooltip information will not default to the top and instead will be shown in the center of the object.
QB-21109	Visualizations: Thumbnail of sheet was cut off on Sheets menu	Fixed an issue where sheets and bookmarks were not completely visible in the navigation popover viewed from a sheet.
QB-21110	Visualizations: Title and image not properly aligned on sheet	Fixed an issue where the sheet title was styled as header h1 wich changed the the CSS styling. Correct CSS classes have been implemented and the title and image are now aligned as expected.
QB-21153	Qlik Engine: Issues with pivot table introduced in early 2022	When a pivot table has both Left and Top dimensions, rows would disappear (wrongly suppressed) when group sums were 0 or null. A fix was applied to not suppress group sums that resulted in 0 or null when dimensions in a pivot table are placed on top.
QB-21206	Combo chart issue	Fixed an issue where combo chart did not show bar value labels for null values.
QB-21242	ODAG crashing or getting stuck when canceling an app reload	When canceling an ongoing ODAG link reload, the ODAG service would crash or in some cases the reload would get stuck in canceling state for a long time.
QB-21263	Qlik Sense: Updated Node.js	Updated Node.js. For more information, see https://nodejs.org/en/blog/vulnerability/august-2023-security-releases
QB-21270	Qlik Sense Insight Advisor: Not working on externally hosted mashup	We have resolved the license error that previously limited the use of Insight Advisor Chat outside the Qlik environment. With this latest release, Qlik developers can now host the Insight Advisor chat outside the Qlik environment for their users. This change allows for a seamless and extended integration of the powerful Qlik Insight Advisor Chat into various external platforms, providing even greater flexibility and utility.
QB-21358	Visualizations: Date column is exported as numbers in Excel	When downloading the data by selecting "table formatting", the date column is exported as numbers in Excel. This has been fixed so Excel exports now support formatting for timestamp fields.
QB-21429	Qlik Sense Engine: Data load from CSV picks up extra values	Fixed a problem that caused a whitespace (space or tab) after a delimiter to disable MSQ interpretation on Qlik Sense Enterprise on Windows.
QB-21437	Qlik Sense: Improved HTTP Request validation	Implemented additional validation logic when processing HTTP Request body.
QB-21469	Qlik Sense: NL Insights not honoring virtual prefix	When logging in using a virtual proxy with a prefix, NL Insights was not working. This has been fixed and it is now possible to use the NL Insights extension while using a virtual proxy with a prefix.
QB-21497	Qlik Sense Enterprise Connectors: PosgreSQL connector cuts off strings	The Qlik Sense PosgreSQL connector now supports loading strings containing more than 255 characters.
QB-21539	Insight Advisor: Issue when using Custom analysis with 2 dimensions and 2-3 measures	Resolved an issue where charts were not displayed as expected when using Custom analysis on a pivot table with two dimensions and two to three measures.
QB-21549	Qlik Sense: The Hub does not redirect if a stream with no access is directly accessed	Fixed a problem that caused endless loading of streams of links with no access instead of redirecting to the first visible stream or My work area.
QB-21561	Qlik Sense: Proxy web cache poisoning	Implemented additional validation to prevent poisoning of the Proxy web cache in Qlik Sense Enterprise for Windows.
QB-21642	Qlik Sense: Hub stuck in loading state when F5 key is used while in "Search" mode	When using "Search" mode in the Hub, if a user pressed the F5 key to refresh the page, the Hub would not properly reload and would get stuck in a loading state. This has now been fixed.
QB-21662	Visualizations: Data point errors when converting from line chart to combo chart	After converting a line chart to a combo chart, the chart applied line chart-specific measure styling which caused some of the data points to become enlarged and unable to be adjusted. This issue has been fixed.
QB-21676	QlikView: Access-Control header contains a wildcard	The Access-Control-Allow-Origin header for QlikView Converter contained a wildcard. This has now been fixed.
QB-21683	Qlik Sense: Improved validation of Transfer-Encoding Headers	Added additional validation to the Qlik Proxy to ensure only valid Transfer-Encoding headers are passed on.
QB-21730	Qlik Cloud Engine: Degradation in the DefaultMissingAggr wrapping	Fixed an issue in the DefaultMissingAggr wrapping and IsConstant has been changed to apply only in the InPeriod implementation.
QB-21731	Qlik Sense: Added validation to X-Qlik-* HTTP headers	Additional validation performed by the Qlik Proxy to ensure only valid X-Qlik-* HTTP headers are passed through.
QB-21792	Qlik Sense Visualizations: Unusable search functionality on mobile devices	Fixed a problem that caused users to be trapped inside an expanded list box on iOS. This was solved by adjusting the positioning of the pop-over on the list box on mobile devices, and resetting the browser zoom after the pop-over opens.
QB-21812	Qlik Sense Visualizations: Cross-site mashups not fetching JavaScript resources	Fixed a problem that prevented mashups hosted on a different domain than the Qlik Sense Enterprise installation from fetching JavaScript resources from the servers, even though users were logged in and cookies had been set. Resource requests now add credentials when it is required.
QB-21839	Qlik Sense Visualizations: Dragging dimension to pivot table fails when disabled dimensions exist	Fixed a problem that prevented moving pivot table dimensions past hidden dimensions. Previously, moving past a hidden dimension from left tree to top tree would not move the dimension and instead, it would move one of the hidden dimensions.
QB-21856	Qlik Sense: Straight chart exploration feature is missing	Fixed an issue where the straight table had no chart exploration feature.
QB-21908	Duplicated tick labels on scatterplot charts	Fixed duplicated tick labels on a scatterplot chart axis due to formatting.
QB-21918	Qlik Sense Visualizations: Scale of line and combo chart is sometimes incorrect	Fixed an issue that caused the scale of the line and combo chart to sometimes be incorrect when the minimum and maximum values were close to each other.
QB-22000	Data load editor: Data model viewer preview not showing table comments	Fixed an issue where table comments added via the "comment table" statement in the data load editor were not visible in the Data model viewer.
QB-22050	Insight Advisor: Data value lookup does not work with master dimension	This fix includes master items in the data value search.
QB-22125	Qlik Sense Visualizations: Selection bar not shown in Container when "Position: fixed"	Fixed an error that prevented the selection bar from showing when "Position: Fixed" was set for a container in a Mashup. This affected Sense May 2023.
QB-22238	Qlik Sense Engine: Quoting style not used in header calculations	Fixed a problem where MSQ Quoting Style was not correctly working with CSV delimited files.
QB-22334	Qlik Sense Enterprise on Windows: Import of apps larger than 2 GB fails	Due to recent security fixes, the upload functionality stopped working for files larger than 2 GB. This has now been corrected without compromising on security.
QB-22346	Visualizations: Filter pane disables view of dimension item on far right of the filter pane object	Fixed an issue that would hide a column item when rendering multiple columns and the Filter pane height was small.
QB-22702 (linked to QB-19914)	Qlik Sense Visualizations: Cannot search in listbox	Fixed a problem where searching in listbox was not possible. The new release has the correct behavior.
QB-22833	Mashups: Mashups cannot load correctly if require.js is loaded with jquery	Loading require.js using a method other than a script tag, would cause the mashup to not load correctly. This has been fixed so the "isMashup" check works properly in all situations.
SHEND-1154	Qlik Sense: Installed components on the server are displayed	The lists of Qlik Sense components (with versions) and third-party software components (without version) have been moved from the About dialog in the Hub to the Qlik Management Console (QMC). Versions of Qlik Sense components have also been removed from the product-info.json file.
SHEND-1293	Qlik Sense: .NET core update	Updated .NET core 3.1 to .NET 6 LTS for app-distribution-service, hybrid-deployment-service, dotnet-core-service-utils, and qdc-catalog-service.
SHEND-1368	Qlik Sense: Generic error message for invalid licenses	Licenses can be invalid for a number of reasons. We have improved the description in the error message for invalid licenses so users can take appropriate action where necessary.
SHEND-1390	Qlik Sense: Update to custom banners	Updated custom banner messages to support hyperlinks.
ODCB-1237	Qlik Sense: Unauthorized Access to "QDC Catalog Service Configuration" API	A non-admin, unauthorized user (such as an analyst) could directly access the API used to populate the "QDC Catalog Service Configuration" management console user interface after login to the Qlik Sense Hub. This is the user interface used to configure the Qlik Sense to Qlik Catalog integration. If the integration had been configured, the saved information, including credentials, was returned to the unauthorized user. With this fix, an HTTP status code of 403 Forbidden is now returned when an unauthorized user directly accesses the API. 403 Forbidden has always been returned when an unauthorized user accesses the "QDC Catalog Service Configuration" management console user interface. NOTE: Upgrading Qlik Sense may clear settings from the "PostgreSQL Server" and "QDC Server" tabs. Make note of the settings prior to upgrade and re-enter the data if necessary.

Known issues and limitations

The following issues and limitations were identified at release time. The list is not comprehensive but lists all known major issues and limitations.

Clients

• Third-party extensions are currently not supported on mobile devices, and the Qlik Trusted Extension Developer program does not accredit extensions for use on mobile devices. Generated items might not be visualized properly on a mobile device, depending on individual device specifications, mobile OS, and the size of the Qlik Sense app.
• When you consume Qlik Sense apps using the Microsoft Edge browser on touch/hybrid devices, the long-press action does not work. This prevents you from accessing functions such as an object’s context menu, which requires a long press in touch mode. This is a Microsoft Edge issue.
  Workaround: If you use a hybrid device, turn off touch mode, and then turn it back on again.
• Export as Anonymous does not work for mashups deployed in a domain that is different from the domain where Qlik Sense is installed. Export only works for Anonymous if the mashup is deployed in the same domain as Qlik Sense.
• When using the new Load Extension syntax in the load script, the Data Load Editor syntax completion does not work well after the keyword “Extension” when trying to write the call to an SSE function (AAI function). The script still executes correctly.
• Legend does not show dimension values after row number 3000.
• Limitations when exporting a story to PowerPoint:   
  • Titles are not rescaled as HTML. Font settings are not exported.
  • Storytelling effects are not applied.
  • Exported charts might show fixed scroll bars, depending on the export resolution.
• It is not possible to open the context menu of an org chart on a touch device.
• When you choose to view data in the context menu in a dynamic chart and make a new selection in the app, you need to refresh the browser for the chart to be displayed again.

Dynamic views

• Dynamic views that you delete from one app are also deleted from every other app that was using the same view. There is no workaround for this issue. Avoid deleting views that might already be in use by other apps.
• When you create a new dynamic view in the assets pane, the dropdown menu item does not automatically change to show the charts of the newly created dynamic view if there are any existing dynamic views. You must click on the dropdown menu to choose the newly created view.
• The data for a dynamic view is automatically refreshed whenever you open a sheet that contains charts for the view. The same happens when you enter and then return from the global selections pane, and when you add a new chart for the view. Refrain from performing these actions on the base app to prevent triggering refreshes.
• The view of a dynamic chart is cleared and shows a message indicating a view constraint violation whenever you change the selection state of the base app in a way that violates the view's constraints. Refrain from changing the selection state of the base app until it has finished making use of the data in any of the dynamic view charts.
• The ‘Go to source’ option on a snapshot slide (available on right-click) for a dynamic chart does not select the actual dynamic chart when you change the view to the base app sheet.
• Changes to chart settings for dynamic view charts using the Exploration menu are lost after refreshing the view.
• Dynamic views do not support the Trellis extension.

Managing a Qlik Sense site

• The Edit pane under Custom properties in the Qlik Management Console (QMC) can currently handle a limited number of custom properties. If you want to edit custom property values in the QMC, we recommend keeping the number of custom property values to a maximum of 500. If you want to apply values without modifying them, the QMC can handle up to 10,000 custom property values.
• When you remove app objects from an application via the QMC interface, deleted objects are not removed from the application’s binary file stored on the file system.
• It is not possible to use a security rule on the HubSection_* resource to hide the ‘Open hub’ link from the navigation menu when accessing an app as an anonymous user.  
  Workaround: Use reverse proxy to redirect the ‘Open hub’ link to a preferred landing site.
• Windows service Qlik Engine cannot be started on a node where the Qlik Engine service is disabled through the QMC. Every time Windows restarts for that node, the Qlik Engine service fails to start up and throws an error in Windows event logs. You can prevent this by temporarily disabling the Qlik Engine service in Windows Service Manager.
• Data connection passwords containing special characters (such as "=", "%", or ";") are not properly encoded when updated via the QMC. This causes authentication errors when trying to connect to specific data sources, which could cause reload tasks to fail.  
  Workaround: Use the data load editor to update the password. Note that once the password is updated, the name of the data connection is automatically appended by "(domain_userId)". You can adjust this later via the QMC.

Qlik Sense Desktop

• Qlik Sense Desktop can play WebM and Ogg but not MP4 files. This is due to limitations in Chromium.

Connectors

• REST connector: The ‘Next token’ pagination option does not work when the pagination token has the same value for each page.
• For connectors in the ODBC Connector Package only the data types listed as supported in the online help have been verified to work correctly in the Preview and Script editor. However, the ODBC Connector Package does not prevent you from loading other data types. In some cases, you can load unsupported data types with the load script.
• ODBC connector: Database connectors in the ODBC Connector Package do not work properly if the username on the Microsoft Windows system running Qlik Sense Desktop contains letters that are not English alphanumeric characters.
  Workaround: Change the Windows system locale to match the character set that contains the characters used in the username. For example, if the system locale on the system running Qlik Sense Desktop is set to English and a username contains Swedish characters, you must change the system locale to Swedish for the ODBC connector to work properly.
• The Qlik Salesforce connector does not support PK chunking on sharing objects. PK chunking is only supported on parent objects.
• The Apache Phoenix connector does not support non-Latin characters in metadata. The connector might return corrupted data or unpredictable query results if you run a query with non-Latin characters in metadata, such as table names, column names, and aliases.

Cloud deployments and Multi-Cloud

• When you download a pivot table in Qlik Sense Enterprise SaaS, expanded rows are not included but stay collapsed.

System requirements notes

For information about the requirements for Qlik Sense, see System requirements for Qlik Sense in the online help.

Downloads

Download this release from the Product Downloads page on Qlik Community.

About Qlik

Qlik’s vision is a data-literate world, where everyone can use data and analytics to improve decision-making and solve their most challenging problems. A private SaaS company, Qlik offers an Active Intelligence platform, delivering end-to-end, real-time data integration and analytics cloud solutions to close the gaps between data, insights and action. By transforming data into Active Intelligence, businesses can drive better decisions, improve revenue and profitability, and optimize customer relationships. Qlik does business in more than 100 countries and serves over 50,000 customers around the world.

qlik.com