Skip to main content

Vizlib Pivot Table Changelog

The following changes were introduced to Vizlib Pivot Table:

3.17.5

2026-04-13

Resolved Issues

  • Fixed an issue where dimensions were displayed vertically instead of horizontally. (VIZ-23090)

3.17.4

2026-04-09

Updates

  • Moved all Vizlib-based export options to the Export Data submenu accessible on right-click.

  • Added CSV and TSV export options to the Export Data submenu. (VIZ-22856)

Resolved Issues

  • Fixed an issue where the Vizlib Pivot Table could appear blank in PDF exports. (VIZ-22686)

  • Fixed an issue where custom currency number formatting applied to Pivot Table measures was not correctly interpreted when exporting to formatted Excel. (VIZ-23037)

  • Fixed an issue where using the Vizlib Button's "Export Object Formatted Data" action to export a Pivot Table resulted in misaligned headers and column data. This occurred when the Pivot Table master item was located on a different sheet than the button triggering the export. (VIZ-23060)

3.17.3

2026-02-16

Resolved Issues

  • Fixed an issue where using the Remove Custom HC option in the property panel caused dimensions and measures to reorder unexpectedly. (VIZ-22777)

  • Fixed an issue where exporting data from the Vizlib Pivot Table failed or produced incorrectly formatted files after adjusting migration settings in the property panel by:

    • simplifying export menu options.

    • showing a default export dialog with the following options: Include Formatted - runs export to Excel with styled sheet appearance, Export as straight table - if enabled runs native export to Excel as straight table, otherwise as pivot table.

    • implementing a dialog that pops up after triggering the button and enables users to continue export. In mashups, after triggering the button, dialog won’t show up, but the export process starts in background and overlay with the cancel button visible. (VIZ-22849)

3.17.2

2025-12-19

Resolved Issues

  • Fixed the issue where the Collapse All and Expand All options were not working when accessed through the right-click menu on pivot table dimensions in Qlik SaaS. Manual collapse/expand functionality was unaffected. (VIZ-22740)

3.17.1

2025-12-01

Resolved Issues

  • Resolved the issue where actions (such as setting variables) were executed before the selection was applied when clicking on measure values in the Pivot Table. (VIZ-22652)

3.17.0

2025-11-06

Updates

  • Vizlib Pivot Table sends anonymous usage data to insightsoftware. If you don't want the extension to send anonymous usage data to insightsoftware, you can disable the Send anonymous usage data checkbox in User Portal > Account Management > Settings. Disabling this option is available only for users with any Enterprise and Professional licenses and applies only to products with such licenses. Freemium products will send anonymous usage data to insightsoftware.

3.16.0

2025-10-13

Resolved Issues

  • Resolved the issue with Qlik Map Object caused by Vizlib Pivot Table. (VIZ-22431)

3.15.0

2025-09-18

Updates

  • Angular update. (VIZ-21420)

Improvements

  • Improved snapshot detection and printing mode. (VIZ-22103)

Resolved Issues

  • Resolved the issue with Export Date format in Excel. (VIZ-22086)

Rebranding

  • Rebranded the About Vizlib Pivot Table section of the Property Panel to reflect insightsoftware visual style. (VIZ-22124)

3.14.0

2025-03-20

Rebranding

  • The extension has been rebranded to reflect insightsoftware visual style. You may notice visual differences in the extension. (VIZ-21870)

3.13.1

2025-01-22

Resolved Issue

  • Resolved the issue where the Measure title changed position from column to row. Currently, if there are two identical dimensions, the software displays the Incomplete Visualization message for any existing and new Pivot Table. In case you use expressions that can result in duplicated dimensions, insightsoftware recommends you use the Show column If property to eliminate such duplicates. (VIZ-21458)
  • Resolved the issue where the Pivot Table placed in the dynamic view displayed only the first time a selection was made, and wasn't displaying for subsequent selections. (VIZ-21776)
  • Resolved the issue where the column titles shifted after users exported Pivot Table data, resulting in an incorrect output display for column data values. (VIZ-21809)
  • Resolved the issue where the Pivot Table configured to color negative values red, colored also the positive values red after the dashboard resize. (VIZ-21811)

