lunarweekend - script and chart function

This function returns a value corresponding to a timestamp of the last millisecond of the lunar week containing date. Lunar weeks in QlikView are defined by counting 1 January as the first day of the week.

Syntax:  

LunarweekEnd(date[, period_no[, first_week_day]])

Return data type: dual

Arguments:  

Argument Description
date The date to evaluate.
period_no period_no is an integer or expression resolving to an integer, where the value 0 indicates the lunar week which contains date. Negative values in period_no indicate preceding lunar weeks and positive values indicate succeeding lunar weeks.
first_week_day An offset that may be greater than or less than zero. This changes the beginning of the year by the specified number of days and/or fractions of a day.

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?