Vizlib Table Changelog

Removed vulnerabilities.

Possibility to enable and disable formatted export in the Property Panel. For more information, see Enable or Disable Formatted Export.

You can change the way the links are presented in the Table if inserted as Dimensions.

You can change the URL into text. To do so, in the Dimension properties, go to Representation and enable the Text is URL option. Once enabled, you can insert your own link text using the Link label field.

The extension loaders have been updated. The updated loaders don't interfere with your company branding.

If there are no dimensions in the app, Vizlib Table Wizard displays the Measures tab first, and then the Fields tab. If there are no measures, the Fields tab displays first.

When the users created a master dimension and wanted to drag and drop the field into the table. the field wasn't inserted, but the master item worked correctly. Currently, the master dimension is inserted properly into the table.

The following changes on the user interface (UI) have been made in this release:

• The Relative to total option is located in the Miscellaneous section on the Properties Panel.

• The Show total value checkbox has been replaced with a switch with the Show and Hide settings.

Note: The mentioned changes on the UI apply only to Vizlib Table v3.25.2 and onwards.

When you exported formatted data, the colours, fonts, and borders set for the header, rows, and totals displayed incorrectly.

The number of exported rows differed depending on which of the three options you chose:

• Export Data to Excel

• Export Data to CSV

• Export Data to Tab Separated CSV

The issue occured because Qlik has export limitations. insightsoftware has added messages to the UI informing you about exceeded limits. For more information, see Vizlib Table Download Options.

The columns and headers displayed incorrectly when the users changed data structure.

Nprinting report keeps the design of Vizlib Table.

Nprinting report keeps the design of Vizlib Table.

When the users used a variable in the Master Font Color, the text in the table changed to white after hovering on it. The color did not change back to the original color and, as a result, the text was invisible if no background color was set.

The Totals column was missing after the users exported data to Excel.

The values in Totals horizontal line did not update properly after the users changed the column order.

The export option in Excel failed when fields were hidden.

The formatted data exported into Excel did not work as expected.

The representation icon (arrow) was no longer visible when any change was made.

When the sheet was embedded in Qlik or the Vizlib container, data was not visible when the user exported the sheet to PDF.

Filter pop up inconsistencies.

Export formatted data to Excel in Qlik Saas ignores time formatting.

Mini Chart format/height is not working as before.

Export to Excel is not keeping the date format.

Last few digits are cut off. For some charts where the hover scroll bar appears, the rightmost column does not display the last few digits of a number.

Excel export icon not visible in native Qlik container. Exporting using the quick export feature was not appearing in the Qlik container

Pinned column filtering. When using the pinned column and you were filtering whilst the Table is in an alternate state, the applied selection wouldn't apply the selection to the table.

Improved error handling for Viztips. In some situations on resize the error VZB001 would break the rendering.

Viztips does not display correctly or at all. Viztips would not appear correctly in combination with maximized objects.

Viztips is not visible when we have KPI Designer with template on the same sheet. When using a KPI Designer with a template on the same sheet as a Viztip the Viztip would not appear.

Cannot copy Header cell values. It was not possible to copy the cell value of a header cell.

Whitelist Custom Report to be allowed to display the export icon. The small icon included in table for exports did not display in Custom Report. With these changes and changes in Custom Report it will now work. See changelog for Custom Report for more details.

Vizlib Table non-formatted exports removes null values. When exporting data to Excel/CSV, a row containing a null value was not being exported. Formatted export worked as expected.

Actions for Vizlib charts when using Alternate states. When making actions whilst using Alternate states for Vizlib charts, you will now see a new section within the following actions (see list below image). This will control the Action to apply it's action to a determines Alternate state.

When Alternate state is defined as <Default state> that will apply to all charts that have no Alternate state applied to them.

List of Actions that have Alternate states assigned to them:

• Unlock all (Unlock all selected) Clear all

• Unlock and clear all

• Lock all (Lock all selected)

• Clear field

• Unlock field

• Select possible

• Select alternative

• Select excluded

• Lock field

• Selection in field

Note: We are rolling this out for other charts. To ensure you're getting the latest features, please keep the extensions upgraded.

Column Deletion is not reflected on the Table. When trying to delete a column from the Vizlib Table, the column is removed from the data but not on the visualisation itself.

Scrolling hid mini charts. When you have several columns with a measure representation of Minicharts, scrolling stops the Minicharts from showing up.