3.13.0

2024-12-17

New Feature

  • The Cell text is URL option has been added to Dimension settings in the Property Panel. By enabling the option, you can turn the URL, previously represented as plain text, into a clickable link. For more information, see Turn Text into a Clickable Link. (VIZ-21348)

3.12.1

2024-11-28

Improvement

  • When you select two identical dimensions in the Property Panel, the software displays the Incomplete visualization error message in the analysis mode. (VIZ-21749)

Resolved Issue

  • When the users dragged dimensions from the Dimensions area to the Measures area, the application refreshed and the dimensions reverted to their original positions. Currently, the dimensions can be successfully added to the Measures area. (VIZ-21625)
  • Measure header title didn't display when the users selected only one measure. Currently, the header displays properly when you select only one measure. (VIZ-21600)

3.12.0

2024-10-15

New Feature

  • Possibility to enable and disable formatted export in the Property Panel. For more information, see Enable or Disable Formatted Export. (VIZ-21513)

3.11.0

2024-09-10

Resolved Issue

  • When the users selected between 2 to 6 dimensions in their application, the Measures title changed its position from column to row. (VIZ-21426)

3.10.2

2024-08-30

Resolved Issue

  • The Preserve white space option was not working for old reports after upgrading the version from 3.9.1 to 3.10.1. (VIZ-21426)

3.10.1

2024-07-01

Resolved Issue

  • Color formatting was not working. (VIZ-21224)

3.10.0

2024-06-11

Functionality Update

  • The scope of the Vizlib Freemium license has changed. Please, see the Pricing and Subscriptions FAQ to see how the changes affect your use of Vizlib Pivot Table.

Resolved Issue

  • When the users used Vizlib Pivot Table inside Qlik Container and wanted to access the applied bookmarks, the tab quickly switched to a different tab and the Access Denied error message was displayed. (VIZ-21215)

3.9.1

2024-04-23

Resolved Issue

  • A formatting mismatch was identified in the Pivot table. (LIB-13745)

3.9.0

2024-02-28

New Feature

  • The attribute expression switch has been introduced. (VIZ-14423)
  •  

    The switch is available only for newly created objects or for objects with migrated attributes. The switch has two states:

    • Enabled - Indicates the expression is evaluated once for the whole extension. Use this whenever the expression allows.
    • Disabled - Indicates the expression is evaluated once per cell. Use this only when necessary since it may affect the performance.

    Measure fields with the attribute switch:

    • Measure / Border - Custom / Border Size
    • Measure / Font size - Custom / Size
    • Measure / Font style - Custom / Bold font style if
    • Measure / Font style - Custom / Italic font style if
    • Measure / Font style - Custom / Underline font style if
    • Measure / Font style - Custom / Shadow font if
    • Measure / Representation - Indicator / Indicator threshold

Resolved Issue

  • When users expanded Pivot Table rows, the software displayed the following error message: Your quota limit of {0}MB was exceeded. You loaded {1}MB. Reduce your data within this application or buy additional capacity. (VIZ-14423)
  • When users changed the measure representation type, the software displayed the JSON parse message with -32700 error code. (VIZ-13343)
  • Software performance was slow after users transformed a regular Qlik Table into Vizlib Pivot Table. (VIZ-14079)
  • The Time Out error occured when the user selected the Expand All option. (VIZ-13342)

When the software displays the error message as in bug ID VIZ-14423, insightsoftware recommends you manually trigger the migration process for the hypercube attributes by following the instruction:

  1. Duplicate the sheet where the corrupted Pivot Table is present (as a backup sheet).
  2. Go to the Property Panel for the Pivot Table > Pivot Table Settings and click the button Migrate attributes button.
  3. Check for errors in the browser's console log and make sure everything works as before the migration process, for example colors or values.

If the Qlik Sense Error The request exceeds the memory limit continues to occur after expanding the rows, consider that there may be changes required to your data model.

If the QS error doesn't occur, follow the same migration steps for the original object.

Change

  • The label for the calculation field for dimensions and measures in the Property Panel has been renamed from Calc. Condition to Show column if. (VIZ-14423)
  • For measure font style section in the Property Panel: (VIZ-14423)
    • The Bold font style label renamed to Bold font style if.
    • The Italic font label style renamed to Italic font style if.
    • The Underline font style label renamed to Underline font style if.
    • The Shadow label renamed to Shadow font if.

