Qlik Sense Enterprise on Windows Release notes - November 2020 Initial Release to Patch 19

[frida_tell]

Table of Contents

• What's new in Qlik Sense November 2020
• Resolved Issues
• Known issues and limitations
• Upgrade notes
• System requirements notes
• Downloads

The following release notes cover the versions of Qlik Sense released in November 2020. Solved issues and limitations for Qlik Sense Enterprise on Cloud Services are also listed.

What's new in Qlik Sense November 2020

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 2020 release:
What's new in Qlik Sense November 2020
What's new in Qlik Sense November 2020 (Developers)

November 2020 Patch 10
Cross-site scripting (XSS)
A cross-site scripting (XSS) issue, caused by improper validation of user-supplied input, has been identified in Qlik Sense Enterprise and Qlik Connector for use with SAP NetWeaver. This could lead to arbitrary JavaScript being executed in the context of a user if they visit a malicious page or link controlled by the attacker. Please read here https://community.qlik.com/t5/Knowledge-Base/SB-Cross-site-scripting-XSS-vulnerability-in-Qlik-Sense... for further details

November 2020 Patch 9
Delete functionality for Qlik Sense Enterprise Client Managed distributions to Qlik Sense Enterprise SaaS deployments removed
There will no longer be a synchronization attempt towards Qlik Sense Enterprise SaaS if a distribution policy has been changed from evaluate to false, or an app has been deleted on Qlik Sense Enterprise Client Managed.

November 2020 Patch 3
nl-app-search is disabled by default
nl-app-search is disabled by default. For insight advisor chat in the hub, customers who have a license for the feature needs to enable the nl-app-search service in service.conf (delete the Disabled=true line) and restart the ServiceDispatcher

For the upgrade notes, refer to the “Upgrade notes” section in this document.

Resolved Issues

November 2020 Patch 19

Key	Title	Description
SHEND-663	Updated NodeJS version	This patch for Qlik Sense updates the version of NodeJS to address several security vulnerabilities announced by the NodeJS project.
QB-6992	Loss of application changes after app had been opened without data and reloaded in Data load editor	Loss of application edits was possible when a user session against an app had changed between open modes "with data" versus "without data". This happened if an end user would open an app without data and then reload the app from the Data load editor.
QB-3899	KPI gets correct colors	Added smallPalette to the KPI to make sure the color picker uses the default color.

November 2020 Patch 18

Key	Title	Description
QB-6619	Loss of application changes was possible when auto save operations took time	Engine auto-saves all user edits continuously, but also when a session is closed. Sometimes, there can be delays in the auto-save operation because of overall load either on the Qlik software or on database and file systems. A software error made it possible for an intermittent delay in the auto-save operation on session close to affect a newly opened session for the same user on the same app in such a way that the newly opened session would never be auto-saved. This situation could occur on a web browser refresh or any kind of network issue that led to rapid closure and re-establishment of the websocket connection from Qlik Sense client to Engine.
QB-6329	Bar chart color	Fix coloring when the mini chart scroll position starts at the end.

November 2020 Patch 17

Key	Title	Description
QB-6333	Flex box issue in Safari	A workaround to avoid a third party issue.
QB-5558	Fix app are not showing correctly on iPhone	Fix objects height are not showing correctly on iPhone

November 2020 Patch 16

Key	Title	Description
SHEND-567	Improvements to Search feature in the Hub	With a large number of applications in the Hub, the performance of the Search feature could be significantly impaired. This functionality has now been improved but for this release it is by default disabled. It can be enabled by adding a corresponding capability flag in C:\Program Files\Qlik\Sense\CapabilityService\capabilities.json file, in example: {"contentHash":"2ae4a99c9f17ab76e1eeb27bc4211874", "originalClassName":"FeatureToggle","flag":"HUB_OPTIMIZED_SEARCH", "enabled":true} New search algorithm relies on the results from /hublist/myspace request evaluated upon accessing the Hub space. It guarantees significant improvement in performance, provided the aforementioned API request has completed before the first search is made. It is also important to note that no more than 50 apps are displayed in the search results, event if there are more hits returned from the query.
QB-6290	Update logged ProxySessionID if the proxy attaches with a new ID	The engine session always logged with the initial ProxySessionID, provided by the proxy when the session was created. This ID could become irrelevant or confusing if successive proxy sessions attached to and detached from long-lived engine sessions, e.g. through TTL. The engine now updates the associated ProxySessionID if a new one is provided upon session attach. The update is recorded in the engine log.
QB-2683	Include credentials when fetching file for Sense Client	In some scenarios it was seen in the network logs that a file (product-info.json) could not be fetched due to missing credentials, this should now be fixed.

November 2020 Patch 15

Key	Title	Description
QB-5516	Fix for NLU Info for cases where dates turn to numeric values	On asking questions with measures, a filter, and a time filter in NLU info the time filter was converted to numeric values rather than valid dates. This issue has been resolved in this fix.

November 2020 Patch 14

Key	Title	Description
QB-5673	Fix broken build not generating all web content	Fix broken build not generating all web content
QB-5419	Fix for Insight Advisor property change issue for alpha-numeric filter value which ending with number.	On Insight Property change in IA, filter value with alpha-numeric value ending with number was being converted to its numeric equivalent and hence producing incorrect selection.
QB-5347	Shortening of softpatch sets corrected	Algorithm for shortening softpatch sets has been corrected, affecting e.g. moving columns in certain tables.

November 2020 Patch 13

