Difference between revisions of "QlikView Variables"

From Vital Soft Wiki
Jump to: navigation, search
>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.
  
'''Current Date'''
+
'''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.
  
'''MonthBegin'''
+
'''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.
  
'''WeekBegin'''
+
'''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.