QlikView Release notes - May 2021 Initial Release to Service Release 2

Qlikster_Skalberg · Oct 13, 2022 7:56:57 AM

TABLE OF CONTENTS

What’s new in QlikView May 2021

System requirements

Upgrade notes

Known issues and limitations

Resolved issues QlikView May 2021 IR

Resolved issues QlikView May 2021 SR1

Resolved issues QlikView May 2021 SR2

What’s new in QlikView May 2021

QlikView May 2021 IR

Changed PDF printer driver

QlikView Publisher will by default use 'Microsoft Print to PDF'. The previous pdf driver 'PDF-XChange 3.0' has been removed from QlikView installations.

Improved Access Point

The Access Point has been visually improved.

Improved bookmark handling

It is now possible to share bookmarks also with an Analyzer license.

Improved Section Access

The logic in Section Access has been tweaked so that it now is possible to use the same Section Access in both QlikView and Qlik Sense, including SaaS editions. The changes affect the fields SERIAL and USER.EMAIL.

Existing Section Access tables should work unchanged, unless you already have a field called USER.EMAIL. In such a case, you need to review your authorization table.

Improved support for QlikView apps in Qlik Sense Enterprise SaaS

Added support for large QlikView applications on Qlik Sense Enterprise SaaS.

A limit on number of parallel distributions to Qlik Sense Enterprise SaaS has been added.

Added support for mailing a bookmark as a link.

Added support for proxy when distributing to Qlik Sense Enterprise SaaS.

QVF support

Support for the QVF file format has been introduced. It is now possible to open and save files in the QVF format. There are however still some limitations, e.g. input fields and macros are not supported; QVF files cannot be reloaded on a QlikView Server.

Further, there is not yet any cross-compatibility between QlikView QVF files and Qlik Sense QVF files.

Searchable bookmark list

The drop-down listing bookmarks is now searchable, so it is possible to find the correct bookmark also in long lists.

Copy cell value to clipboard for the Analyzer license

Support for “Copy cell value to clipboard” has been added for Analyzer licenses.

Bugs

This release addresses several bugs. See below under “Resolved Issues”.

QlikView May 2021 SR1

Bugs

This release addresses several bugs. See below under “Resolved Issues”.

QlikView May 2021 SR2

Support for CutePDF printer driver

The QlikView May 2021 Server uses by default the 'Microsoft Print to PDF'. To add flexibility, support for the CutePDF printer driver has been added.

Bugs

This release addresses several bugs. See below under “Resolved Issues”.

System requirements

The system requirements for this release can be found under “System requirements” on the Qlik help web site. https://help.qlik.com/en-US/qlikview/May2021/Content/QV_HelpSites/System-requirements.htm

Upgrade notes

There are no upgrade notes for this release.

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.

Upgrade may cause QlikView to become unlicensed

Upgrading may in some circumstances result in the QlikView installation becoming unlicensed. Re-applying your license solves the issue.

The internal logic of “Export to Excel” has been changed

QlikView 12.50 has generated an increase in customer-reported issues related to Excel export. It is mainly the change in formatting of numbers, compared to previous releases. The reason behind the behavior is that some of the number formats supported in QlikView are not supported by Excel. For those cases, Excel will in a 12.50 export display them as invalid values.

With 12.60, we revert the export behavior back to the same logic as that of QlikView 11.20. To avoid complications at an Excel export, an update to 12.60 is recommended.

A number of bug issues are related to this change: QV-21821, QV-21769, QV-21571, QV-21462, QV-21438, QV-21351, QV-21300, QV-20940.

Security enhancement: Stricter certificate handling for secure web files

The approval algorithm for certificates for secure web files have been made stricter. This means that script references to https sources that previously worked may in some cases fail in 12.60. Make sure that the certificate was issued by a trusted CA, is valid and was issued to the domain of the website the reference is accessing.

No PDF printer driver on Windows 2012

The QlikView Publisher will by default use 'Microsoft Print to PDF', but since this driver doesn’t exist on Windows 2012, it may be impossible to print on this OS. However, previous QlikView installations contain the 'PDF-XChange 3.0' which still can be used.

Resolved issues QlikView May 2021 IR

QlikView May 2021 IR includes fixes for the issues listed below.

Straight table header did not stay still when scrolling in AJAX interface

Issue ID: QV-17777

Straight table header did not stay still at the top but instead moved with the entries when scrolling in AJAX interface. Header was not frozen when scrolling straight table in WebView mode.

NPrinting Add-on: Limit on number of reports shown is 50

Issue ID: QV-17997