Key	Title	Description
SHEND-500	New KeepAlive option to repository DB notification handler.	Due to network instabilities repository service could sometimes loose the connection on the database notification handler. Repository service was unaware that the connection has been lost and therefore did not make any attempts to renew it. In order to avoid this from happening a KeepAlive option has been added to force a connection check at the given intervals. This is controlled via newly introduced key in C:\Program Files\Qlik\Sense\Repository\Repository.exe file and by default set to 60 seconds: <add key="DatabaseChannelReceiverKeepAlive" value="60" />.
SHEND-495	Minor updates in connection session settings for Advanced LDAP UDC.	Logic behind the two following Advanced LDAP flags has been slightly improved: • nocertverify - skips server certificate validation • certdebug - debug level on certificate chain validation errors, if any, for troubleshooting.
QDCB-1010	Sense use correct cookie to connect QDC	Sense setup QDC connection save the encrypted credential to database. Sense now used decrypted credential to create cookie and connect QDC instead of using encrypted credential.
QB-5663	Fix persistent storage path in precedents-service	Use custom storage path if one was provided by the user in the installer.
QB-5120	Avoid intermediate results causing invalid json from expression	Intermediate results are not returned for some evaluated expression, which previously caused some charts to fail to be displayed.

November 2020 Patch 12

Key	Title	Description
QB-4579	Reload tasks get stuck in QMC randomly	Further improvements to prevent reload tasks from getting stuck. Added mechanism for timeout end retry for repository accesses. New timeout logic does not affect retrieval of all tasks on a startup of the scheduler service. Disabled by default, to enable modify "C:\Program Files\Qlik\Sense\Scheduler\Scheduler.exe.config" file with "<add key="DisableRepositoryAccessTimeoutMechanism " value="false"/>".
QB-3179	Fixed by upgrading Oracle driver	Upgrade Oracle to 1.4.9.1009 fixed the issue

November 2020 Patch 11

Key	Title	Description
QB-5320	Charts missing from Visualization bundle	The Bar & Area chart and Bullet chart are missing from the Visualization bundle. They are still available on sheets, but cannot be created from the assets panel.
QB-3989	Address layout issues with longer errors in expression editor	Improved layout for expression edit to allow scrollbars for longer error messages.

November 2020 Patch 10

Key	Title	Description
QB-4205	Address issue where data model viewer layout not being remembered	Fix the issue where user re-arranged data model viewer tables location/layout are not being remembered by the client.
QB-3924	Qlik Sense: High memory consumption when loading a pivot table	When the customer expanded a pivot table (ExpandLeft), it took a long time and RAM usage increased with 25 Gb before the table was expanded. The RAM went back to normal level after the pivot table was expanded.
QB-3742	Fix the bug where tooltip was showing unnecessary information	Fix the bug where tooltip was showing unnecessary information. This was happening due to the tooltip not being re-rendered when moving away from the incision between areas
EN-3074	Open app slow when having lot of bookmarks	Generic performance improvement around loading of available bookmarks during open app.

November 2020 Patch 9

Key	Title	Description
QB-4369	Community app objects are not included when distributing an app from QSEfW to QCS	Fixed the behavior where community objects were not available on the app after distribution from Qlik Sense Enterprise Client Managed to Qlik Sense Enterprise SaaS, for example published sheets are now available in Qlik Sense Enterprise SaaS.
QB-4321	Engine sessions not always closed when user exits application	Fix to sense client to no longer send an openDoc request to the data prep service prior to the user entering data manager. This resulted in the failure of a web socket connection to be created causing engine sessions not being immediately closed. This would result in user selections not being reset when the application is reopened.

November 2020 Patch 8

Key	Title	Description
QB-2662	MS Teams/Slack Integration with Insight Advisor Chat hosted on Azure Server not working	When Qlik Sense Server is installed on Azure Servers, Integration with Microsoft Teams or Slack is not working because of local certificates being used. Also, communication is happening over dedicated port 4954 which is no more needed now as communication will happen through Qlik Sense Proxy.
QB-2625	Date Picker: Not displaying correctly.	This degrade is a result of introducing scrollbar. Note : The scrollbar has been removed and Date picker displays together again.

November 2020 Patch 7

Key	Title	Description
QB-3907	Optimized memory management during user synchronizations	The Repository service now consumes less memory during user synchronization. Previously such synchronizations could cause a large temporary increase in the size of the repository process in large installations of Qlik Sense.
QB-3329	Added support for DTD header in XML file	Support for DTD header with internal document definition Support for DTD header with document definition in URL
QB-2938	NPrinting: Variance Waterfall chart sometimes blank in pptx	Waiting for variance waterfall to be completely rendered before signal is returned to NPrinting that rendering of charts is done

November 2020 Patch 6

Key	Title	Description
QDCB-862	Fixed oversize request header by add a filter for the connectionGUIDs	a connectionGUIDs filter is added to resolve the oversize request header that send to QDC
QB-3638	KPI: Fixed errors when updating selections quickly	Increased robustness of the animation algorithm for the KPI
QB-3237	Container object: Enable link/unlink context menu option	Enable the option to link and unlink objects, that are in a container object, from the context menu of that visualization
QB-2904	Data Model Viewer sometimes opens instead of Data Load Editor	In some cases clicking the navigation menu to open the Data Load Editor would instead navigate to the Data Model Viewer.

November 2020 Patch 5

Key	Title	Description
QB-3379	Mashup objects error message text is not rendered from client.json sometimes in IE11	Translator needs to be loaded to make sure we can translate the text. For mashups this is not always the case. When error is thrown we will now wait until the translator is started before we show the message on the screen

November 2020 Patch 4