3.8.2

2023-11-02

Improve Performance

  • Performance improvements. In this latest release we have fixed several performance issues that customers experienced. The improvements will help to improve the development and user experience of the Vizlib Pivot Table. (LIB-13115)

3.8.1

2023-10-05

Resolved Issue

  • Export to Excel dimension column width doesn't replicate Qlik. When you have indent rows set to off, the exported dimension row column width would not be calculated correct. With this release we have solved for all export inconsistencies regarding dimension width. (LIB-13206)
  • Export Null cells background color are wrong. Some users experienced an issue when using measures which had null values within them. The exported color would result in white as a result of the color not being passed over to the formatted excel. (LIB-13119)
  • Expanding child makes parent disappear. When expanding a row dimension there would be an inconsistency which resulted on the parent dimension disappearing. (LIB-12848)

3.8.0

2023-09-15

New Feature

  • Text using expressions to define colour by dimension. Line in the release for the Pivot Table v3.6.0 you are now able to color by expression the text in dimension headers. (LIB-12843)
  • Re-ordering fields in pivot table/pivot table wizard. Reordering fields in the wizard now reflects the changes in the property panel for the Vizlib Pivot Table. We have also made changed to the way Totals are displayed and interacted with in Edit mode of the qlik app. There is now a switch called 'Remember totals' which, when selected remembers the toggle options of showing totals for dimensions. This is controlled via the property panel and in the Setup/Edit wizard. Also note that the options 'Total position' is now editable regardless of if 'Show all totals' is toggled on or off. (LIB-11948)

    Finally, you can also use the Vizlib Pivot Table when using calculated fields.

  • Formatted Export to Excel should reflect the result on screen. A default option is now implemented which will eventually be the default method of exporting to Excel. Export column width has been implemented to ensure consistency when exporting your Vizlib Pivot Table to Excel from Qlik. (LIB-11433)
  • Add Measure and Dimension Title (Supports HTML) option to the pivot table. Like in the Vizlib Table where you are able to have HTML support for Headers, the Vizlib Pivot Table has this functionality as of this release. The Pivot Table allows to change the label (with HTML support) for the HEader label and Label (aka pill). (LIB-12810)
  • Add "Rules" indicator range to the Pivot Table Indicator option. Line in the Vizlib Table v3.22.0 release you can now use advanced rules to calculate your pivot table indicator ranges. (LIB-12800)

Resolved Issue

  • The context menu overlaps the export icon. In Qlik Cloud, the Pivot Table's context menu (on hover) overlapped it's ability to select the export to excel/wizard option. (LIB-12778)

3.7.0

2023-06-19

Improve Performance

  • Difference in loading between different cell heights. Comparing the performance between a Vizlib Pivot Table with a cell height of 32px and another with 16px the larger cell height (32px) performed better than the smaller cell height (16px). This was impacting initial loading and scrolling times. (LIB-12352)

Resolved Issue

  • Cell borders disappear when scrolling vertically through huge data. When a lot of data is in the Vizlib Pivot Table and the user scrolls, the cell border color disappears. (LIB-12755)

3.6.0

2023-04-26

New Feature

  • Expression driven color calculations for Dimension rows and columns. You can now change the row and column colors using an expression to provide more than just one distinct color output. Simply add an if() statement (for example) to the 'Background color' feature under the dimension you want the styling to be applied to. You don't need to specify if the color should appear on the column or row orientation, we automatically apply that for you. This means you can achieve results like the below image without needing to specify the name of the value which was required in the previous solution, 'Dynamic Styling'.

    Please be aware of the original 'Dynamic Styling' feature will be deprecated and no further improvements will be made to this feature thanks to the implementation of this release.

    Note: This dynamic styling option is calculated on the row level, therefore if you have an extensively large pivot table with many rows or columns of data, you may encounter some performance decreases. Encountering this performance decrease is low and won't be noticed in most Vizlib Pivot Table's, for those users who have many rows of data, they could experience some performance issues. A feature will be implemented in the next release to allow for distinct or dynamic color calculations.

  • Improve scroll bar behaviour in Vizlib Pivot. To keep your Vizlib Pivot Table clear of any distractions we have implemented the a 'hover to show' scrollbar. This will keep your data free of distractions.

    Scrollbar

    No Scrollbar

