Vizlib Home Try Vizlib

Vizlib Pivot Table Best Practice and Troubleshooting

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.


Best Practice

  • 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. 

Back to Contents

Known Issues

Native HyperCube - Default Behaviour (V3.0+)

There have been some changes to the default behaviour of 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.

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.

Back to Contents

Kenneth is the author of this solution article.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.