QlikView Variables

From Vital Soft Wiki
Revision as of 17:09, 13 June 2013 by >Johno (Membership_Anaylsis_by_ACCOUNT)
Jump to: navigation, search

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.