3.5.2

2023-01-31

Resolved Issue

  • Export to excel in Qlik Saas isn't working. In Qlik SaaS if you have not removed your Custom Hypercube from the Pivot Table then when trying to download the data, you would be presented with this modal..Because of this we have created a custom popup that will allow you to download the .XLSX file (but limitations may apply depending on the size of the data you are trying to download).

    In this popup, we have implemented Vizlib's first 'Error Code' which you can look up on our documentation page to learn more about the issue and how to rectify it. Please look here for all information about the error code.

    Please follow this guide to remove the custom hypercube.

    (LIB-11802)
  • When Dynamic Styling is Set, Hiding the Column results in a frozen extension. If you have a calculation condition that hides a column then the resulting calculation makes the pivot table freeze and become unresponsive. (LIB-12029)
  • Scroll bar issue. When there is a scroll bar and when the user is filtering on a single value or performing a filter that does not require a scroll bar, the data disappears and the scroll bar jumps down until the user manually returns it back to the top. (LIB-11470)
  • Export to Excel displays incorrect measure format based on the order of the measures in the Column Definition. When using Formatted fast export of data, the exported report has the incorrect format as opposed to the chart. A cause for this incorrect display appears from the order of the measures displayed in the Column Definition. (LIB-11844)

3.5.1

2022-11-16

Resolved Issue

  • Scroll bar issue on tablet and mobile. The scrollbar wasn't working on tablet and phone views. (LIB-11470)
  • Export to pdf/image doesn't work properly. When exporting the Vizlib Pivot Table, the Progress bars are in the wrong place and don't resemble what is being shown in Qlik. (LIB-11239)
  • Scrolling on iPad isn't working unless we use the scrollbar. The scrollbar would stay where you left it when filtering your Pivot Table it would stay there making it seem like you have not data. (LIB-11118)

3.5.0

2022-10-18

New Feature

  • In Alternatives screen, not possible to edit measures when opening. (LIB-11249)

Resolved Issue

  • Totals defaulting in v3.+. (LIB-11428)
  • V3.4.3 does not show entered custom tooltip on Dimensions. (LIB-11423)

3.4.3

2022-07-20

Resolved Issue

  • Remove custom HC adds an extra '=' to the Data Handling expression. (LIB-11283)
  • Dimension with Column(top) position isn't displayed in pivot table v3.3.3. (LIB-11192)

3.4.2

2022-06-28

Resolved Issue

  • License calculation issue. (LIB-11272)

3.4.1

2022-06-03

New Feature

  • Include back the Wizard Search functionality in Analysis Mode. (LIB-11229)

Resolved Issue

  • Pivot Table v3.3.3 is missing the Row Cell size slider. (LIB-11175)

3.4.0

2022-05-31

Resolved Issue

  • Incorrect Dimensions Positions. (LIB-11091)
  • Missing Rows in Display. (LIB-11210)
  • Wrong Selections Behavior and Hypercube Error. (LIB-11110)
  • Upgrading Pivot Table to 3.X tree - "Performance Improvements can be applied" message persists. (LIB-11072)
  • Row Title isn't affected by the "Italic" Font style. (LIB-11055)

New Feature

  • Wizard Redesign. (LIB-11058)

3.3.3

2022-04-19

Resolved Issue

  • Pivot Table - Formatted export displays incorrect data format. (LIB-10982)
  • Pivot Table, Created in v3.2.1, doesn't allow Selection of Multiple Dimensions. (LIB-10776)
  • Dimensions with Calculation conditions not fulfilled and get removed automatically after turning measures into Dimensions in Analysis Mode. (LIB-11043)

3.3.2

2022-03-10

Resolved Issue

  • Vizlib Pivot Table Row Alignment Issues. (LIB-10938)
  • Visualization Issue for Null Values in the Pivot Table. (LIB-10935)
  • Pivot Table Displays Incorrect Data when the Second Dimension Has Fixed Number with 'Show others' Enabled. (LIB-10882)
  • Pivot Table Total Label Changing Not Saving. (LIB-10773)