Key	Title	Description
QB-3361	Lots of Windows event logs with message: ERROR: null value in column "payload" violates not-null constraint"	This fix avoids indirect logging by a third-party library (SuperSocket), these logs were intercepted by the Sense logging framework, which tried to record a null value in a database not-null column, generating system event logs like: This "2020-12-07 21:23:42 UTC ERROR: null value in column "payload" violates not-null constraint 2020-12-07 21:23:42 UTC DETAIL: Failing row contains (61682991, 2020-12-07 21:14:59.132874+00, DEBUG, 3, QlikSensePrintingWebSocketProxy, AMZCLTVQS02, printing, 26308, null). While the Sense functionality is not affected, the system logs are flooded with new entries. The third-party library logs have been suppressed.
QB-2993	Filterpane objects inside container not displayed correctly	Having multiple filterpane objects inside a container might cause that some of those objects are not visible or partially visible in the container object.
QB-2878	Physical keyboard is forcing bookmark close	With a physical keyboard on an iPad the screen resizes when focus is on an input field. The device will show a small bar on the bottom. This fix makes sure that the popup is not closed when the screen is resized for apple devices
QB-2343	Two-dimensional line chart incorrectly showing gaps in lines	Fix for an issue where a two-dimensional line chart with "Missing values" set to either "Show as gaps" or "Show as zeroes" in certain cases incorrectly showed gaps where data points existed

November 2020 Patch 3

Key	Title	Description
QDCB-760	What's new in version 0.17.0	What's new: - add security certificate path when QDC is https enabled - update the NuGet baseline from 1.5.0 to 2.1.0
QB-3069	Unable to create SessionApps with SessionApp custom rules	Fixing a problem where Engine never sent SessionApp meta data to Repository for rule evaluation.
QB-2782	Publish and replace not working as expected	Publish replace don't work towards the QRS if there is object owner in the data stream not present in the QRS database. Object owners are not intended for use with QRS and is now removed in the import step, also for import replace.
QB-2431	Geo data contained invalid values and we got error while parsing it	Geo data contained invalid values and we got error while parsing it

November 2020 Patch 2

Key	Title	Description
QB-2834	Label was cut in some special cases in the bar chart	In some special cases the X-axis label was cut for the bar chart even though space was available
QB-2577	Zero values distribution plot	When dataset of distribution plot would be empty because of selections made we did not render distribution plot again. This fix makes sure we show the message "The selections generated no data for this chart" when this happens
QB-2560	Pie charts have incorrect colors when exported	Pie charts sometimes have incorrect colors when exported. This may happen if the app is set to use the Sense Classic theme.
QB-2326	SAML redirect removes "/" from the redirect URL	When authenticating via virtual proxy configured to use SAML authentication method, proxy service would remove one of the "/" from the redirect URL.
QB-2322	0dp numbers being output to Excel as 14dp	Fixed a special case where REAL numbers with 0 decimals resulted in excel export with 14 decimal number.

November 2020 Patch 1

Key	Title	Description
QB-2614	Open App could cause Engine to crash	Precondition: App with Section Access and Single selection When opening an app at the same time as another user, an exception is triggered for the app. This would cause Windows to kill Engine process.
QB-2501	ODAG fail to regenerate app	When pressing "Regenerate using current selection" or "Regenerate copy using current selection" on a generated ODAG app, an error is in some cases reported and no app is generated. This happens only if the user is not the owner of the link. This case is now handled and no error is generated.
QB-2495	Handle long query request	Handle canceling and retrying long query request.
QB-2403	Show condition blocks interaction with other objects	A false show condition in a chart inside a container might block the interaction with other objects inside the container.
QB-2298	Don't add the extra lib statement	Make sure if lib name is empty or doesn't exist, do not add any lib statement

November 2020

