When you're working with Vizlib Pivot Table it's important to be clear about what you can and can't do. We've collected together some best practice tips, and also listed any known issues in this article for you.
TABLE OF CONTENTS
- Best Practice
- Known Issues
- Let's introduce you - If you're new to Vizlib Pivot Table, or looking to find some information, the Introduction page has links to all the product resources and knowledge base articles.
- Work with the wizard - Always use the Setup Wizard to start building your pivot table, you can always add expressions or edit data in the property panel once you have the basic version.
- Use templates - Templates in Vizlib Pivot Table help you apply a look and feel instantly, saving you time and effort. You can even design your own and save them.
- Performance - Vizlib Pivot Table runs using the Qlik Sense hub engine and each individual value is processed separately, which could affect performance if you're working with very large amounts of data. We've listed some recommendations to help you manage this risk, and there's also some general advice about improving performance in Qlik Sense here
- Upgrade - v3.0.0 of Vizlib Pivot Table involved an extensive re-design and has improved support for calculated conditions and bookmarks, as well as general performance. We recommend upgrading to this version if you'd like to take advantage of these improvements.
- Mini Charts - Mini charts can affect performance in a pivot table so it's best to limit them to small numbers of cells.
- Calculations and dynamic formatting - using calculated dimensions in a pivot table will take longer to process. Data in the pivot table is loaded as the user scrolls through to try and help with performance, but this can be optimized by upgrading to the latest version of the extension.
Native HyperCube - Default Behaviour (V3.0+)
There have been some changes to the default behavior of the Vizlib Pivot Table with the release of V3.0. We've listed them here.
- Totals are only available for the first dimension in Indent mode. Totals for the second (and any following) dimensions are enabled, but invisible.
The following features are no longer supported:
- Order changes for Sorting and Dimensions property panel settings.
- Downgrading a Vizlib Pivot Table created in V3.0 to a previous version.
- Dimension Visibility and Measure Visibility options.
- Same/duplicated dimensions.
- Totals for left dimensions (except the first dimension) are turned on when you're changing from Indent to Not Indent mode.
Vizlib table resets to the left after scrolling and sorting
Horizontal Scroll repositions to the left (that is, to the start) after any change (for example, after sorting the last column).
Formatted Excel Export - Qlik Sense Desktop
When a formatted Excel export is selected for the Pivot Table, an error is returned in Qlik Sense Desktop. As a workaround, we recommend the following steps.
- Open the Qlik Sense Desktop app in your web browser.
- Enter the URL http://localhost:4848/hub/my/work
- The URL should open the Qlik Sense Desktop.
- Attempt the export again. It should proceed without any errors.
Formatted Excel Export - Exporting icons
- The only supported icon to export is the arrow icon. Other shape icons will not export to excel.
- As a workaround, we recommend the following steps.
- If it is business-critical to have icons, it's recommended to change your icon to the arrow icon for formatted excel exports.
nPrinting / Remove HC (pre v3.0.0)
From v3.0.0 of Vizlib Pivot Table all printing is done using the normal Qlik method. The steps below are only for versions earlier than that.
nPrinting Table mode export (Figure 1) if you'd like to export your data to a table in nPrinting, although this can affect the performance of your pivot table calculations. You can find out more about nPrinting with Vizlib extensions here.
There is also a Remove Custom HC button which gives you the option to remove the custom Hypercube.
This will convert your existing pivot tables and make them compatible with version 3.0.0 of Vizlib Pivot Table.
Figure 1: nPrinting / Remove Custom HC
If you choose Remove Custom HC you'll be asked to confirm the action as it can't be reversed.
Figure 2: Remove Custom HC Confirmation