Class PivotViewConditionalSetting
Inheritance
Namespace: Syncfusion.EJ2.PivotView
Assembly: Syncfusion.EJ2.dll
Syntax
public class PivotViewConditionalSetting : EJTagHelper
Constructors
PivotViewConditionalSetting()
Declaration
public PivotViewConditionalSetting()
Properties
Conditions
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 Condition Conditions { get; set; }
Property Value
Type | Description |
---|---|
Condition | The default value is Condition.NotEquals |
Label
Allows you to specify the row or column header to get visibility of hyperlink option for specific row or column header.
Declaration
public string Label { get; set; }
Property Value
Type | Description |
---|---|
System.String | The default value is null |
Measure
Allows you to specify the value field caption to get visibility of hyperlink option for specific measure.
Declaration
public string Measure { get; set; }
Property Value
Type | Description |
---|---|
System.String | The default value is null |
Value1
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 double Value1 { get; set; }
Property Value
Type | Description |
---|---|
System.Double | The default value is null |
Value2
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 double Value2 { get; set; }
Property Value
Type | Description |
---|---|
System.Double | The default value is null |