Key	Title	Description
QB-1091	Chart recommendations: Export to Excel creates duplicate sheets	When exporting visualization data to Excel and using the chart recommendations duplicate sheets with the same information would be created.
QB-1353	Text and Image	Add sanity check on switching context for text and image object.
QB-1666	Fix published bookmark export issue	The problem with missing bookmark during export from Windows Sense server is solved. The attributes for bookmark objects now include QRS published and approved settings as they should.
QB-1733	Access-Control headers no longer set	The Access-Control headers are no longer set by odag-service. This means that any Access-Control header configured in qmc for the virtual proxy will be used for calls to odag-service, including isOdagAvailable.
QB-1808	Selection in filter pane picking wrong row.	Filter pane displaying a calculated field could in some rare cases not pick the expected row when doing a selection.
QB-1821	Unable to rearrange variable extension dropdown values	The variable extension allows for specified values in a drop down, that are then set to the variable when used. The value list should support rearranging these values but a different fix caused that to stop working.
QB-1874	After selecting a value, share button falls into processing state.	For the fields where expression is used in the definition, there is no readable name defined.
QB-1947	Fix consistent fallback to sans-serif for characters in in the Qlik font	Fix consistent fallback to sans-serif for characters in in the Qlik font
QB-1949	CreateSessionObject on Session App throws errors in Windows event log	When creating a session object on a Session App, Engine threw an error in Windows event log. This was due to Engine sending malformed GUID into REST request (preview privileges) against Repository. Engine System logs will log out for each object that is removed.
QB-1961	Publish & Replace not working when duplicated meta data exist in Repository DB	Improved handling of duplicated data in the Engine. Will also remove duplicated meta data against Repository when a Replace operation is triggered (Publish&Replace or Import&Replace). To disable duplicate clean up part of the fix: Add following line in settings.ini file: RemoveDuplicateAppObjects=0
QB-1976	Engine hang on when trying to connect to an unknown data source	When reloading and engine encounter an non-existing/empty connection string , it became unresponsive. This issue is fixed so the engine finish the reload with appropriate message
QB-1995	Qlik Sense Repository API with filter returns error 400 Bad request	Qlik Sense Repository API with filter was returning 400 Bad Request error. This issue is fixed now.
QB-2015	Custom Associations fixed for Joined tables	When in data manager if the Join feature was used to combine two tables the fields could not be used to create a custom association with multiple fields.
QB-2058	Wrong Custom Format in Excel Export for Pivot Table	Wrong Custom Format in Excel Export for Pivot Table in rare cases.
QB-2129	vendors~bodymovin loading from a cross-site request	Animations and images from vendors~bodymovin were not loaded in a proper way for cross-site requests. This fix makes sure we load them properly, enabling request from a different domain in for instance mashups.
QB-2133	Overlapping text in wordcloud extension	Issue was due to a bad font being used in certain cases. Should now be more consistent.
QB-2151	No word wrap in chart descriptions	The descriptive text does not wrap in the asset panel preview, which causes scrollbars to appear.
QB-2191	Duplicating a large app appears to have failed but the app instead gets duplicated twice	The API used for duplicating an app throws a timeout error when user attempts to duplicate a large app. However, the app is duplicated twice. This issue is fixed in Nov 2020 release by increasing the timeout to accommodate duplication of large apps.
QB-2195	Date Picker : not working in IE.	Date picker was throwing Javascript error in IE, as the shortcut method syntax used in encoder is not supported in IE. NOTE : Fixed the encoder method to traditional definition syntax, so it is supported through multiple browsers.
QB-2239	Missing x-axis line	Fixed missing x-axis line when using a time axis and no grid lines in line chart and bar chart
QB-2266	Variable Input : Dropdown doesn't work in IE.	The shorthand function syntax is not supported in IE.
QB-2277	Titles hide when Show Tabs is off on a container	Titles and subtitles are hidden when switching off the property Show Tabs on a container object.
QB-2290	Fix dots of tooltip on color row	In this Jira ticket, the visual bug of the text of the tooltip that sometimes is cut off has been fixed.
QB-2331	Accessibility mode not work on container object	Using accessibility mode on a chart inside a container did not show data
QB-2367	Qvd async write improvement causing reloads to fail due to the QVD being locked	Qvd async writing will be disabled per default. This to prevent Qvd files to get locked. This change may impact performance with Qvd store. To re-enable this feature add "EnableQvdAsyncWrite=1" inside settings.ini file (see Qlik Knowledgebase https://tinyurl.com/y3n4me6x) Decision on enabling this feature in future is dependent on compiler upgrade and can only be done in future releases (compiler related issues cannot be back ported to patch versions)

Known issues and limitations

The following issues and limitations were identified at release time. The list is not comprehensive; it does however list all known major issues and limitations.

Clients
• If you have an object inside the container with a show condition that evaluates to false you are not able to edit properties of this object.
Workaround:
 - Option One: Make sure your show condition evaluates to true. Either by triggering an action/selection so that your show condition evaluates to true, or temporary remove the show condition. Now you can edit properties of the object inside the container.

 - Option Two: If you use master items inside the container you could edit the properties of the master item and it would propagate to the master item inside the container.
 - Option Three: Comment the expression that defines the condition, by entering two slashes in front of the equals sign, e.g. //=Count(Customer) <= 2
• 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. Depending on individual device specifications, mobile OS, and size of the Qlik Sense app, items generated using a third-party extension might fail to be visualized properly on a mobile device.
• When consuming Qlik Sense apps using Microsoft Edge browser, touch screen mode is activated by default even when it is run on a non-touch device. Workaround: turn 'touch screen mode' off from the navigation menu.
• When consuming Qlik Sense apps using Microsoft Edge browser on touch/hybrid devices, the long-press action does not work. This limitation prevents from accessing functions such as an object’s context menu, which on touch mode requires a long-press. This is a Microsoft Edge’s issue. Workaround: if using an hybrid device, turn the touch mode off and turn it back on again.
• Export as Anonymous does not work for mashups deployed in a domain that is different from the domain in which 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). Nevertheless, the script executes correctly.
• Legend does not show dimension values that are after row number 3000.
• Internet Explorer supports a maximum of six web socket connections. Workaround: See https://msdn.microsoft.com/library/ee330736(v=vs.85).aspx 
• If dimension limits (others) is set in a straight table or Pivot table, the subtotals and totals are incorrectly calculated.
• Exporting a story to PowerPoint limitations:
 - Titles are not rescaled as HTML, font settings are not yet exported.
 - Storytelling effects are not applied.
 - Exported charts may show fixed scroll bars, depending on the export resolution.
• Opening the first application after login takes longer time in in Chrome version 78 or older.
• It is not possible to open the context menu of an orc chart on a touch device.
• Layouts saved in bookmarks will not be applied for a chart using chart suggestions
• 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.
• OnDemand reporting extension is not supported in QCS or QSEoK
• When exporting a table that includes an invalid money format expression you may get an error message when opening the exported data in Excel.
• Can not see Dev-Hub with IE11 on QS Sep 2020.

• During reload using a QVD file, when the current QVD being read is replaced with a new one within the filesystem, the load script stops reading the records mid-way and completes successfully with however many subset of records it was able to read before the replace operation.
• Chatbot for windows: Issues with getting apps available to chatbot when multiple apps reloaded at the same time.

Dynamic views
• Dynamic views that are deleted from one app are also deleted from every other app that was using the same view. There is no work-around for this issue other than to avoid deleting views that may already be in use by one or more other apps as a result of having made copies of these apps.
• When creating a new dynamic view in the assets panel, if there is one or more existing dynamic views, the dropdown menu item does not automatically change to show the the charts of the newly created dynamic view. The user must click on the dropdown menu to choose the newly created view.
• The data for a dynamic view is automatically refreshed (i.e. re-queried from source) whenever a user enters a sheet containing any charts for that view. The same occurs when entering and then returning from the global selections panel as well as when adding a new chart for the same view. To prevent triggering this automatic refresh behavior, users should refrain from performing these actions on the base app.
• The view of a dynamic chart is cleared and overlaid with a message indicating a view constraint violation condition whenever the user changes the selection state of the base app such that the view's constraints are violated. Users should refrain from altering the selection state of the base app at least until they are finished making use of the data in any one of the dynamic view charts.
• The right-click "Go to source" option on a Snapshot slide for a dynamic chart does not select the actual dynamic chart when changing the view to the base app sheet.
• Chart settings changes made to dynamic view charts using the Exploration menu are lost following refresh operation of the view.

