topic Re: function that returns date for the Sunday of the week input date belongs to in App Development

function that returns date for the Sunday of the week input date belongs to

DoctorPolidori — Sun, 21 Jan 2024 18:09:12 GMT

LOAD script question:

Given a date e.g. ‘2024-01-18’ I need a function that returns a date for the Sunday of the week my input date belongs to.

getSundayDate(‘2024-01-08’) should return ‘2024-01-14’ i.e. Sunday date of that week
getSundayDate(‘2024-01-18’) should return ‘2024-01-21’

Re: function that returns date for the Sunday of the week input date belongs to

DoctorPolidori — Sun, 21 Jan 2024 18:32:57 GMT

WeekEnd (script and chart function)
weekend - script and chart function | Qlik Sense on Windows Help

Example:

if(IsNull(queue_exit), Floor(WeekEnd([queue_enter_time]))-Floor([queue_enter_time]), if(Floor([queue_exit])-Floor([KO_STARTTID])>7,7,Floor([queue_exit])-Floor([queue_enter_time])) ) AS days_in_queue_that_week