Pivot Table Overview

Vizlib Pivot Table is a highly customizable, supported, and feature-rich table extension for Qlik Sense and Qlik SaaS.

The Vizlib Pivot Table provides features such as dynamic labels, indicators, font and size control, interactivity, colors, pivot styles, and more, far exceeding the standard capabilities of the native Qlik Sense Object.

Features of Vizlib Pivot Table include:

  • Conditional show/hide of dimensions and measures based on Qlik expressions.

  • Rich customization and formatting options permit you to achieve nearly every desired design.

  • Conditional Formatting to style your Pivot Table based on Qlik expressions.

  • Different Pivot Styles: Indented or fully expanded.

  • Indicators for Measures: Supplement your metrics with a colored indicator to highlight changes or growth or to annotate your metric with a symbol.

  • Export Pivot Table data in a tabular format to XLSX in both Qlik Sense and Qlik SaaS.

Vizlib Pivot Table is part of the Vizlib Library product suite; you can learn more about Vizlib Library by watching our product demonstration.

We've organized our documents into several categories, and to make them easy to find, we've included keywords in the document title.

This topic contains the following sections:

Introduction

This page helps you get started with Vizlib Pivot Table and explains where to find the information you need.

If you're new to our products, why not watch our video on getting started with Vizlib?

You can find the latest version of the Vizlib Pivot Table on our User Portal in the Library section of the Downloads page. The software includes an installation file and a demo app showing you how Vizlib Pivot Table works, and you can visit our Demo Apps Gallery, where you can search for examples to get started. You can also download the product catalogue here.

Guides

Guides are articles that contain technical information relating to Pivot Table.

Vizlib products all have the same installation process, and there are installation guides for Qlik Sense server and desktop. Vizlib Pivot Table uses a setup wizard to help you get started quickly.

Properties

Properties articles contain information on the Property Panel, which you use in the Qlik Sense Hub to manage functions for the Vizlib Pivot Table.

The articles cover:Templates, Dimensions, Measures, Sorting and Data Handling, Pivot Table Settings, Export options for both Qlik Sense and Qlik SaaS, Appearance, and Interactivity.

Best Practice and Troubleshooting

You can use our Best Practice and Troubleshooting article here to start working with Vizlib Pivot Table.

Changelog

The Changelog contains details for each release of Vizlib Pivot Table, such as new features and bug fixes. You can find the changelog here, and sign up to receive notifications of new releases for all Vizlib products here.

Pivot Table Examples

Breaking Down and Highlighting Data

Figure 1: Showing a Vizlib Pivot Table used to break down and highlight data

Profit and Loss Table

Figure 2: P & L example

Measure Indicators

Figure 3: Pivot table with Measure Indicators

Vizlib Pivot Table with Customized Formatting

Figure 4: Customized formatting options

Related Articles: