Class PivotViewConditionalSettingBuilder
Inheritance
Namespace: Syncfusion.EJ2.PivotView
Assembly: Syncfusion.EJ2.dll
Syntax
public class PivotViewConditionalSettingBuilder : ControlBuilderConstructors
PivotViewConditionalSettingBuilder()
Declaration
public PivotViewConditionalSettingBuilder()PivotViewConditionalSettingBuilder(List<PivotViewConditionalSetting>)
Declaration
public PivotViewConditionalSettingBuilder(List<PivotViewConditionalSetting> collection)Parameters
| Type | Name | Description |
|---|---|---|
| System.Collections.Generic.List<PivotViewConditionalSetting> | collection |
Methods
Add()
Declaration
public void Add()Conditions(Condition)
Allows you to choose the operator type such as equals, greater than, less than, etc. The available operators are as follows:
LessThan: Allows you to get the cells that have a value that is less than the start value.
GreaterThan: Allows you to get the cells that have a value that is greater than the start value.
LessThanOrEqualTo: Allows you to get the cells that have a value that is lesser than or equal to the start value.
GreaterThanOrEqualTo: Allows you to get the cells that have a value that is greater than or equal to the start value.
Equals: Allows you to get the cells that have a value that matches with the start value.
NotEquals: Allows you to get the cells that have a value that does not match with the start value.
Between: Allows you to get the cells that have a value that between the start and end value.
NotBetween: Allows you to get the cells that have a value that is not between the start and end value.
Declaration
public PivotViewConditionalSettingBuilder Conditions(Condition conditions)Parameters
| Type | Name | Description |
|---|---|---|
| Condition | conditions |
Returns
Label(String)
Allows you to specify the row or column header to get visibility of hyperlink option for specific row or column header.
Declaration
public PivotViewConditionalSettingBuilder Label(string label)Parameters
| Type | Name | Description |
|---|---|---|
| System.String | label |
Returns
Measure(String)
Allows you to specify the value field caption to get visibility of hyperlink option for specific measure.
Declaration
public PivotViewConditionalSettingBuilder Measure(string measure)Parameters
| Type | Name | Description |
|---|---|---|
| System.String | measure |
Returns
Value1(Double)
Allows you to set the start value to get visibility of hyperlink option based on the condition applied. For example, if the start value is 500 and the condition Equals is used, the hyperlink should be enabled to the cells that hold the value of 500 alone.
Declaration
public PivotViewConditionalSettingBuilder Value1(double value1)Parameters
| Type | Name | Description |
|---|---|---|
| System.Double | value1 |
Returns
Value2(Double)
Allows you to set the end value to get visibility of hyperlink option based on the condition applied. For example, if the start value is 500, the end value is 1500 and the condition Between is used, the hyperlink should be enabled to the cells that holds the value between 500 to 1500.
This option will be used by default when the operator Between and NotBetween is chosen to apply.
Declaration
public PivotViewConditionalSettingBuilder Value2(double value2)Parameters
| Type | Name | Description |
|---|---|---|
| System.Double | value2 |