Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have brough a week from my date column now i need to take the first day of selected week..... what is function in qlikview..... ?
WeekStart( date [, shift = 0 [,weekoffset = 0]] )
Returns a value corresponding to a timestamp with the first millisecond
of the first date ( Monday ) of the calendar week containing
date. The default output format will be the DateFormat set in the
script. Shift is an integer, where the value 0 indicates the week
which contains date. Negative values in shift indicate preceding
weeks and positive values indicate succeeding weeks. If you want to
work with weeks not starting midnight between Sunday and Monday,
you may indicate an offset in days in weekoffset. This may be
given as a real number indicating days and/or fractions of a day
firstworkdate( end_date, no_of_workdays {, holiday} )
Returns the latest starting date to acheive number_of_workdays
(Monday-Friday) ending no later than end_date taking into account
any optionally listed holidays. End_date and number_of_workdays
should be valid dates or timestamps.