3.3.1

2022-02-17

Resolved Issue

  • Fast Export in Qlik SAAS (Qlik Cloud) Fast Export icon isn't displayed in Qlik SAAS. (LIB-9911)

3.3.0

2022-01-24

Resolved Issue

  • Dimensions Sorting. (LIB-10357)
  • Upgrade From 2.12.8 to 3.0.1. (LIB-10664)
  • Font Color in Title Cell. (LIB-10625)

3.2.1

2021-11-26

Resolved Issue

  • Context Menu. (LIB-10536)
  • Dimensions Ordering in Analysis Mode. (LIB-10423)
  • Templates Usage. (LIB-10417)
  • Indicators Display. (LIB-10383)
  • Cells Background Color Display. (LIB-10258)
  • Duplication of Measures and Dimensions. (LIB-10043)

3.2.0

2021-10-27

New Feature

  • Page Freeze In Some Cases. (LIB-10385)

Resolved Issue

  • Page Freeze In Some Cases. (LIB-10385)

3.1.3

2021-10-18

Resolved Issue

  • Dynamic Styling. (LIB-10229)
  • Formatted export to Excel. (LIB-10211)
  • Console Error. (LIB-10086)
  • Alternate State Selection. (LIB-9559)
  • Calculation Condition Error. (LIB-10063)
  • Labels in Dimension Limitation. (LIB-9571)
  • Indicator Color. (LIB-9374)

3.1.2

2021-09-17

New Feature

  • Master Measures Format. (LIB-10047)
  • Tooltip and Ellipsis for Long Names. (LIB-9991)

Resolved Issue

  • Console Log Errors. (LIB-10088)
  • Calculation Condition for Dimensions. (LIB-10063)
  • Moving Measures from Rows to Columns. (LIB-10039)
  • Pivot Table Object Overlap Other Objects. (LIB-9351)

3.1.1

2021-09-02

Resolved Issue

  • Selection List Display. (LIB-10064)

3.1.0

2021-08-31

New Feature

  • Wizard New Design. (LIB-9016)

3.0.1

2021-08-11

Resolved Issue

  • Vertical Scroll Bar Behavior. (LIB-9714)
  • Horizontal Scroll Bar Initial Location. (LIB-9163)
  • Search Menu Display. (LIB-9313)

3.0.0

2021-06-29

Resolved Issue

  • Total Display. (LIB-9536)

New Feature

  • Preserve Pivot Table Design in Bookmarks. (LIB-7887)
  • Remove Custom Hyper Cube. This feature gives you the option to convert existing Pivot tables to the new build. Please Note you can't undo this action. (LIB-8506)

Vizlib Pivot Table Changelog - Older Releases

The following changes were introduced in older releases:

2.16.0

2021-04-23

New Feature

  • Header Display -New option. (LIB-8633)

2.15.0

2021-03-18

New Feature

  • Export Custom Null Values to Excel. (LIB-8443)

2.14.0

2021-02-26

New Feature

  • Display Mode Options. (LIB-3644)

2.13.0

2021-02-02

New Feature

  • Null Cells Representation. (LIB-8029)

2.11.0

2020-03-25

New Feature

  • Vizlib Templates are now available for the Vizlib Pivot Table. (LIB-4945)
  • Property Panel Search. (LIB-5288)

2.9.0

2019-11-13

New Feature

  • Create "Progress Bar" Measure Representation Type. (VZB-2191)

2.8.5

2019-11-06

New Feature

  • Add option to show/hide Search icon from dimension label. (VZB-2359)

2.8.2

2019-10-10

New Feature

  • Add ability Hide header row. (VSP-886)

2.8.0

2019-09-04

New Feature

  • Introduce showing totals at the bottom/right. (VSP-814)
  • Memory Optimisation. (VZB-1967)

2.7.0

2019-07-31

New Feature

  • Add "Auto fit" optionInclude Selections and header, subtitle, Footer in formatted Export in wrap text. (VSP-517)

2.6.0

2019-07-26