The limit on number of records has been increased to 100. It has also been changed to a recursive call: Until all the report templates created are displayed, the request to the server is sent again.

QixPerformanceLog shows unknown values

Issue ID: QV-18273

The QixPerformanceLog had lost the assignment of ObjectID and ObjectType for QlikView sheet objects. This has been restored.

QVS Nodes Showing Off Duty with Teamed NICs

Issue ID: QV-18789

Improved QVS cluster Join mechanism implementation by adding an array of unique identifiers for each join request. It is now possible to identify same sender in teamed NICs environment.

If a document is opened in server, QlikView Desktop and IE client hangs after closing

Issue ID: QV-18964

Fixed a problem where QlikView Desktop or the QlikView plug-in might hang after closing.

Expression suggestions disabled in the plugin

Issue ID: QV-19033

This fix enables expression suggestions and colored keywords for the 32-bit plugin.

Dimension name is truncated in charts

Issue ID: QV-19476

The name of a dimension that was a member of a group, was truncated when there was no data to display in charts. Cycle button was truncated in bar charts.

Tab row rendering should now scale with ZoomFactorForHighDPI setting

Issue ID: QV-20101

Document sheet tabs were not scaled by ZoomFactorForHighDPI.

QlikView Distribution Service: Alert e-mail is not sent

Issue ID: QV-20112

A task log is now created when the task fails, and an alert mail is sent if configured.

Straight Table column order reset

Issue ID: QV-20129

Added possibility to reset column order for a straight table, by a button on the Presentation page. Auto-generated straight table organizes columns in the wrong order.

Text object renders differently

Issue ID: QV-20232

Text object with different shapes with/without rounded corners and borders now renders correctly.

Expression overview can now handle recursive containers

Issue ID: QV-20263, QV-20683

Expressions in objects that are displayed inside recursive containers are now properly handled.

Cross-site Scripting (XSS) Vulnerability

Issue ID: QV-20277

jQuery upgraded to version 3.5.1. QlikView Web client/Access Point/Management console: Cross-site Scripting (XSS) Vulnerability with jQuery 3.4.1 and below.

QlikView Workbench: Qv.Document.GetObject never completes

Issue ID: QV-20309

Fixed an issue with pivot tables with more than 40 columns: Client never stopped asking server for data, and therefore never finished loading.

QlikView Ajax Client: Selections in the wrong state

Issue ID: QV-20314

Selections could look selected (green) without being in a selected state. This happened if you moved the cursor outside list while clicking on a list item.

Set analysis giving different results based on data model and field order

Issue ID: QV-20325

Under some circumstances, the set operators (union '+', exclusion '-' etc.) were not commutative, if the arguments spanned multiple tables. The first (left) argument left parts of its set information that were not combined with the second (right) argument, causing an inconsistency that affected the outcome of some expressions. This has now been corrected. The error has been present on all traced product versions.

Text Objects cannot display the full existing text

Issue ID: QV-20350

Text Objects could not display the full existing text.

QlikView QMC: The "Assign license" button is not showing

Issue ID: QV-20381

The button disappeared when scaling the window or if the screen's resolution was too low. The "Assign license" button was not showing if the browser window was narrow.

Thumbnail sometime lost when editing document

Issue ID: QV-20393

Thumbnails could be lost when documents were edited. They are now saved as backup.

QlikView QMC: Not possible to turn off DSC lookup

Issue ID: QV-20405

Setting the hidden QMS config setting "AcceptManuallyInputedUsersNotInAD" to True now allow users not existing in AD to be added as Professional/Analyzer. It is now possible to turn off DSC lookup for manually added users.

Incorrect date format in Excel export and NPrinting report

Issue ID: QV-20513, QV-21006, QV-21462

Sometimes a date field or a date variable was exported as floating number in Excel. Date fields and date variables are now exported with correct date format.

Numbers exported as text at Excel export

Issue ID: QV-20560, QV-21571, QV-21769

Sometimes number columns were exported as TEXT to Excel. Number columns are now exported with correct number/date format.

Export to excel changes number format

Issue ID: QV-20825, QV-21438, QV-21505, QV-21821

Sometimes the number format was lost, and the export was done using the raw number. As a result, decimals were added. Number values are now exported into correct number/date format.

Straight table columns drag and drop

Issue ID: QV-20571, QV-20823, QV-21107, QV-20857, QV-21823

Moving columns, particularly when hidden/disabled columns are present is now better handled. Measures can now be dragged/dropped to the right place between dimensions.

Adjust/align active text in Input box edit popup

Issue ID: QV-20578