Managing a Qlik Sense site
• The QMC Custom Property Edit page can currently handle a limited number of custom properties. If you want to edit custom property values in the QMC, we recommend keeping the amount of custom property values to a maximum of 500. If you want to just apply values without modifying them, the QMC can handle up to 10.000 custom property values.
• The Qlik Logging Service handles communication outages with PostgreSQL by retrying three times to establish the connection and displays an error if unsuccessful. Communication outages with PostgreSQL can occur for a number of reasons and are not always recoverable in the limited time window of three tries.
• With the current architecture it is not possible, using security rule on HubSection_* resource, to hide "Open hub" link from the "Navigation" menu when accessing app as an anonymous user. Workaround: Use reverse proxy configured to redirect "Open hub" link to a preferable landing site
• It is not possible to remove app objects from disk when removing apps in QMC

Installation
• With Qlik Sense February 2019 or later, a new component is delivered together with Qlik Sense called the License Service. This service is managing the product activation when a Signed License Key is used.
The Signed License Key is mandatory to use for the following scenarios;
 - Multi-Geo/Cloud/Deployments using Qlik Sense Enterprise on Windows Qlik Sense Enterprise on Kubernetes or Qlik Sense Enterprise on Cloud Services as deployment methods with the intention to make use of a Unified Key ( 1 user * 1 User license across all deployments).
 - Qlik Sense Enterprise on Kubernetes installations
 - Qlik Big Data Index installations
 - Qlik Core installations
 - Qlik NPrinting ( February 2019 or later) installations.
 - All Qlik Sense Enterprise installations including Analyzer Capacity as a user license
With this release, we have introduced a delay for the time to the first connection to the Qlik Licensing Service. With the use of a Signed License Definition, the deployment can be running for up to 60 days until the first connection to Qlik.
This will give enough time for a Customer to prepare connectivity to license.qlikcloud.com using port 443 open for outbound calls only. Read more in the knowledgebase article, https://support.qlik.com/articles/000072102
• In Qlik Sense November 2018 it is not possible to install Qlik Sense Extension bundles through a silent installation. Qlik Sense Extension bundles can only be installed via the regular install procedure, or separately, once Qlik Sense November 2018 is installed. To install Qlik Sense Extension bundles separately, see “Installing and removing Qlik Sense Extension bundles from a Qlik Sense installation” in this document. Workaround: If you are installing Qlik Sense November 2018 by performing a silent installation, install Qlik Sense Extension bundles separately at a later moment.
• Service Dispatcher offline config entry lost when upgrading Sense April 2020 to June 2020

Qlik Sense Desktop
• Sorting by expression in a Pivot table may not work as expected.
• When uninstalling Qlik Sense Desktop, make sure all files are removed from %LocalAppData%\Programs\Qlik if you intend to install another version. If the files are not removed, Qlik Sense Desktop may crash when trying to apply the license.

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 Connectors 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, ODBC Connector Package does not prevent the loading of other data types, so in some cases unsupported data types can be loaded with the load script.
• ODBC connector: If the user name on the Microsoft Windows system running Qlik Sense Desktop contains letters that are not English alphanumeric characters, database connectors in the ODBC Connector Package do not work properly. Workaround: Change the Windows system locale to the match the character set that contains the characters used in the user name. For example, if the System locale on the system running Qlik Sense Desktop is set to English and a user name contains Swedish characters, the System locale setting must be changed to Swedish for the ODBC connector to work properly.
• The Qlik Salesforce Connector does not support PK chunking on sharing objects. PK chunking is supported only on parent objects.
• Apache Phoenix connector does not support non-latin characters in metadata. Connector may return a corrupted data or unpredictable query results if running a query with non-latin characters in metadata: table names, column names, aliases, etc.

Cloud deployments and Multi-Cloud
• In a Qlik Sense Enterprise on Kubernetes installation, if while loading a file using the Amazon S3 connector you attempt to abort the load, the abort will appear successful but the connector may continue the load using pod resources.
• When downloading a pivot table in cloud environments (Qlik Sense Enterprise on Cloud Services and Qlik Sense Enterprise on Kubernetes), expanded rows are not included but stay collapsed.

EMM solutions for Qlik Sense Enterprise
• If you use BlackBerry Access to consume Qlik Sense Enterprise apps, the Access browser does not display <Title> information. This means that when opening a Qlik Sense app through BlackBerry Access, the app retains the title of the initial Tab instead of showing the App Name. Workaround: refresh the browser so to display the correct App title.
• If using BlackBerry Access instead on Qlik Sense Mobile app, the access browser does not provide any indication in case of loss of connection with Qlik Sense Enterprise. If trying to interact with a Sense App after the connection is lost, the app becomes unavailable. Workaround: refresh the browser so to trigger a new log-in request.
• If using BlackBerry Access, when a Qlik Sense Enterprise log-in session expires, the Access browser provides an error message stating that the content is no longer available. In such a case using the refresh button does not trigger a refresh, but it only closes the error message. Workaround: close the tab and access again Qlik Sense Enterprise from the link in the BlackBerry Dynamic environment.
• When using the AirWatch browser to access Qlik Sense Enterprise, the refresh causes the content to be displayed in portrait mode even when the device is in landscape mode. Workaround: rotate the device so that the correct orientation is detected.
• When using the AirWatch browser to access Qlik Sense Enterprise, the header of the browser shows the Server name, occupying more space than needed especially in Landscape mode.

