Description This is an example of the Angular Pivot Grid Component with the pivot values displayed along the pivot columns. The Angular PivotGrid can displays the pivot values fields either below each column or on the right side of each pivot row. The default behavior is to display the pivot values along the columns. To change it this option modify the pivotValuesOnRows property in the pivot data source.
A live Angular example of jqxPivotGrid, the jQWidgets PivotGrid component, with its complete source code below. It is one of 12 jqxPivotGrid demos for Angular.
source property – Gets or sets pivot source adapter used to supply data to the pivot grid.multipleSelectionEnabled property – Gets or sets whether the multiple selection in the pivot grid is enabled or disabled.treeStyleRows property – Gets or sets the rows of the pivot grid are displayed as a tree structure or using classic OLAP style.autoResize property – Gets or sets if the size of pivot grid adjusts automatically to display the entire content.refresh method – Refreshes the content of the pivot grid componentgetPivotRows method – Return the pivot rows of the pivot gridTo run it in your own app, install the package with npm install jqwidgets-ng, add these files to a standalone Angular CLI app, and add jqx.base.css and a theme to the styles in angular.json. Getting started with jqxPivotGrid shows the setup step by step.
import { Component, AfterContentInit, AfterViewInit, viewChild } from '@angular/core';
import { jqxPivotGridComponent } from 'jqwidgets-ng/jqxpivotgrid';
import { CommonModule } from '@angular/common';
import { jqxPivotGridModule } from 'jqwidgets-ng/jqxpivotgrid';
@Component({
imports: [CommonModule, jqxPivotGridModule],
selector: 'app-root',
templateUrl: './app.html',
styleUrl: './app.css'
})
export class App {
readonly pivotGrid1 = viewChild.required<jqxPivotGridComponent>('pivotGrid1');
constructor()
{
this.pivotDataSource = this.createPivotDataSource();
}
ngAfterViewInit(): void {
this.pivotGrid1().getPivotRows().items[0].expand();
this.pivotGrid1().refresh();
}
getWidth() : any {
if (document.body.offsetWidth < 850) {
return '90%';
}
return 850;
}
pivotDataSource: null;
createPivotDataSource(): any {
// prepare sample data
let data = new Array();
let firstNames =
[
"Andrew", "Nancy", "Shelley", "Regina", "Yoshi", "Antoni", "Mayumi", "Ian", "Peter", "Lars"
];
let lastNames =
[
"Fuller", "Davolio", "Burke", "Murphy", "Nagase", "Saavedra", "Ohno", "Devling", "Wilson"
];
let productNames =
[
"Black Tea", "Green Tea", "Caffe Espresso", "Doubleshot Espresso", "Caffe Latte"
];
let priceValues =
[
"2.25", "1.5", "3.0", "3.3", "4.5", "3.6", "3.8", "2.5", "5.0", "1.75", "3.25", "4.0"
];
for (let i = 0; i < 100; i++) {
let row: any = {};
let productindex = Math.floor(Math.random() * productNames.length);
let price = parseFloat(priceValues[productindex]);
let quantity = 1 + Math.round(Math.random() * 10);
row["firstname"] = firstNames[Math.floor(Math.random() * firstNames.length)];
row["lastname"] = lastNames[Math.floor(Math.random() * lastNames.length)];
row["productname"] = productNames[productindex];
row["price"] = price;
row["quantity"] = quantity;
row["total"] = price * quantity;
data[i] = row;
}
// create a data source and data adapter
let source =
{
localdata: data,
datatype: "array",
datafields:
[
{ name: 'firstname', type: 'string' },
{ name: 'lastname', type: 'string' },
{ name: 'productname', type: 'string' },
{ name: 'quantity', type: 'number' },
{ name: 'price', type: 'number' },
{ name: 'total', type: 'number' }
]
};
let dataAdapter = new jqx.dataAdapter(source);
dataAdapter.dataBind();
// create a pivot data source from the dataAdapter
let pivotDataSource = new jqx.pivot(
dataAdapter,
{
pivotValuesOnRows: false,
rows: [{ dataField: 'firstname' }, { dataField: 'lastname'}],
columns: [{ dataField: 'productname' }],
values: [
{ dataField: 'price', 'function': 'sum', text: 'sum', formatSettings: { prefix: '$', decimalPlaces: 2 } },
{ dataField: 'price', 'function': 'count', text: 'count' },
{ dataField: 'price', 'function': 'average', text: 'average', formatSettings: { prefix: '$', decimalPlaces: 2} }
]
}
);
return pivotDataSource;
}
}
<jqxPivotGrid
#pivotGrid1
[width]="getWidth()"
[height]="400"
[source]="pivotDataSource"
[treeStyleRows] = "false"
[autoResize] = "false"
[multipleSelectionEnabled] = "true"
>
</jqxPivotGrid>