Angular Pivot Grid Component

The Pivot Grid component for Angular is a lightweight and powerful data visualization widget.
It allows visualization of multi-dimensional and hierarchical data structures.

It also ships with a Pivot Table Designer widget. The Pivot Table Designer allows you to visually configure the pivot columns, rows, aggregated values and multiple different settings. You can also configure pivot rows and columns text alignment settings and various text formatting options on the pivot cells.

Before you start with the Pivot Grid widget, you should be familiar with pivot tables and understand when to use regular data grids to display table data, and when to switch to the pivot grid and pivot tables. The following article is a good entry-level introduction to pivot tables: Wikipedia: Pivot table

Prerequisites

Refer to Angular Getting Started before you start with this help topic.

Configuration

The Pivot Grid component for Angular requires the following imports.

Mark a class as an Angular component through the @Component decorator:

The full list of @Component decorator properties is available on: Angular @Component Decorator API

Every jQWidgets Angular component has an [auto-create] attribute which determines whether the component is automatically created or is created on demand by API method call.
By default, the [auto-create] attribute value is true.


Create the AppComponent class.

The AppComponent class is used to instantiate the app. In some of the examples, we use @ViewChild and ngAfterViewInit.

The following example demonstrates the PivotGrid component for Angular.

Run Code

Create PivotGrid component with JSON

Properties

The properties which are defined as attributes can be changed directly:

To get or set a property, which we did not define or call a method, we can do the following:

Every component has a method setOptions which accepts a JSON object as an argument. This object contains component settings and you can use it to set a single or multiple properties dynamically.

Events

The following example demonstrates how to add an event listener:

Note: Event Names of the PivotGrid component for Angular are the same as the Event Names of the jqxPivotGrid widget. The only thing you need to do is to put "on" before the event name and upperCase it's the first letter.

Methods

The following example demonstrates how to invoke methods of the PivotGrid component for Angular.

PivotGrid Examples

For the full list of examples available please visit the Demo Page

PivotGrid API

API Reference of the jQWidgets PivotGrid component for Angular: PivotGrid API