Wrap text mode for measure\dimension field. In the Vizlib Table's property panel > Appearance > Rows > when Row height is set to Auto, the option 'Wrap text in cell' will wrap the text in the Table's rows.

Column misaligned with headers when using different window sizes. When changing the view size of the Vizlib Table, the column headers would become misaligned.

Text is cut-off when auto-height is used. You can now set the 'Min row height' for your Vizlib Table.

Incorrect Number Format when using Formatted Export.

Using the formatted export option for the Vizlib Table determines the thousand and decimal separators based on the user settings from their computer.

In this release we pass the information over to Excel and let Excel determine the correct separators based on the user's settings.

As a result of this, when sending files from different countries, Excel will show the user their separator symbols as this is now determined by Excel. For example:

UK

Thousand = ' , ' (comma) Decimal = ' . ' (point)

Poland

Thousand = ' ' (space) Decimal = ' . ' (point)

Sweden

Thousand = ' ' (space) Decimal = ' , ' (comma)

Note: This does mean that your user may download file which does not look like what they see on the Qlik Sheet. This is because the Vizlib Table respects the defined separator symbols in the Qlik Load Script.

Recalculation of Table on Selection. Table performed recalculations every time a selection was made.

Horizontal Scroll bar reverts to first column when trying to use the Vertical Scroll. When scrolling the table using the horizontal scrollbar and then clicking on the vertical scrollbar, the horizontal scrollbar resets.

Indicator in Totals won't respect the actual color if color is loaded via DLE. When specifying a color in the indicator property then the colors are displayed correctly. However, if a variable is used to define the colours then inconsistencies would occur in the Totals row.

Unable to view the export options in Qlik SaaS Government. When trying to right-click on the Container Grid in the Qlik SaaS Government environment, customers don’t see the Export option for the Vizlib Table within.

Export formatted data to Excel doesn't keep all the formats. When you export the formatted Vizlib Table with the option “Export Formatted Data to Excel“, not all formats are kept.

Indicator Range. We have made a significant improvement to our indicator range. Now you are able to define specific indicator ranges that you can use to highlight your table data based on the criteria you set out. By going to a Measure column, find the Indicators option and define your indicator ranges with.

Improved scroll mechanic. We are constantly looking at ways to improve our products and being able to seamlessly navigate your Vizlib Table is important. This is why we invested the time to improve our scroll mechanic to provide our Customers and Users with a better experience.

Mashups hosted on standalone server throws Windows Authentication error. When using the Vizlib Table in a mashup, “Windows Authentication” console log errors are displayed.

SaaS - Quick export button is not rendering/isn't displayed. The permission check for displaying the Quick Export Button ('Show Export Icon' in the property panel) so we have added a button which will always display the icon. Please read the information below.

• If the checkbox is NOT selected = False (default option), Export to Excel icon will be visible only to users withrelevant export permissions.

• If the checkbox is selected = True, Export to Excel icon will be visible to all users no matter what permissions they have been assigned.

SaaS - Colored background on the exported file if using a dark template.

Exporting the Vizlib Table would result in a dark background on the Excel export even if you have no formatting.

Exporting formatted data not working as expected. Exporting using the Table when you had an expression which hid the data [ =if(field = true, '', field) ] the table would still export some data. This has been fixed to ensure the Table respects your properties.

Sorting is not kept when exporting to Excel if Vizlib Table is Master Visualization. In the Vizlib Table you can click on the header (column) to sort the data. If you use this option and export the data the sorting will be kept. However, if the Vizlib Table is a Master Visualization, then exporting the data will keep the original sorting, regardless of what sorting you have selected from clicking on the header (ASC/DESC).

Search icon isn't displayed in Mashup when getting objects from multiple apps. You can now filter dimension’s column values on tables that come from different apps within your Mashups. Before this fix you could only filter these dimension’s column on the first loaded table, meaning any other table that references another Qlik Application would not respect the search functionality.

"Quick export" is not handling security rules of Qlik Sense. The 'Quick export' now respects your Qlik environment's security rules. So if you have users who are not allowed to export then this option will not appear for them.

Static or dynamic total position. It is now possible to control if totals sit as the last row or at the very bottom of the table. When the Table is set to adjust the size after the content the total will be the last row (right after the rows of data). When it is set to fill it will position the total at the bottom.

New Mini Chart- Control Chart.

Option to Include Selections & header, subtitle, Footer in formatted Export.

Duration Data Type not showing formatted value on the bullet chart tooltip.

Search field sometimes becomes unresponsive when Table inside Qlik Container.