Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi folks,
what is the out put for these let expressions. these are from qlikview sample(data visualization )
i have to use this logic to build the calender in my dashboard.
plz help me out .
5 expression out put required
thank u in advance
vTodaysDate = num(Makedate(2009, 4, 30));
LET
vCurrentWeekStart = num(weekstart($(vTodaysDate)));
LET
vStartDate = num(AddMonths(YearStart($(vTodaysDate)), - 2 * 12));
Let
vAdjNum = floor(num($(vStartDate)) - MakeDate(2003, 1, 1));
Let
vStockAdjMonths = floor((num($(vStartDate)) - MakeDate(2005, 8, 1)) / 30);
vTodaysDate = num(Makedate(2009, 4, 30));-> make a date 4/30/2009 if format is MM/DD/YYYY
LET
vCurrentWeekStart = num(weekstart($(vTodaysDate)-> difference of start date and 8/1/2005
));
LET
vStartDate = num(AddMonths(YearStart($(vTodaysDate)
), - 2 * 12));
Yearstart of 2 years back or 24 months back
Let
vAdjNum = floor(num($(vStartDate)) - MakeDate
(2003, 1, 1)); difference of start date and 1/1/2003
Let
vStockAdjMonths = floor((num($(vStartDate)) - MakeDate
(2005, 8, 1)) / 30);
difference of start date and 8/1/2005
hope this helps
vTodaysDate = num(Makedate(2009, 4, 30));-> make a date 4/30/2009 if format is MM/DD/YYYY
LET
vCurrentWeekStart = num(weekstart($(vTodaysDate)-> difference of start date and 8/1/2005
));
LET
vStartDate = num(AddMonths(YearStart($(vTodaysDate)
), - 2 * 12));
Yearstart of 2 years back or 24 months back
Let
vAdjNum = floor(num($(vStartDate)) - MakeDate
(2003, 1, 1)); difference of start date and 1/1/2003
Let
vStockAdjMonths = floor((num($(vStartDate)) - MakeDate
(2005, 8, 1)) / 30);
difference of start date and 8/1/2005
hope this helps