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

I. Imports

The Pivot Grid component for Angular requires the following imports.

II. @Component Decorator

A class is marked as an Angular component through the @Component decorator:

selector - CSS selector that identifies this component in a template
styles - inline-defined styles to be applied to this component's view
styleUrls - list of URLs to stylesheets to be applied to this component's view
template - inline-defined template for the view
templateUrl - URL to an external file containing a template for the view

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.

III. Create the AppComponent class

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

@ViewChild: makes a reference using a PivotGrid selector. View queries are set before the ngAfterViewInit callback is called.
@ViewChild('pivotGridReference') myPivotGrid: jqxPivotGridComponent;
ngAfterViewInit - this is an Angular Component Lifecycle method in which we create our angular components. After the view is initialized, myPivotGrid is available.
For more information about this methods please refer to Angular Component Lifecycle API

The following example demonstrates the PivotGrid component for Angular.

Run Code

IV. Create PivotGrid component with JSON

Add the imports.
import { Component, ViewChild, AfterViewInit } from '@angular/core';
import { jqxPivotGridComponent } from 'jqwidgets-ng/jqxpivotgrid';
@Component decorator:
```
@Component({
    selector: 'app-root',
    template: `<jqxPivotGrid #pivotGridReference [auto-create]="false"></jqxPivotGrid>`
})
```
Create the AppComponent class.
- @ViewChild: makes a reference using a PivotGrid selector. View queries are set before the ngAfterViewInit callback is called.
```
@ViewChild('pivotGridReference') myPivotGrid: jqxPivotGridComponent;
```
- ngAfterViewInit: All Angular components have an integrated method called createComponent that accept a JSON object with the component initialization properties. If no argument is passed, default properties will be used. If you would like to dynamically set properties after creation, you can use the setOptions method.
```
ngAfterViewInit(): void
{
    this.myPivotGrid.createComponent(this.pivotGridSettings);
}
```
The following example demonstrates how to create a PivotGrid component for Angular by using the createComponent method.

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:

Import @ViewChild decorator:
Add the PivotGrid component:
Get access to the PivotGrid component and its API:
Finally, we can call methods or set/get properties like that:

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