Active text, while entering the input, in the Input box edit popup was not aligned to surrounding box. This is fixed for QlikView Desktop. Input field edit box is zooming out, input text partially/half is displayed.

Optional connect statement parameters work again

Issue ID: QV-20641

Optional parameters like "mode is write", "CodePage" and "AutoCommit" are working again. They are successfully transferred from the script to QvConnect.

Issues with Document Purging

Issue ID: QV-20644, QV-21201

Fixed an issue where a document was unloaded from memory as soon as session was closed. Now it waits until the document timeout is reached.

Negative number for number of records

Issue ID: QV-20645

This change fixes an issue where #records shows as negative number in exported table structure when total number of rows in a that table is over max number of an integer. Export structure resulted table # of Records showing negative number.

Missing values in Excel export

Issue ID: QV-20652, QV-20673, QV-20899, QV-21351

In some rare cases, when number cell or minichart, gauge or chart data cell were exported to Excel, it showed a blank instead of a number. With this fix, it shows correct content.

New QMC fields to setup proxy for cloud distribution

Issue ID: QV-20656

Fixed an issue with QlikView documents that could not be published to Cloud via Proxy.

Sort by state no longer forced in Multi box

Issue ID: QV-20708

When opening a field in a Multi box, the selected sort options are now applied, not forcing sort by state.

Unexpected vertical lines appear in List box

Issue ID: QV-20716

LED list box: unexpected vertical lines appeared when in Ajax/WebView mode. Right border in list box last column is now removed.

Thinner scrollbars allowed in web client

Issue ID: QV-20717

Ajax/WebView mode: Scrollbar width not preserved as it is in Desktop. Lowered the lower limit of allowed scrollbar width for ajax client to 5 (was 9).

QlikView Ajax Client: Scrollbar background colour is not the same as it is in Desktop

Issue ID: QV-20721

Scrollbar background color set in Desktop was ignored in Ajax.

Pivot table layout is different before and after QV12.40

Issue ID: QV-20733

Pivot table was presented in different layout when opened with a QlikView version before 12.40. Pivot table lost structure after upgrade from 11.20.

Authenticated User is not listed in Sessions

Issue ID: QV-20734

This change fixes issue where "Authenticated User" filed is empty in QVS Session Log.

QlikView Ajax Client: not possible to directly free text search

Issue ID: QV-20758

When dropdown list had about 40 visible lines it was not possible to search. After upgrading to QV12.50 it is not possible to directly free text search.

QlikView QMC: Attributes cut off in view details

Issue ID: QV-20764

Hidden attributes are now available.

QlikView Ajax Client: Border between head and body of table not shown

Issue ID: QV-20768

In some cases, QlikView Desktop WebView display rendered incorrectly.

Labels on x-axis overlap when Truncate label is enabled

Issue ID: QV-20779

Truncated label for charts no longer causes double labels for continuous x-axis.

Slider does not select the last value in the range

Issue ID: QV-20818

Fixed an issue when selecting a range of values using a slider. The largest value in the slider range was excluded and could therefore not be selected.

Mail with Bookmark link causes a server error

Issue ID: QV-20820

Calculated dimensions were not considered when cycling a group. They are now included.

QlikView Ajax Client: When clicking help Icon "?" nothing happens

Issue ID: QV-20832

The help now opens as expected when clicking the help icon.

Current Selections window cannot be moved in AJAX interface

Issue ID: QV-20855

Current Selections window could not be moved in AJAX interface, which was movable in previous version QV11.

Ajax client calendar object modifies the time unintentionally

Issue ID: QV-20948

For AJAX client, the fix keeps the time as-is after a date selection in calendar object, if the selected date is in the current month. This behavior is consistent with Desktop version. Date selection of Calendar object set the time info to 0:00:00 in AJAX / WebView.

Container object drop drown list background color and font size

Issue ID: QV-20949

Container object dropdown background color is now disabled for AJAX client. It was inheriting the tab color previously, now it is always set to white.

CMYK color space is not supported in Skia

Issue ID: QV-20961

With Skia rendering engine, images with CMYK color space were not rendered properly. This has been fixed with this change. CYMK Images no longer supported in Bundle Load.

QlikView Small Devices: Unable to scroll vertically

Issue ID: QV-20988

Fixed an issue where it was not possible to scroll vertically to get to the bottom sheets.

Cannot create NPrinting On-Demand reports unless app is in QVS root folder

Issue ID: QV-21003

Fixed the application path generation process for the temporary bookmarks, to enable NPrinting to create On-Demand reports for the apps that reside in the subfolders of the QVS root document folder. NPrinting On-Demand reports failed if QVW files were stored in subfolders of the Root documents folder.

List box and Multi box object do not inherit their properties states from the sheet

Issue ID: QV-21008

The List box and the Multi box did not inherit the state from the sheet when the "<inherit>" option was selected. All objects now inherit the state from its sheet when state "<inherited>".

QlikView Ajax Client: The Clear icon is visible on locked fields

Issue ID: QV-21052

The Clear icon in "Current Selections Box" is now hidden if field is locked.

All list boxes with same field are removed when using delete from sheet properties

Issue ID: QV-21063

Fixed an issue where deleting a list box from Sheet Properties > Objects tab deleted all objects with the same caption name.

Incorrect terminology in QlikView QMC

Issue ID: QV-21104

QMC now says “Ajax Client” instead of "Full Browser Client".

QlikView Ajax Client: Error when rendering large table

Issue ID: QV-21200

Fixed an issue where all data was not loaded for tables with more than 80 columns visible.

Dates and Percentages are Not Formatting Correctly

Issue ID: QV-21300

Dates and Percentages were not formatted correctly.

Copying the Script log to shared folder breaks

Issue ID: QV-21310

Fixed an issue where copying the Script log to shared folder broke after 1minute. Introduced the hidden setting "CopyDocumentLogTimeOutInMinutes".

Radar chart multiline labels

Issue ID: QV-21346

Radar Chart labels were not fully displayed when the text had multiple lines. Labels in radar charts are now measured and not assumed to be single line.

App byte size metadata for fields incorrect

Issue ID: QV-21355

Fields with many unique values could appear to have a negative byte size in the app metadata due to a step in the metadata calculation using 32-bit precision. The number of unique values required varied with the data but is in the range 270M to 540M. The entire calculation is now done in 64-bit precision.

QlikView Ajax Client: Tooltip Hover is not disappearing when moving to another page

Issue ID: QV-21383

Clicking on a chart while having tooltip open could cause the tooltip to stay on the screen even if the click resulted in a new sheet being displayed.

QlikView Ajax Client: List Box selections are not highlighted

Issue ID: QV-21415

List box with selection style Corner tag, LED and LED Checkboxes did not get instantly updated when making multiple selections with ctrl-key.

Disabled Tasks in QMC get "Running" Icon

Issue ID: QV-21473

Disabled tasks in QMC appeared to be running even though they were not executed.

Dimensionless Radar charts

Issue ID: QV-21476

Radar charts that only uses expressions should no longer give the "No data to display" error.

Pivot table column does not disappear when previous column is collapsed

Issue ID: QV-21503

Fixed an issue where an adjacent column would not disappear after closing each of the entries in the column next to it. This happened even when the column was not a calculated dimension.

String handling with clusters

Issue ID: QV-21540

Drawing of chart failed internally. Now, string handling will not assume the clusters vector to be populated.

Mouse click action doesn't clear the context menu

Issue ID: QV-21590

Fixed an issue where AJAX/ WebView mouse click action did not clear the upper hiding context menu. Clickable area that closed open context menu was limited to the current screen size. Scrolling or resizing window and clicking in an area previously hidden did not close the context menu.

Charts with 3D look now allocate correct space

Issue ID: QV-21592

After upgrade from 12.10 to 12.50 (May 2020) version bar chart sticks out. Charts using 3dlook styles will now allocate space for the 3d effect.

Internal -64 exception during Excel export

Issue ID: QV-21607

Fixed an issue where one could occasionally get Error level log messages beginning "System: XlsxExport: Exception(-64) is caught" during Excel export.

QlikView Ajax Client: Colored line between scrollbar and object content

Issue ID: QV-21660

The colored divider between scrollbar and content is now only visible if there is a border around the object or if the object is in a container.

Mail with bookmark as link is broken

Issue ID: QV-21672

Fix for “Mail with bookmark as link” when the setting “BypassSharedFileForTempBookmarks” is activated.

Header image filling the entire sheet

Issue ID: QV-21710

Fix for QlikView Access Point where header image filled the entire document sheet in Access Point. Background mage did not stretch when opened.

'Send to Excel' not working

Issue ID: QV-21725

Fixed an issue where 'Send to Excel' did not work in QlikView Desktop 12.40. In rare conditions, when trying to export to excel on straight table that did not contain any hypercube data, the object could be corrupted.

Incorrect timestamp format in QMS Audit logs

Issue ID: QV-21757

QMS Audit logs did not show time in modern format. Changed log time format to modern ISO format. Ex: 20210222T141939.000+0100.

Document Log not showing time

Issue ID: QV-21773

QlikView 12.50 Document Log not showing time when reviewing log in the QMC. It only shows date.

