Defining a Selection - Revision history

>Johno: /* Overview */

2015-12-03T21:52:04Z

‎Overview

2013-07-09T21:55:27Z

‎Membership Sample Selections

2013-07-09T16:31:01Z

‎Common Membership Sample Selections

2013-07-09T16:22:21Z

‎Common Membership Sample Selections

2013-07-09T16:13:07Z

‎Selection Types

2013-07-09T16:12:17Z

‎Selection Types

2013-07-09T16:08:36Z

‎Selection Types

2013-04-20T00:19:09Z

‎Common Membership Sample Selections

2013-04-20T00:18:37Z

‎Common Membership Sample Selections

2013-04-20T00:09:54Z

‎Common Membership Sample Selections

@@ Line 1: / Line 1: @@
 = Overview =
-Selections are defined in the "Select Sheet" of the main [[DocumentDistribution.xls|DocumentDistribution file]], or in the "Select Sheet" of an [[Excel Template File|Excel Template file]].  A selection is a series of steps that all share the same name. Each step is entered on a separate row and is given a unique step number that determines the order of execution for that step within the overall selection.  The step is defined by the Type, TypeName and TypeValue columns which are described in [[Selection Action|more detail]].
+Selections are defined in the "Select Sheet" of the main [[DocumentDistribution.xls|DocumentDistribution file]], or in the "Select Sheet" of an [[Excel Template File|Excel Template file]].  A selection is a series of steps that all share the same name. Each step is entered on a separate row and is given a unique step number that determines the order of execution for that step within the overall selection.  The step is defined by the Type, TypeName and TypeValue columns which are described in below.
 '''Name'''

@@ Line 115: / Line 115: @@
 |EomDelq60Days || 1 || Field || vs_sel_AOD_DATE_SELECT || Current Date
 |-
-|EomDelq60Days || 2 || SetVar || CalcDays60 || =60-round(MonthEnd(vs_sel_AS_OF_DATE)-vs_sel_AS_OF_DATE)
+|EomDelq60Days || 2 || SetVar || CalcDays60 || =60 - floor(MonthEnd(vs_sel_AS_OF_DATE)-vs_sel_AS_OF_DATE)
 |-
 |EomDelq60Days || 3 || Field || LN_DAYS_DELINQUENT || >=$(CalcDays60)
 |}

@@ Line 79: / Line 79: @@
      |}
-== Common Membership Sample Selections ==
+== Membership Sample Selections ==
 * '''ClearAll'''
@@ Line 115: / Line 115: @@
 |EomDelq60Days || 1 || Field || vs_sel_AOD_DATE_SELECT || Current Date
 |-
-|EomDelq60Days || 2 || SetVar || CalcDays60 || =60-(
+|EomDelq60Days || 2 || SetVar || CalcDays60 || =60-round(MonthEnd(vs_sel_AS_OF_DATE)-vs_sel_AS_OF_DATE)
 |-
-|EomDelq60Days || 3 || SetDim || LoanDims2 || LN_CREDIT_TIER_DESC
+|EomDelq60Days || 3 || Field || LN_DAYS_DELINQUENT || >=$(CalcDays60)
 |}

@@ Line 87: / Line 87: @@
 * '''SetLoanDims'''
 : Sets the loan dimensions for a pivot to the collateral code and the credit tier (paper grade)
+* '''EomDelq60Days
 {| class="wikitable" stype="border-spacing: 2, 2, 2, 2;"
 |-
@@ Line 108: / Line 109: @@
 |SetLoanDims || 1 || SetDim || LoanDims1 || LN_COLLATERAL_DESC
 |-
-|SetLoanDims || 1 || SetDim || LoanDims2 || LN_CREDIT_TIER_DESC
+|SetLoanDims || 2 || SetDim || LoanDims2 || LN_CREDIT_TIER_DESC
 |}

@@ Line 69: / Line 69: @@
       |-
       | '''SetVar''' || VarName || expression || Sets the specified variable to the expression
-: "Note: If the variable does not exist, it will be created."
+: ''Note: If the variable does not exist, it will be created.''
-: "Note: QlikView expressions must be prefixed by an equals.  Change the Excel cell formatting to text so that Excel will not attempt to evaluate the expression."
+: ''Note: QlikView expressions must be prefixed by an equals.  Change the Excel cell formatting to text so that Excel will not attempt to evaluate the expression.''
       |-
+      |

@@ Line 65: / Line 65: @@
       |-
       | '''SetDim''' || [[VitalSigns Chart Dimensions|DimName]] || value || Selects the specified value in the GROUP to set a dimension
       |-
+      |

@@ Line 78: / Line 78: @@
 : Clear all fields
 * '''NewMbrs'''
-: Clear all fields, Set to Prior Month and Select Member Open Date from the Prior Month
+: Clear all fields, set to Prior Month and select Member Open Date from the Prior Month
 * '''SetLoanDims'''
 : Sets the loan dimensions for a pivot to the collateral code and the credit tier (paper grade)

@@ Line 74: / Line 74: @@
 == Common Membership Sample Selections ==
 {| class="wikitable" stype="border-spacing: 2, 2, 2, 2;"
 |-
 |'''Name''' || '''Step''' || '''Type''' || '''TypeName''' || '''TypeValue'''
 |-
 |ClearAll || 1 || ClearAll || ||
@@ Line 85: / Line 94: @@
 |NewMbrs || 1 || ClearAll || ||
 |-
-|NewMbrs || 2 || Field || vs_sel_AOD_DATE_SELECT || Current
+|NewMbrs || 2 || Field || vs_sel_AOD_DATE_SELECT || Prior Month
 |-
 |NewMbrs || 3 || Field || MBR_OPEN_DATE || >=$(MonthStart)<=$(MonthEnd)