topic Re: help required for weekstart function in QlikView

help required for weekstart function

sayadutt — Sun, 31 May 2015 06:30:20 GMT

Hi All,

I have a requirement to print the weekstart date from a given date.

I am using this function in Text Object

=(weekstart('5/31/2015'))

Now the above function returns 5/25/2015, which is last Monday.

But my requirements is, weeks should be from Saturday to Friday and not Monday to Sunday. So above expression should return 5/30/2015 (yesterday, Saturday)

I even tried to change the DayNames variable in Edit Script to start from Saturday, instead of Monday. But no luck.

Can you please help me how I can do this.

Thanks

Re: help required for weekstart function

Sun, 31 May 2015 06:58:23 GMT

Use dual WeekStart (date [, period_no = 0 [, week_start = 0]]) to get required value.

In your case :

=WeekStart('5/31/2015',0,5) results 5/30/2015

Re: help required for weekstart function

Sun, 31 May 2015 06:58:53 GMT

Try this

=Date(weekstart('5/31/2015')-2)

Re: help required for weekstart function

maxgro — Sun, 31 May 2015 08:35:12 GMT

maybe

=weekstart('5/31/2015', 0, 5)

this is from Qlik help

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, indicate an offset in days in weekoffset. This may be given as a real number indicating days and/or fractions of a day.

Re: help required for weekstart function

MarcoWedel — Sun, 31 May 2015 12:59:07 GMT

Hi,

maybe this helps:

regards

Marco