Improvements have been made to the QixPerformance log

Issue ID: QV-22199

The QixPerformance log did not show the DocID. This has been fixed.

Resolved issues QlikView May 2021 SR1

QlikView May 2021 SR1 includes fixes for the issues listed below.

Problems with the Web file connector

Issue ID: QB-6047, QV-22252, QV-22390

A problem with the web file connector caused different types of rejected access, although the user was authorized.

Short name for Wednesday corrected in Japanese language

Issue ID: QV-21394

In the calendar object, Japanese weekday Wednesday is displayed like 水曜 instead of 水

Better handling of column/row sizes in containers

Issue ID: QV-21820

No longer rounding the column/row sizes in containers using grid mode (AJAX).

Field selection cleared by reload

Issue ID: QV-21822

A degrade introduced in 12.40 caused a selection on a numeric field to be lost after a reload. It's fixed by this change.

Lock icon not displayed Issue

ID: QV-22214

QlikView Ajax Client: A List box with selection style "Windows checkboxes" and "Always one selected" checked didn't show a lock icon

PDF Report of grid-like objects has wrong scale

Issue ID: QV-22303

Printing a Report from QV 12.60 Access point containing Straight tables results in the PDF file with objects that have too narrow columns width

Font size of Input Box incorrect

Issue ID: QV-22354

QlikView Desktop: Active text font size on Input Box selection was almost unreadable. This is fixed for QV Desktop.

Sybase ASE ODBC driver fails to reload

Issue ID: QV-22355

Sybase ASE failed to reload due to passwords with non-alphanumeric characters in 12.50 SR 2. The password must to be enclosed in quotation marks.

Export all data correctly from straight table to excel file

Issue ID: QV-22356

QlikView Desktop: Some of the column data from a straight table was missing in the excel file when the "Export to Excel" feature was used. This is fixed for QV Desktop.

QlikView Ajax Client cannot be embedded in iframe

Issue ID: QV-22368

QlikView Ajax Client cannot be embedded in iframe

Scatter chart with values on datapoint sometimes shows wrong values

Issue ID: QV-22391, QB-5270 and QB-5306

A Scatter chart with values on datapoint sometimes shows wrong values and cause an exception resulting in "Drawing of chart failed" in windows but causing a crash in Cloud.

Reports fail to print

Issue ID: QV-22394

Fixes the export to pdf action parameter PDF Printer Name and adds the setting DefaultPDPrinterName that makes it possible to specify the name of a default PDF printer. The problem only exists on Windows Server 2012.

QV Server not working with IIS and OnDemand Add-On

Issue ID: QV-21879

Newtonsoft.dll has been removed from webserver/IIS installation. This fixes an incompatibility between newer versions of QlikView Ajax Client when run in IIS and On-Demand Add-On.

Resolved issues QlikView May 2021 SR2

QlikView May 2021 SR2 includes fixes for the issues listed below.

Unexpected behavior when using function ConvertToLocalTime()

Issue ID: QB-7474

Significant performance and stability improvements to the ConvertToLocalTime function.

Repeated operations on chart expression can cause QlikView Desktop to become unstable

Issue ID: QV-22400

If there is a stack overflow error due to recursive functions, QV would crash and show unstable behavior. This change addresses the issue.

Columns in excel export are grouped together

Issue ID: QV-22407

The list separator to generate the excel file was not reflective of the system's regional settings leading to columns in excel file grouped together. This change fixes the issue.

Export to Excel changes number format

Issue ID: QV-22413

When a customized number format is used in expression, the exported number has wrong format. This is because the special format cannot be converted to an Excel format. Such formats will be now exported as TEXT, just as QV 11.20 does.

QlikView Ajax Client: Screen freeze when right click on dropdown list in Multi Box

Issue ID: QV-22450

When you press the dropdown arrow in a Multi Box you get a dropdown list. If you right click on that list to open its context menu, the screen freezes. This change fixes the issue.

QlikView Ajax Client: Container object dropdown does not show all values after a selection

Issue ID: QV-22469

QlikView app container object behaves differently in May 2021 version. This change fixes the issue.

Command line reload for scripts using macros

Issue ID: QV-22487

Command line reload for scripts using macros does not work in batch. The fix is to allow this, providing the /nosecurity switch is used.

QlikView Server: Report is not printed in Windows 2012

Issue ID: QV-22567

The Setting to specify the default printer in Settings.ini was misspelled in QlikView May 2021 SR1. This is now corrected. It should now be DefaultPDFPrinterName=PDF-XChange 3.0. If this setting was changed for SR1, it needs to be changed back.