Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

firstworkdate of the week

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..... ?

2 Replies
Not applicable
Author

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

Not applicable
Author

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.