• When using MobileIron Tunnel on an Android 9.0 device QSM will not be able to detect it gets disconnected.

Upgrade notes

Qlik Sense September 2020
Announcement: Qlik Sense security update may impact extensions using jQuery
The issue:
The jQuery team announced (https://blog.jquery.com/2020/04/10/jquery-3-5-0-released/) a vulnerability in jQuery versions 3.4.1 and lower where a regex used by the jQuery.htmlPrefilter method that demonstrated the expression "could introduce a cross-site scripting (XSS) vulnerability."
Impact to Qlik customers:
The issue is resolved in jQuery 3.5.0, however, updating to the new version of jQuery may require developers to refactor extensions used in Qlik Sense applications to support the change.
When will the fix be implemented:
• Qlik Sense SaaS received the jQuery update on June 25th, 2020.
• Qlik Sense Client-Managed receives the jQuery update with the September 2020 release.
Action required:
• Extension consumers If you are an extension consumer, no action is required by you. However, you may experience extensions used in your Qlik Sense applications cease working after the jQuery update is applied.
• Extension authors Extension authors are encouraged to test their extensions using jQuery 3.5.1 to understand and mitigate any impact to customers.
Contacting Qlik:
If you have questions regarding this change and how to perform an impact assessment, please connect with the community on the Qlik Sense Integration, Extension, & APIs forum.

Qlik Connector 7.0.4 for use with SAP NetWeaver
If you use Qlik Sense September 2020 and Qlik Connectors for use with SAP NetWeaver you need to upgrade the connector package to version 7.0.4. Previous versions of the connector package are not supported by Qlik Sense September 2020.

Qlik Sense June 2020
Security filter result caching available for Extension resource
Results of rule engine's evaluation of security rules using Extension as resource filter are now cached. This cache exists in Qlik Sense Repository Service's memory. Using this cache avoids using the rule engine and will result in performance benefits when repeatedly accessing above resource. This improvement can be disabled by modifying following key in the Repository.exe.config file, by default located in: "C:\Program Files\Qlik\Sense\Repository", followed by a restart of the Qlik Sense Repository Service:
<add key="UseSecurityCacheForExtensions" value="true" />

New Advanced LDAP UDC and support for LDAP Channel Binding and LDAP Signing in Active Directory and Generic LDAP UDCs
Existing Active Directory and Generic LDAP UDCs have been extended with Authentication Type option. This setting is optional and defaults to Anonymous or FastBind based on the credentials specified. Following values can be given as comma separated combinations depending on the security scenario. These values will be XOR-ed for authentication:
Anonymous,Encryption,Delegation,FastBind,ReadonlyServer,Sealing,Secure,SecureSocketsLayer,ServerBind,Signing
New Advanced LDAP UDC available. This UDC adds more settings and options when connecting to LDAP. It supports secure LDAP connection in non-standard LDAPS ports, allows connecting to LDAP with Channel Binding and LDAP Signing enabled and provides options for LDAP Session settings, and more.
For more information please refer to corresponding Qlik Sense documentation.

Security filter result caching available for ReloadTask resource
Results of rule engine's evaluation of security rules using ReloadTask as resource filter are now cached. This cache exists in Qlik Sense Repository Service's memory. Using this cache avoids using the rule engine and will result in performance benefits when repeatedly accessing above resource. This improvement can be disabled by modifying following key in the Repository.exe.config file, by default located in: "C:\Program Files\Qlik\Sense\Repository", followed by a restart of the Qlik Sense Repository Service:
<add key="UseSecurityCacheForReloadTasks" value="true" />

Optimization of security rules evaluation
Objects that are read from the database are cached during the evaluation of the entities for specific calls. If there is more than a certain number of related entities read from the database, instead of caching some, all are read and cached. This limit is called ReadAllThreshold. This improvement will speed up all the initial requests where there is no corresponding cache in place. This improvement can be configured or disabled by modifying following keys in the Repository.exe.config file, by default located in: "C:\Program Files\Qlik\Sense\Repository", followed by a restart of the Qlik Sense Repository Service:
<add key="RulesEngineObjectCaching.Enabled" value="true" />
<add key="RulesEngineObjectCaching.ReadAllThreshold" value="10" />
Qlik Sense November 2020 Patch 16 release notes 18

Argument added to silent install
From Qlik Sense June 2020 a mandatory argument is added to the silent install of QSEfW and QSD. All silent install command must include the argument 'accepteula (1|0)'. The argument is added to Qlik Sense April 2020 as optional which makes it possible to prepare your script. The EULA can be found here: https://www.qlik.com/us/legal/license-terms and the documentation of silent install: https://help.qlik.com/en-US/sense-admin/April2020/Subsystems/DeployAdministerQSE/Content/Sense_Deplo...

Qlik Sense April 2020
Backup recommendations
It is important that you make a backup of the site before upgrading, to be able to recover the site if the upgrade fails.

Qlik Sense February 2020
Windows 7 and Windows 8.1 operating systems
From Qlik Sense February 2020 and forward, Windows 7 and Windows 8.1 are not supported operating systems.

Updated NodeJS version - recreating the Qlik Sense root CA certificate
The February 2020 version of Qlik Sense updates the version of NodeJS to a currently supported version and addresses several security vulnerabilities announced by the NodeJS project. Unfortunately, this requires recreating the root CA certificate generated with versions of Qlik Sense prior to the June 2019 release.
This procedure has been automated as much as possible and is included in the installer, but depending on the deployment, additional manual steps might be required. Please make sure to follow the upgrading instructions in the help:
https://help.qlik.com/en-US/sense-admin/February2020/Subsystems/DeployAdministerQSE/Content/Sense_De... 
For silent upgrades, refer to the following help topic:
https://help.qlik.com/en-US/sense-admin/February2020/Subsystems/DeployAdministerQSE/Content/Sense_De.... 
Note:
You will also have to replace Qlik Sense root certificate with the newly created one in the following cases:
• Your Qlik Sense deployment is connected with Qlik NPrinting, Qlik multi-cloud setups, or any other external tools or configurations.
• You have configured QlikView Distribution Service for distribution of links to QlikView documents to the Qlik Sense hub.

Enabling Natural Language Processing
This release of Qlik Sense includes the ability to ask natural language questions in the Insights providing the same functionality seen on cloud editions of Qlik Sense since September 2019. The functionality is enabled by default for new installations of Qlik Sense, however, for upgraded environments this will be installed but switched off.
Customers wanting to enable this functionality can do so by executing the following steps on every node in the Qlik Sense cluster:
1. Navigate to "C:\Program Files\Qlik\Sense\CapabilityService" (or corresponding non-default location):
2. Edit the "capabilities.json" file.
3. Add the following flags. Make sure to separate them with comma (,) and enclose within the existing rectangular brackets ([ ]):
{"contentHash":"cf15d72343be5e4223b9e8de37e69aef","originalClassName":"FeatureToggle","flag":"NLU_INSIGHTS","enabled":true}
{"contentHash":"cf15d72343be5e4223b9e8de37e69aef","originalClassName":"FeatureToggle","flag":"NLU_INSIGHTS_VOICE_QUERY","enabled":true}
{"contentHash":"cf15d72343be5e4223b9e8de37e69aef","originalClassName":"FeatureToggle","flag":"CAO_DATA_VALUES","enabled":true}
4. Navigate to "C:\Program Files\Qlik\Sense\ServiceDispatcher" (or corresponding non-default location):
5. Edit the "services.conf" file.
6. Add "Disabled=false" under [nl-parser] and [nl-broker] sections.
Example:
[nl-parser]
Disabled=false
[nl-broker]
Disabled=false
7. Restart all the Qlik Sense services.
Note: Qlik Sense Desktop is not affected and the natural language functionality is enabled for both new installations and upgrades.

Qlik Sense November 2019
New load balancing scheme
Qlik Sense November 2019 introduces a new load balancing scheme. In previous versions of Qlik Sense, the algorithm always chose the load-balancing node with the lowest CPU load. The CPU load of all nodes was updated every 5 seconds, which might have resulted in consecutive reloads being distributed to the same node. To improve the handling of frequent consecutive reloads, the algorithm has been changed to select the node with the lower number of running tasks per "Max concurrent reloads" setting, tracking this value on the scheduler master node.
This improvement is enabled by default. If you wish to disable it, do the following:
• Open the Scheduler.exe.config, which by default is located in: "C:\Program Files\Qlik\Sense\Scheduler\Scheduler.exe.config"
• Set "DisableLegacyLoadBalancingBehavior" setting to false
• Restart Qlik Sense Scheduler Service
• Repeat these actions on each node of the cluster running the Qlik Sense Scheduler Service

Handle "invalid cookie bursts" in the Qlik Sense Proxy (QPS) Service
When a multiple cookie request arrives to the Qlik Sense Proxy Service for the same user and authentication method within a small-time frame, QPS reuses the session from the first request. This behavior avoids the creation of additional sessions, and therefore prevents reaching the maximum number of allowed sessions, which would result in temporary lock of that user. See the “Managing a Qlik Sense site” section of "Known issues and limitations" for a known limitation of this change. This improvement is available in all patches listed below with the default value of 2 seconds provided corresponding setting is enabled. If you wish to enable and configure or disable it, do the following:
• Open the Proxy.exe.config, which by default is located in: "C:\Program Files\Qlik\Sense\Proxy" • To enable and configure add the string <add key="InvalidSessionRequestBurstLimit" value="00:00:02"/> in the section <appSettings> with the desired value greater than 0 • To disable without removing the flag add the string <add key="InvalidSessionRequestBurstLimit" value="00:00:00"/> in the section <appSettings> with the value of 0. QPS will fall back to previous behavior with one difference – before it would initially overwrite the existing cookie with an empty one in the first request (Set-Cookie: X-Qlik-Session=), now Set-Cookie header will not be included.
• Restart Qlik Sense Proxy Service
• Repeat these actions on each node of the cluster running the Qlik Sense Proxy Service

License service must be active during startup of the Qlik Sense Repository service
From Sense April 2019, the Qlik Sense Repository service (QRS) contacts the Qlik License Service during startup phase. This means that during start-up of the QRS, the Qlik Sense Service Dispatcher (QSD), which manages the Qlik License Service, must be running, so that the Qlik License Service can be reached by the QRS. When executing repository.exe -bootstrap (also with additional parameters), if the QSD is not running the bootstrap does not fully complete and the System_Repository logs register the following error:
83 20190507T152440.101+0200 WARN rd-AMW-2016-03 System.Repository.Repository.Core.Licensing.LicensesInitializer 6 83b132fa-fa98-44e4-9f86-338be262a014 RDLUND\svc-silver There was an error contacting the license service. Keep retrying... (1 failed requests) GET /v1/licenses/overview
Qlik Sense November 2020 Patch 16 release notes 21
StatusCode: InternalServerError Response: . Could not connect to the license service. NO-STACKTRACE 83b132fa-fa98-44e4-9f86-338be262a014

‘Version’ column for apps in QMC and migration of apps created with Sense 3.1 or earlier
With Qlik Sense November 2019 and later releases, in the Apps menu of the Qlik Management Console (QMC), the 'Migration status' column has been replaced with 'Version'. This new field shows the version of the engine used last time the app was saved. Apps created with Sense 3.1.6 or earlier versions will be highlighted with a red 'Migration needed' string, which signifies that the app must be manually migrated via the QMC. Apps created with Sense 3.2 or a later version show the last saved version and do not require manual migration. This is because apps created with Sense 3.2 or a later version are automatically migrated by the client once opened and saved. Once an app is saved and migrated, the value in the 'Version' column is updated accordingly.

Change of log level QIX Engine API error codes
When a QIX Engine API call fails, an error code is returned and a message is logged to the Engine Service log. In previous versions of Qlik Sense, the log level of this message was always ERROR, even when, for example, the API client supplied invalid parameters or requested a resource that does not exist.
With Qlik Sense November 2019, client errors are now logged to the Engine Service log at WARN level. Sample log messages are:
Command=Doc::GetFieldDescription;Result=8;ResultText=Warning: Invalid parameters
Command=Delete app;Result=404;ResultText=Warning: Not Found
Command=Duplicate app;Result=9003;ResultText=Warning: Resource not found
The same message is logged to the Engine Audit log.

Qlik Sense September 2019
Setting a sheet as the app landing page
With Qlik Sense September 2019, you can select a sheet to be the landing page of your app by setting a default bookmark. If in a app you had previously configured the setting “Set selections as app default”, the document will now open on the sheet where you have applied the setting instead of opening on the sheet overview. To change this behavior, do the following:
1. Open the app where the “Set selections as app default” setting is applied.
2. Go to the sheet you want to use as the app’s landing page.
3. Open the Bookmarks
4. Create a new bookmark
5. Right click on the newly created bookmark
6. Choose 'Set as default bookmark'
7. Repeat this procedure for all apps where the “Set selections as app default” setting is applied.
For more information on this feature, see the documentation page Setting a default bookmark to create an app landing page.

Qlik Sense June 2019
Change of default theme for Single Integration and capability API
With Qlik Sense June 2019 or later releases, the theme for current selection for Single Integration and capability APIs is set to bright by default. Specifically, this change impacts the 'CurrentSelections' string for getObject, and currsel for Single Integration API.

Qlik Sense February 2019
New product activation method using the License Service component for Qlik Sense February 2019 and later
In Qlik Sense February 2019 or later, a new License Service component is delivered together with Qlik Sense. This service is used when the signed keys are used for product activations. The License Service will connect to a License Backend Service, hosted by Qlik, for product activations and Entitlement Management. This activation process is required for Multi Cloud deployments using Qlik Sense Enterprise on Kubernetes or Qlik Sense Enterprise on Cloud Services as deployment methods. The new activation process is currently optional for Qlik Sense Enterprise on Windows. The use of this activation process is also required if you want to use the new Qlik Sense Analyzer Capacity license introduced with Qlik Sense February 2019. The Qlik Sense Master node needs access to an internet connection. Port 443 is used for accessing the end-point at https://license.qlikcloud.com and retrieving license information.
You can continue using the standard key with a serial and a control number product activation instead of the signed key method. However, to keep using the standard key activation method you must run Qlik Sense November 2018 in your Multi-Cloud installation.

Qlik Sense June 2018
Upgrade may fail if services are in Disabled state
If a service is in the Disabled state prior to an upgrade, it may lead to the service not being completely uninstalled, and a subsequent failure to install the new version of the service. The rollback of the service upgrade will also fail, which means that the service is not available anymore, and cannot be repaired.
The most likely cause of this problem is that other processes are scanning the state of the service during uninstall or upgrade, hence preventing it from becoming completely uninstalled. Examples of such processes are Process Explorer and the built-in Control Panel > Administrative Tools > Services snap-in. This bug in Windows is documented here: https://support.microsoft.com/en-us/kb/287516
To minimize the risk of this occurring, do the following in order, before upgrading:
1. Stop all Qlik Sense services manually.
2. Verify that no service is in the Disabled state. This can be done by the Services snap-in, or another program that polls service state.
3. Ensure that all service state polling applications are closed, including applications you used in step 2. Setting all Qlik Sense services to Manual start, and then restarting the system is the most reliable way of making sure that all service state polling applications are closed.

System requirements notes

Please refer to the online help for information about the requirements for Qlik Sense:
System requirements for Qlik Sense

Additional notes:
• On a machine with a server operating system, it is only possible to install Qlik Sense (server), not Qlik Sense Desktop.

Windows 7 and Windows 8.1 support ended

From Qlik Sense February 2020 and forward, Windows 7 and Windows 8.1 are not supported operating systems.

Downloads

November 2020 Patch 19

Server Patch: https://da3hntz84uekx.cloudfront.net/QlikSense/13.102/19/_MSI/Qlik_Sense_update.exe  

Desktop: https://da3hntz84uekx.cloudfront.net/QlikSenseDesktop/13.102/19/_MSI/Qlik_Sense_Desktop_setup.exe 

November 2020 IR

Server: https://da3hntz84uekx.cloudfront.net/QlikSense/13.102/0/_MSI/Qlik_Sense_setup.exe 

Desktop: https://da3hntz84uekx.cloudfront.net/QlikSenseDesktop/13.102/0/_MSI/Qlik_Sense_Desktop_setup.exe 

About Qlik

Qlik converts complex data landscapes into actionable insights, driving strategic business outcomes. Serving over 40,000 global customers, our portfolio provides advanced, enterprise-grade AI/ML, data integration, and analytics. Our AI/ML tools, both practical and scalable, lead to better decisions, faster. We excel in data integration and governance, offering comprehensive solutions that work with diverse data sources. Intuitive analytics from Qlik uncover hidden patterns, empowering teams to address complex challenges and seize new opportunities. As strategic partners, our platform-agnostic technology and expertise make our customers more competitive.

qlik.com