PivotGridFieldFilterValues.Clear() Method

Removes all elements from the PivotGridFieldFilterValues.Values array.

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.PivotGrid.v23.2.Core.dll

NuGet Packages: DevExpress.PivotGrid.Core, DevExpress.Win.Navigation

Declaration

C#

public void Clear()

VB.NET

Public Sub Clear

Remarks

Refer to the PivotGridFieldFilterValues topic for more information on the filter value collection.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the Clear() method.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

web-forms-pivot-grid-group-field-values-into-the-specified-intervals/CS/CustomGroupInterval/Default.aspx.cs#L42

ASPxPivotGrid1.Fields[4].Caption = "Year";
ASPxPivotGrid1.Fields[4].FilterValues.Clear();
ASPxPivotGrid1.Fields[4].GroupInterval = DevExpress.XtraPivotGrid.PivotGroupInterval.DateYear;

wpf-pivot-grid-apply-format-conditions-to-data-cells/CS/WpfPivotGridConditionalFormatting/MainWindow.xaml.cs#L48

{
    field.FilterValues.Clear();
    foreach (object filterValue in filterValues)

winforms-dashboard-add-custom-interactivity-to-dashboard/CS/Dashboard_CustomVisualInteractivity/Form1.cs#L40

fieldCategoryName1.FilterValues.FilterType = PivotFilterType.Included;
fieldCategoryName1.FilterValues.Clear();
foreach (AxisPointTuple selectedElement in e.CurrentSelection) {

aspxpivotgrid-field-calculation-bindings/CS/AspNetWebFormsPivotFieldCalculationBindings/Default.aspx.cs#L13

try {
    fieldProductName.FilterValues.Clear();
    fieldProductName.FilterValues.Add("Chai");

aspxpivotgrid-layout-upgrade-event/CS/ASPxPivotGridLayoutUpgradeEvent/Default.aspx.cs#L13

try {
    fieldProductName.FilterValues.Clear();
    fieldProductName.FilterValues.Add("Chai");

VB.NET

web-forms-pivot-grid-group-field-values-into-the-specified-intervals/VB/CustomGroupInterval/Default.aspx.vb#L49

ASPxPivotGrid1.Fields(4).Caption = "Year"
ASPxPivotGrid1.Fields(4).FilterValues.Clear()
ASPxPivotGrid1.Fields(4).GroupInterval = DevExpress.XtraPivotGrid.PivotGroupInterval.DateYear

winforms-dashboard-add-custom-interactivity-to-dashboard/VB/Dashboard_CustomVisualInteractivity/Form1.vb#L39

fieldCategoryName1.FilterValues.FilterType = PivotFilterType.Included
fieldCategoryName1.FilterValues.Clear()
For Each selectedElement As AxisPointTuple In e.CurrentSelection

aspxpivotgrid-field-calculation-bindings/VB/AspNetWebFormsPivotFieldCalculationBindings/Default.aspx.vb#L15

Try
    fieldProductName.FilterValues.Clear()
    fieldProductName.FilterValues.Add("Chai")

aspxpivotgrid-layout-upgrade-event/VB/ASPxPivotGridLayoutUpgradeEvent/Default.aspx.vb#L14

Try
    fieldProductName.FilterValues.Clear()
    fieldProductName.FilterValues.Add("Chai")

pivot-grid-for-winforms-layout-upgrade/VB/WinPivotUpgradeLayout/Form1.vb#L32

Try
    fieldProductName.FilterValues.Clear()
    fieldProductName.FilterValues.Add("Chai")