Difference between revisions of "QlikView Variables"
>Johno (→Membership_Anaylsis_by_ACCOUNT) |
>Kevint |
| (One intermediate revision by the same user not shown) | |
(No difference)
| |
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.
