Difference between revisions of "QlikView Variables"
>Johno |
>Kevint |
||
| (2 intermediate revisions by 2 users not shown) | |||
| Line 9: | Line 9: | ||
: 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. | : 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. | ||
| − | ''' | + | '''CurrentDate''' |
: The most recent date (YYYY-MM-DD) in the document. This date is not necessarily selected, but the variable always contains this value. | : The most recent date (YYYY-MM-DD) in the document. This date is not necessarily selected, but the variable always contains this value. | ||
| − | ''' | + | '''MonthStart''' |
: 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. | : 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. | ||
| Line 19: | Line 19: | ||
: 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. | : 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. | ||
| − | ''' | + | '''WeekStart''' |
: 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. | : 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''' | '''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. | : 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. | ||
Latest revision as of 22:02, 5 December 2018
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.
CurrentDate
- The most recent date (YYYY-MM-DD) in the document. This date is not necessarily selected, but the variable always contains this value.
MonthStart
- 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.
WeekStart
- 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.
