Difference between revisions of "QlikView Variables"
>Johno (Created page with "QlikView variables may be used in a variety of ways during document distribution. The syntax to access a variable is the same as in QlikView: $(varname) Variables may be us...") |
>Johno |
||
| Line 1: | Line 1: | ||
QlikView variables may be used in a variety of ways during document distribution. The syntax to access a variable is the same as in QlikView: $(varname) | QlikView variables may be used in a variety of ways during document distribution. The syntax to access a variable is the same as in QlikView: $(varname) | ||
| − | Variables may be used in file | + | Variables may be used in file names, sheet names and in selections. |
The following variables are available in the standard Vital Signs documents: | The following variables are available in the standard Vital Signs documents: | ||
Revision as of 22:18, 19 April 2013
QlikView variables may be used in a variety of ways during document distribution. The syntax to access a variable is the same as in QlikView: $(varname)
Variables may be used in file names, sheet names and in selections.
The following variables are available in the standard Vital Signs documents:
Membership_Anaylsis_by_ACCOUNT
PriorMonthDate
- The date (YYYY-MM-DD) of the prior month in the document. This date is not necessarily selected, but the variable always contains this value.
Current Date
- The most recent date (YYYY-MM-DD) in the document. This date is not necessarily selected, but the variable always contains this value.
MonthBegin
- The date (YYYY-MM-DD) of the beginning of the month for the currently selected date. This value will change to reflect the current selection.
MonthEnd
- The date (YYYY-MM-DD) of the end of the month for the currently selected date. This value will change to reflect the current selection.
WeekBegin
- The date (YYYY-MM-DD) of the beginning of the week (Sunday) for the currently selected date. This value will change to reflect the current selection.
WeekEnd
- The date (YYYY-MM-DD) of the end of the week (Saturday) for the currently selected date. This value will change to reflect the current selection.