New Feature

  • Include Selections and header, subtitle, Footer in formatted Export. (VSP-691)
  • Implement New native export options | A faster way to export large datasets. (VZB-1669)

2.5.0

2019-07-23

New Feature

  • Highlight rows and columns on hover. (VSP-58)
  • New option to allow measure totals to inherit font color from measures. (VSP-687)

2.4.0

2019-07-17

New Feature

  • Pivot Table Horizontal Scroll Bar start position (see most recent data first). (VSP-572)
  • Vizlib Pivot Export file name updates. (VSP-635)
  • Implemented user-adjustable/draggable width for left hand side dimensions. (VSP-611)

2.3.0

2019-07-09

New Feature

  • Add option to ignore Custom Styles font color override when global font settings are blank. (VSP-574)
  • Set the export file name of a Vizlib Pivot Table according to object title/subtitle. (VSP-514)

2.2.1

2019-06-12

New Feature

  • Extended formatting for "Formatted Export to XLSX". (VZB-1554)

2.2.0

2019-05-28

New Feature

  • User-resizable columns. (VZB-1340)
  • Column sizing improvements, relative width options added. (VZB-381)
  • Implement export to Excel (XLSX). (VZB-1076)
  • Copy cell value in context menu. (VSP-516)

2.1.0

2019-05-10

New Feature

  • Implement in-cell selections. (VZB-1260)

1.6

2018-12-19

New Feature

  • added options to control the orientation of the columns. (160955644)
  • be able to control column height when dimension is on the top. (162717372)

1.5.1

2018-11-20

New Feature

  • implement pdf/ppt printing. (161206098)

1.5

2018-11-02

New Feature

  • implement pdf/ppt printing. (161206098)

1.4

2018-10-10

New Feature

  • Ability to set different column size (on the left panel) for each column in not-indent row mode. (160759079)
  • table rows getting cut. (160457927)
  • Alternative Modal - Accept/Cancel buttons are swapped. (160889090)

1.3

2018-09-25

New Feature

  • Added new alternative dimensions and measures selector.
  • Improved default settings.
  • Added new interactivity settings.
  • Added option to export data to CSV (Raw/Unformatted).
  • Vizlib Pivot Table is now supported in Qlik Sense Story Mode [No ID] Added more styling options on the Text Representation type.
  • Fixed CSS conflicts when the Vizlib KPI Designer and the Vizlib Pivot Table were added to the same sheet.
  • Fullscreen icon was behind the object in some scenarios. [No ID] Fixed toggle selection when clicking on the same cell twice.
  • Ellipsis '...' was not shown for titles when text was exceeding the header cell.

1.2.2

2018-09-13

New Feature

  • Fixed extension conflict between Vizlib KPI and Vizlib Pivot Table on the same sheet.

1.2.1

2018-09-08

New Feature

  • Fixed "Internal engine error" dialog that was happening when changing dimensions quickly. Fixed delta cache issue when switching dimensions in ad hoc mode.
  • Fixed "Cannot Read property 'value' undefined" error message that was showing up in some scenarios. Fixed session persistence when changing the pivot table properties. ie: When having expanded rows and changing properties in the panel the pivot was re-rendered and it was not keeping the expanded rows state. Fixed right click compatibility with Vizlib Container.

1.2

2018-08-28

New Feature

  • Added Expand/Collapse all option in context menu (right click).

1.1.2

2018-08-05

New Feature

  • Add ability to suppress indicators on export to excel, so cells are recognized as numbers and not as text. Renamed inherit stylings to 'Apply in title cell' + some better explanation of the feature.

1.1.1

2018-07-27

New Feature

  • Measures defined as expressions (with variables for example) were not working correctly. The Pivot Table was not rendering with the Vizlib Container.
  • Increased memory limits for the pivot table in big datasets [requires re-create the pivot table to fix this].

1.1

2018-07-20

New Feature

  • New pixel perfect export to excel, where it maintains coloring, style and format, for the visible rows of the pivot. Added option to individually control the text alignment of measures.
  • New performance and data limits enhancements on the pivot (requires to recreate from scratch if the pivot was added previously).

1

2018-07-10

  • First Release.

Was this article helpful?

We're sorry to hear that.