Discussion board where members can get started with QlikView.
I am setting a variable to a date value in the load script as below
LET vMonth = MakeDate(Year(Today()),Month(Today())-6,1);
At a later point in the script, i am setting a filed in a table using this variable
$(vMonth) as Validation_Month
While the variable seems to be set properly, the $ sign expansion seems to be returning a value of -21.
Not sure why this is happening.
SET vMonth = Date(MonthStart(Today(), -6));
'$(vMonth)' as Validation_Month