Search results

Label filtering

Label filtering allows you to view the pivot grid with particular records of a field based on headers. Label filtering can be enabled by setting the allowLabelFilter property to true. The following are the three different types of available label filtering:

  • Text or label filtering.
  • Date filtering.
  • Number filtering.

Label filtering through UI

Label filtering can be performed through the UI option available in the grouping bar and field list at runtime.

Text or label filtering through code

Text or label filtering allows you to view the pivot grid with particular records of a field based on text. For example, to show only the groups for France, apply the text france with filter operator Equals on the country field.

Label filtering can be configured using the filterSettings option through code-behind. The settings required to filter at initial rendering are:

  • name: Sets the field name.
  • type: Sets the filter type as Label to the field.
  • condition: Sets the operator type such as equals, greater than, less than, etc.
  • value1: Sets the start value.
  • value2: Sets the end value. It is applicable only for the operator such as ‘Between’ and ‘NotBetween’.

Operators that can be used in label filtering are:

Operator Description
Equals Displays the pivot grid that matches with the text.
DoesNotEquals Displays the pivot grid that does not match with the given text.
BeginWith Displays the pivot grid that begins with text.
DoesNotBeginWith Displays the pivot grid that does not begins with text.
EndsWith Displays the pivot grid that ends with text.
DoesNotEndsWith Displays the pivot grid that does not ends with text.
Contains Displays the pivot grid that contains text.
DoesNotContains Displays the pivot grid that does not contain text.
GreaterThan Displays the pivot grid when the text is greater.
GreaterThanOrEqualTo Displays the pivot grid when the text is greater than or equal.
LessThan Displays the pivot grid when the text is lesser.
LessThanOrEqualTo Displays the pivot grid when the text is lesser than or equal.
Between Displays the pivot grid that records between the start and end text.
NotBetween Displays the pivot grid that does not record between the start and end text.
tagHelper
Filtering.cs
<ejs-pivotview id="PivotGrid" height="300">
    <e-datasource data="@ViewBag.data" expandAll="false" allowLabelFilter="true">
        <e-filtersettings>
            <e-field name="Country" type="Label" condition="GreaterThan" value1="United Kingdom"></e-field>
        </e-filtersettings>
        <e-rows>
            <e-field name="Country"></e-field>
            <e-field name="Products"></e-field>
        </e-rows>
        <e-columns>
            <e-field name="Year" caption="Production Year"></e-field>
            <e-field name="Quarter"></e-field>
        </e-columns>
        <e-values>
            <e-field name="Sold" caption="Units Sold"></e-field>
            <e-field name="Amount" caption="Sold Amount"></e-field>
        </e-values>
    </e-datasource>
</ejs-pivotview>
public ActionResult Index()
{
    var data = GetPivotData();
    ViewBag.data = data;    
    return View();
}

Date filtering through code

Date filtering allows you to view the pivot grid with particular records of a field based on date. For example, to show only the groups for the year 2016, apply the value as 2016 with the filter operator Equals on the year field.

Date filtering can be configured using the filterSettings option through code-behind. The settings required to filter at initial rendering are:

  • name: Sets the field name.
  • type: Sets the filter type as Date to the field.
  • condition: Sets the operator type such as equals, before, after, etc.
  • value1: Sets the start date.
  • value2: Sets the end date. It is applicable only for the operator such as ‘Between’ and ‘NotBetween’.

Operators that can be used in date filtering are:

Operator Description
Equals Displays the pivot grid that matches with the given date.
DoesNotEquals Displays the pivot grid that does not match with the given date.
Before Displays the records on the pivot grid before to the given date.
BeforeOrEqualTo Displays the records on the pivot grid before or equal to the given date.
After Displays the records on the pivot grid after to the given date.
AfterOrEqualTo Display the records on the pivot grid after or equal to the given date.
Between Displays the pivot grid that records between the start and end dates.
NotBetween Displays the pivot grid that does not record between the start and end dates.

Date filtering option is enabled only when the field has date type formatsettings.

tagHelper
Filtering.cs
<ejs-pivotview id="PivotGrid" height="300">
    <e-datasource data="@ViewBag.data" expandAll="false" allowLabelFilter="true">
        <e-filtersettings>
            <e-field name="Year" type="Date" condition="Before" value1=new DateTime("2016,1,1")></e-field>
        </e-filtersettings>
        <e-formatsettings>
            <e-field name="Year" format="dd/MM/yyyy-hh:mm" type="date"></e-field>
        </e-formatsettings>
        <e-rows>
            <e-field name="Country"></e-field>
            <e-field name="Products"></e-field>
        </e-rows>
        <e-columns>
            <e-field name="Year" caption="Production Year"></e-field>
            <e-field name="Quarter"></e-field>
        </e-columns>
        <e-values>
            <e-field name="Sold" caption="Units Sold"></e-field>
            <e-field name="Amount" caption="Sold Amount"></e-field>
        </e-values>
    </e-datasource>
</ejs-pivotview>
public ActionResult Index()
{
    var data = GetPivotData();
    ViewBag.data = data;    
    return View();
}

Number filtering through code

Number filtering allows you to view the pivot grid with particular records of a field based on numbers. For example, to show only the groups less than the value 40000, apply the value as 40000 with filter operator LessThan on the amount field.

Number filtering can be configured using the filterSettings option through the code-behind. The settings required to filter at initial rendering are:

  • name: Sets the field name.
  • type: Sets the filter type as Number to the field.
  • condition: Sets the operator type such as equals, greater than, less than, etc.
  • value1: Sets the start value.
  • value2: Sets the end value. It is applicable only for the operator such as ‘Between’ and ‘NotBetween’.

Operators that can be used in date filtering are:

Operator Description
Equals Displays the pivot grid that matches with the number.
DoesNotEquals Displays the pivot grid that does not match with the given number.
GreaterThan Displays the pivot grid when the number is greater.
GreaterThanOrEqualTo Displays the pivot grid when the number is greater than or equal.
LessThan Displays the pivot grid when the number is lesser.
LessThanOrEqualTo Displays the pivot grid when the number is lesser than or equal.
Between Displays the pivot grid that records between start and end numbers.
NotBetween Displays the pivot grid that does not record between the start and end numbers.

Number filtering option is enabled only when the field contains the number format.

tagHelper
Filtering.cs
<ejs-pivotview id="PivotGrid" height="300">
    <e-datasource data="@ViewBag.data" expandAll="false" allowLabelFilter="true">
        <e-filtersettings>
            <e-field name="Amount" type="Number" condition="LessThan" value1="40000"></e-field>
        </e-filtersettings>
        <e-rows>
            <e-field name="Country"></e-field>
            <e-field name="Products"></e-field>
        </e-rows>
        <e-columns>
            <e-field name="Year" caption="Production Year"></e-field>
            <e-field name="Quarter"></e-field>
        </e-columns>
        <e-values>
            <e-field name="Sold" caption="Units Sold"></e-field>
            <e-field name="Amount" caption="Sold Amount"></e-field>
        </e-values>
    </e-datasource>
</ejs-pivotview>
public ActionResult Index()
{
    var data = GetPivotData();
    ViewBag.data = data;    
    return View();
}